Hello;
I had a crash on my donor node so I wanted to pass one of the machines in the cluster node as donor.
The configuration file for the node that must pass donor is below:
The MySQL server
[mysqld]#skip-external-locking
Try number of CPU’s*2 for thread_concurrency
thread_concurrency = 8
#######################################################Configuration Percona
wsrep_cluster_address=gcomm://node1,node2,node3
datadir=/var/lib/mysql
Path to Galera library
wsrep_provider=/usr/lib64/libgalera_smm.so
In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
MyISAM storage engine has only experimental support
default_storage_engine=InnoDB
This is a recommended tuning variable for performance
innodb_locks_unsafe_for_binlog=1
This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2
Node #3 address
wsrep_node_address=@ip_node3
SST method
wsrep_sst_method=xtrabackup
Cluster name
wsrep_cluster_name=cluster_name
Authentication for SST method
wsrep_sst_auth=“sstuser:PWD”
wsrep_sst_donor= node3
server-id = 3
When I restart the new node donor without any parameters with / etc / init.d / mysql restart - wsrep-cluster-address = gcomm
Case 1: Now when I want to add other machines in the cluster.Et I get the following error:
140123 11:26:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140123 11:27:06 [Note] WSREP: Service disconnected.
140123 11:27:07 mysqld_safe mysqld from pid file /var/lib/mysql/node3.pid ended
Case 2: I start the donor machine and 2 other machines I add wsrep-cluster-address = gcomm
140123 14:40:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140123 14:40:59 [Note] WSREP: view(view_id(NON_PRIM,3c8938b5-841d-11e3-0800-fac3799a7d7e,2) memb {
The configurations of the other two machines are as follows:
wsrep_provider_options=“gmcast.listen_addr=tcp://0.0.0.0:4567”
wsrep_cluster_address=gcomm://node3:4567
datadir=/var/lib/mysql
user=mysql
Path to Galera library
wsrep_provider=/usr/lib64/libgalera_smm.so
In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
MyISAM storage engine has only experimental support
default_storage_engine=InnoDB
This is a recommended tuning variable for performance
innodb_locks_unsafe_for_binlog=1
This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2
Node #1 address
wsrep_node_address=@ip_node
SST method
wsrep_sst_method=xtrabackup
Cluster name
wsrep_cluster_name=cluster_name
Authentication for SST method
wsrep_sst_auth=“sstuser:MDP”
Don’t listen on a TCP/IP port at all. This can be a security enhancement,
if all processes that need to connect to mysqld run on the same host.
All interaction with mysqld must be made via Unix sockets or named pipes.
Note that using this option without enabling named pipes on Windows
(via the “enable-named-pipe” option) will render mysqld useless!
#skip-networking
Replication Master Server (default)
binary logging is required for replication
log-bin=mysql-bin
/, mysql starts without problem.