The PHP replication and load balancing mysqlnd plugin as been released as an alpha through PECL. Alpha is for those who want to try out the 1.0 feature set as early as possible. Alpha is for those who do not fear debugging, if need be. Notes on troubleshooting.
Testing load balancing and read/write split
There are three ways to verify that load balancing and read/write split works as it should:
- within PHP script: checking thread/connection ids
- within PHP script: monitoring statistics
- externally: mysqlnd debug log file
Thread/connection ids to distinguish connections
PECL/mysqlnd_ms changes the semantics of a PHP MySQL connection handle. If using the plugin, a connection handle returned by any of the three PHP MySQL extensions ( …[Read more]