http://pecl.php.net/package/mysqlnd_ms/download/1.0.0/
This is a really great idea to use replication-salves for
read-access without touch the php-application and if this
will work with "php_flag" site-specific using the available
slaves automatically / leave them out if they are stopped
this can make many setups very scaleable and much more
efficient as do the work in php-scripts with all the needed
decisions "read-query", which mysql-host and is the host
currently available
I think this would be finally a thing to directly include
in mysqlnd and leave default off
The replication and load balancing plugin is a plugin for the mysqlnd library.
It can be used with PHP MySQL extensions (ext/mysql, ext/mysqli, PDO_MySQL).
if they are compiled to use mysqlnd. The plugin inspects queries to do read-write
splitting. Read-only queries are send to configured MySQL replication slave servers
all other queries are redirected to the MySQL replication master server. Very little,
if any, application changes required, dependent on the usage scenario required.
--
Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/