From: Reindl Harald
Date: April 20 2011 5:10pm
Subject: PECL: "mysqlnd_ms" (Load-Balancing)
List-Archive: http://lists.mysql.com/mysql/224832
Message-Id: <4DAF1370.3010605@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig0E1FE7E21C8B5A30BEFEC121"

--------------enig0E1FE7E21C8B5A30BEFEC121
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 l=
ibrary.
> It can be used with PHP MySQL extensions (ext/mysql, ext/mysqli, PDO_My=
SQL).
> 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 s=
lave servers
> all other queries are redirected to the MySQL replication master server=
=2E Very little,
> if any, application changes required, dependent on the usage scenario r=
equired.

--=20

Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofm=FChlgasse 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


--------------enig0E1FE7E21C8B5A30BEFEC121
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk2vE3AACgkQhmBjz394AnkJwACfejZuxasiemK6Gj4LDnI9J4WE
24gAnjCh2OjrIj4tbpRGByCo5yrOXh3p
=bUFE
-----END PGP SIGNATURE-----

--------------enig0E1FE7E21C8B5A30BEFEC121--