Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.7
-
centos6 centos7
1. libgalera_smm.so, compile from https://github.com/MariaDB/galera.git from 3.x
2. libgalera_smm.so, galear 3, download rpm from https://galeracluster.com/
Description
I get strange error when I new a MariaDB-Galera cluster. My environment is Mariadb-10.3.14 and galera3, I build 3 MariaDB instance on one machine.
Next is the node1 and node2 config (mainly about wsrep)
wsrep_cluster_address="gcomm://9.128.x.x:23021,9.128.x.x:23022,9.128.x.x:23023" |
#wsrep_cluster_address="gcomm://" |
wsrep_node_address=9.128.x.x:23021 |
wsrep_sst_receive_address=9.128.x.x:9021 |
innodb_doublewrite=1 |
query_cache_size=0 |
query_cache_type=0 |
wsrep_node_name= node1
|
wsrep_sst_auth="willtest:will123" |
binlog_format=row
|
default_storage_engine=InnoDB
|
innodb_autoinc_lock_mode=2 |
wsrep_slave_threads=1 |
innodb_flush_log_at_trx_commit=0 |
wsrep_sst_method=rsync
|
#wsrep_sst_method=xtrabackup
|
#wsrep_causal_reads=ON
|
wsrep_on=ON
|
*This is my operation step: *
for node1: cd /usr/local/mysql/ && ./scripts/mysql_install_db --defaults-file=/etc/my.cnf.25000 --user=mysql |
for node2: cd /usr/local/mysql/ && ./scripts/mysql_install_db --defaults-file=/etc/my.cnf.25000 --user=mysql |
for node1: ./bin/mysqld_safe --defaults-file=/etc/my.cnf.25000 --wsrep-new-cluster --user=mysql & |
for node2: ./bin/mysqld_safe --defaults-file=/etc/my.cnf.25001 --user=mysql & |
Node1's status is all right, see annex 1.png
But when I add node2 and some errors happend, see annex 2.png
The annex node1.err/node2.err is the error log from instance 25000/25001
The grastate.dat of node2:
# GALERA saved state
|
version: 2.1 |
uuid: 00000000-0000-0000-0000-000000000000 |
seqno: 0 |
safe_to_bootstrap: 0 |
