We just moved a large Invision Power Board forum to a 2 node Percona Cluster (behind HAProxy) from a single Percona server. As soon as the load on the forum goes up, servers quickly become desynchronized and depending on which node is hit, different data is displayed.
Nodes were configured according to: [URL=“http://www.percona.com/doc/percona-xtradb-cluster/howtos/cenots_howto.html#centos-howto”]http://www.percona.com/doc/percona-x...l#centos-howto[/URL]
Both are showing they are in sync when running the following command:
show status like 'wsrep%';
Error logs are empty on both nodes.
Is XtraDB Cluster not fast enough to keep up with this type of usage? CPU load and memory usage are very low on both servers so I’m not sure what could be the problem.
As soon as HAProxy configuration is adjusted to send all requests to a single server, all problems disappear.
Also, it seems that data was not just delayed between the hosts, but some of it was never duplicated. Shouldn’t sync errors show up in log files?
I can verify that replication works by adding data on any of the nodes and accessing it from any other node, but forum content is still completely out of sync. What could cause this?
This may be a stupid question, but does DB need to be offline during the initial SST copy? It seems that only DB content from the initial copy at node start gets replicated, but nothing after that.
Any help is appreciated.