A single MySQL server is a single point of failure. A single MySQL server can only be scaled vertically by increasing hardware size, which has its limits. That’s two good reasons to migrate from a single MySQL server to a cluster of MySQL servers. However, in cloudy white christmas times, few appreciate the extra work that using a cluster causes. For example, MySQL connections must be load balanced. Please, find a comparison of different load balancing architectures in the short presentation. Choose the one that’s best for you – maybe it is PECL mysqlnd_ms 1.2, the mysqlnd replication and load balancing plugin…
Load Balancing for PHP and MySQL
View more presentations on mysqlnd
Seasons greetings!