I’m having quite a problem with adding a node to my current Galera cluster. Right now I have 4 nodes on my cluster: 3 of them are on my local and 1 currently on the cloud. I successfully synced my cloud node with the local servers earlier.
Now, I want to add my other cloud server to my cluster making it 5, but I want it to use the other node which is also within the cloud so it would be faster (local to cloud took like 2 hours to sync). I tried using
wsrep_sst_donor but it only fails to start the service.
All my servers are using CentOS 7 and has the same galera configuration as follows:
[galera] # Mandatory settings wsrep_on=ON wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so #add your node ips here wsrep_cluster_address="gcomm://alpha,beta,charlie,cloudmain,replica" binlog_format=row default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 #Cluster name wsrep_cluster_name="my_cluster" #Allow server to accept connections on all interfaces. bind-address=0.0.0.0 #this server ip, change for each server wsrep_node_address="replica" #this server name, change for each server wsrep_node_name="Replica Node" wsrep_sst_method=rsync
Note: they all have the same config but the name parameters are changed accordingly per server.
I tried adding:
But it is no good. Is it possible to choose a specific server to sync databases from? Thank you.