[TYPO3-dev] load ballancing and mysql master/slave architecture

[Bartosz Aninowski]

  might better ask this on a mysql list I guess.
> 
> It seems that you will need kind of a local proxy for MySQL that will 
> forward queries either to the master server or to one of the slaves 
> because you cannot define two different servers in TYPO3 to be used for 
> SELECT or for UPDATE/INSERT/DELETE only.
> 
> And after a 30 sec search on Google I think MySQL Proxy: 
> http://forge.mysql.com/wiki/MySQL_Proxy is your friend :-)

I know this tool, ufortunately it is not open sorce.
Anyway I found some solution in extension t3p_scalable.
It works with memcache but it can separate read and write queries.