Proxy v0.7 and Drupal 6.x - Balancing master-slave

Hi Herve,

> But we are stuck when:
> - We try to balance on 2 databases (master-slave and master-master)
> - What happens is that some results sets are incomplete and we get an incomplete page (missing data)

This is what happens and why you see this problem:

1- You send many insert statements to the master
2- The slave starts replicating those changes, but it is not doing it
fast enough
3- You send some select statements through the proxy, the proxy sends
them to the slave, but as the slave does not have all the rows yet,
you get partial results.

>
> We have bee trying to implemnent the following scripts and we get the error I just explained:
> - databaseSegment.lua

Haven;t tried yet

> - rwsplitting
>

This script is more of a proof of concept than a full solution.
It was meant to give you an idea of what you can do, but you still
need to modify it for your needs, there are some cases where it works
out of the box.

> Furthermore, does anyone know when rw-splitting2.lua will be released?
>

Looking at http://www.cdalexander.net/mysql.php#rwsplitting2
it says they stopped working on it.

This link
http://buytaert.net/database-replication-lag
shows some information about dupral and making it replication lag aware.

Thanks

Diego

> Any help would be really appreciated.
> Herve
>
> LINKS abouy MySQL-Proxy
> -------------------------------
> http://www.teonator.net/2008/11/25/drupal-read-write-splitting/
> http://www.johnandcailin.com/blog/john/scaling-drupal-step-four-database...
> http://www.cdalexander.net/rwsplitting2.php
> http://buytaert.net/scaling-with-mysql-replication
>
> LINK other alternatives
> -------------------------------
> http://krow.livejournal.com/595518.html
>
>
> --
> You received this question notification because you are a member of
> MySQL Proxy Discuss, which is an answer contact for MySQL Proxy.
>

--
Diego Medina
Web Developer
http://www.fmpwizard.com