Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:51961
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain thelounge.net designates 91.118.73.15 as permitted sender)
Message-ID: <4DAF1370.3010605@thelounge.net>
Date: Wed, 20 Apr 2011 19:10:08 +0200
Organization: the lounge interactive design
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.15) Gecko/20110307 Fedora/3.1.9-0.39.b3pre.fc14 Lightning/1.0b3pre Thunderbird/3.1.9
MIME-Version: 1.0
To: Mailing-List php <internals@lists.php.net>, 
 Mailing-List mysql <mysql@lists.mysql.com>
OpenPGP: id=7F780279;
	url=http://arrakis.thelounge.net/gpg/h.reindl_thelounge.net.pub.txt
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig0E1FE7E21C8B5A30BEFEC121"
Subject: PECL: "mysqlnd_ms" (Load-Balancing)
From: h.reindl@thelounge.net (Reindl Harald)

--------------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--