MySQL alternative to PostgreSQL"s pgpool2?

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" to both
servers (replication) so that their content is identical.


With MySQL, what tool should I use to achieve a similar setup?



[1] http://pgpool.projects.postgresql.org/


--
Tomasz Chmielewski
http://wpkg.org

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: MySQL alternative to PostgreSQL"s pgpool2?

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 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" to both
> servers (replication) so that their content is identical.
>
>
> With MySQL, what tool should I use to achieve a similar setup?
>
>
>
> [1] http://pgpool.projects.postgresql.org/
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org