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/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature