List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:April 20 2011 5:10pm
Subject:PECL: "mysqlnd_ms" (Load-Balancing)
View as plain text

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,

Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
PECL: "mysqlnd_ms" (Load-Balancing)Reindl Harald20 Apr