This is the second part of my series on High Availability with mysqlnd_ms. In my first post, “Simple MySQL Master HA with mysqlnd_ms,” I showed a simple HA solution using asynchronous MySQL replication. This time we will see how to leverage an all-primary cluster where you can write to all nodes.
I had the pleasure of presenting to the PHP Users Group Philippines a few days ago about mysqlnd_ms. The mysqlnd plugin, MySQL Master Slave, is a transparent layer on top of mysqlnd extension. This allows you to do read-write splitting and slave reads load balancing without needing to change anything from your application. But do you know you can also achieve a form of high availability with this plugin?
Please RSVP for next Monday’s North Texas MySQL Users Group Meeting so we will know how much pizza to order.
MYSQL Tuning Trick for Queries and Server Tuning
Monday July 14th 6PM!
Event is free to the public. Newbies welcome!
Presented By: Dave Stokes, MySQL Community Manager North America, Oracle Corporation
Plus meet Oracle Ace, Oracle MySQL Ace, and IOUG Big Shot George Trujillo who has recently moved to DFW.