Archiv für den Monat December, 2011

PHP MySQL documentation updates

Friday, December 23rd, 2011

The MySQL part of the PHP reference manual is currently being restructured: new landing and overview page, mysqli quickstart prepared. Ten years ago, there was the mysql extension and that was it. Today, beginners are faced with three MySQL APIs/extensions, two libraries and more than three library plugins. MySQL support by PHP has never been […]

Load balancing for PHP and MySQL

Friday, December 23rd, 2011

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 […]

Welcome PECL/mysqlnd_ms 1.2.0-alpha with global transaction ID support

Wednesday, December 14th, 2011

Christmas time, time for presents! Version 1.2.0-alpha of the free and open source PHP mysqlnd replication and load balancing plugin has been made available on PECL. PECL/mysqlnd_ms makes using any kind of MySQL database cluster easier featuring:

Read-write splitting: automatic, SQL hints, can be disabled
Load balancing: random, round robin, user defined
Fail over
Global transaction ID […]

PECL/mysqlnd_ms: quality of service filter

Monday, December 5th, 2011

What if your PHP application could tell the mysqlnd library what service quality you need when using a MySQL replication cluster? If you wanted read-your-writes, the driver would select replication nodes for you which can offer it. If you can allow replication lag but no more than three seconds, the driver would select… One function […]