mysql-proxy-discuss team mailing list archive

[Raoul Bhatia <raoul@xxxxxxxxx>]

On 30.06.2009 00:27, Daniel Lockard wrote:
> Hello,
>
> Currently I am working on a project with 2 DRBD / Heartbeat Masters, and
> three read-only replication slaves. I was thinking that throwing MySQL
> Proxy / Load Balancer in front of this set up. I was wondering how
> people are doing this, and how well it scales, as eventually I plan to
> add many more read slaves.

presently, we use mysql-proxy 0.6.1 to direct all queries to localhost
to a powerful mysql server - no read slaves here.

however, we use pacemaker & drbd to manage the mysql-server as well as
the mysql-proxy instances.

what i noticed is, that if we use "SET NAMES UTF8" and execute 100+
queries, the collation might get lost. i suspect this is related to
the connection pooling but had no time to try mysql-proxy 0.7 to
see if this issue is gone.

cheers,
raoul
--
DI (FH) Raoul Bhatia M.Sc.  |  email.  raoul@xxxxxxxxx
Software Development and    |  web.    http://www.ipax.at
System Administration       |  tel.    +43 699 10132530 (telering)

begin:vcard
fn:Raoul Bhatia
n:Bhatia;Raoul
email;internet:raoul@xxxxxxxxx
tel;cell:+43 699 10132530
version:2.1
end:vcard