MySQL alternative to PostgreSQL's pgpool2?

2009-10-25 Thread Tomasz Chmielewski
With PostgreSQL, I can use pgpool2[1] tool as a load balancer/replicator for queries: postgres_server_1\ pgpool2 --- client postgres_server_2/ Generally, pgpool will query either of the SQL servers to load balance (and failover, if one of them goes down), and send writes

Re: MySQL alternative to PostgreSQL's pgpool2?

2009-10-25 Thread Carlos Proal
Hi Tomasz There are several solutions for this, one of them, maybe the most popular, is MySQL proxy, take a look to see if solves your issues. http://forge.mysql.com/wiki/MySQL_Proxy Carlos* * On 10/25/2009 12:41 PM, Tomasz Chmielewski wrote: With PostgreSQL, I can use pgpool2[1] tool as a