Philip Hallstrom wrote:
>> pgpool is a connection pool server for PostgreSQL. pgpool runs between
>> PostgreSQL's clients(front ends) and servers(back ends).
>>
>> Well there are a few solutions out there.
>>
>> The first comparable product for MySQL is MySQL Proxy.
>> http://forge.mysql.com/wiki/MySQL_Proxy
>
> Almost, but the faq says it's not quite there (auto splitting
> reads/writes).
>
> http://forge.mysql.com/wiki/MySQL_Proxy_FAQ#In_load_balancing.2C_how_can_I_separate_reads_from_writes.3F
>
>
> Will be nice once it is though!
>
> -philip
>
You are correct, right out of the box it does not split read/writes.
Lua script can be written to intercept the query, and then change the connection
to a mysql host based on read/write.
I have not heard of a success story yet, but there is a Lua script written for
read/write splitting that is distributed with MySQL Proxy:
{MySQLProxy_install_dir}/share/mysql-proxy/rw-splitting.lua
There is a post on Aug 26 on Proxy's R/W Splitting:
http://jan.kneschke.de/2007/8/26/mysql-proxy-more-r-w-splitting
There was a post a few days ago in the MySQL Proxy Forum about a problem
http://forums.mysql.com/read.php?146,180080,180080
Also a related bug:
http://bugs.mysql.com/bug.php?id=31574
-RG
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
