I’m not exactly sure where to post this… I have 3 servers in a galera cluster using mariadb and xtrabackup. Basically, everything starts out just fine. with a fresh install, I can get all 3 servers up and running and replicating, but when i stop the mysql (mariadb) service on one node, add a database on one of the two remaining nodes, and start the mysql service up again, replication fails. to my understanding, the third node should see that its contents differ from the other two in the cluster and start an sst transfer.
server config files and error logs are below. I’ve been scouring the web and can’t figure out what the problem is. could someone with more experience or knowledge lend me some advice? thank you in advance. if you need any more info let me know.
the firewall is allowing traffic between the servers on ports 3066, 4444, 4567, and 4568 and selinux is either setenforce 0 or disabled.
the cluster is hosted on centos 6 machines and the /etc/my.cnf.d/server.cnf is identical on all servers save for ip address information.
this is read by the standalone daemon and embedded servers
this is only for the mysqld standalone daemon
this is only for embedded server
These two groups are only read by MariaDB servers, not by MySQL.
If you use the same .cnf file for MySQL and MariaDB,
you can put MariaDB-only options here
/var/lib/mysql/galera*err is attached.
galera.txt (7.95 KB)