PMP - MySQL clustering vs MySQL replication
Do you know if anyone has set up MySQL to do clustering for HA instead of a primary/secondary replication?
Advantages
-
Offers multiple read and write nodes for data storage.
-
Provides automatic failover between nodes. Only transaction information for the active node being used is lost in the event of a failure.
-
Data on nodes is instantaneously distributed to the other data nodes.
Several times when we have tested rebooting the PMP server while in the middle of password requests, the replication gets corrupted. Also looking for more of a mutiple active environment for load balancing instead of Active/Passive.
-John