Mariadb Galera Cluster 节点启动时出现如下错误:
mysqld_safe Starting mysqld daemon with databases from /3336/data
mysqld_safe WSREP: Running position recovery with –log_error=’/3336/data/wsrep_r
ecovery.NzULcc’ –pid-file=’/3336/data/test44.sys.cn-recover.pid’
[ERROR] WSREP: Only binlog_format = ‘ROW’ is currently supported. Configured value: ‘S
TATEMENT’. Please adjust your configuration.
[ERROR] Aborting
检查my.cnf 配置文件binlog_format未设置
设置binlog_format=ROW 后,能正常启动。
数据库版本
MariaDB [(none)]> select @@version;
+-----------------------+
| @@version |
+-----------------------+
| 10.0.35-MariaDB-wsrep |
+-----------------------+
MariaDB [(none)]> show global status like 'wsrep_provider_version';
+------------------------+----------------+
| Variable_name | Value |
+------------------------+----------------+
| wsrep_provider_version | 25.3.23(r3789) |
+------------------------+----------------+
1 row in set (0.00 sec)
关于Galera Cluster 中binlog写入情况:
1. 多主模式写入时,每个节点上的binlog都会变化。
2. 单点写入时,其它节点如果没有开启log_slave_updates参数,则其它节点上的binlog是不会变化的,但不影响数据同步。如果要给集群设置slave节点,提供数据的节点定要开启log_slave_updates参数。