[nycbug-talk] mysql replication and failover

[David Rio Deiros]

On Thu, May 25, 2006 at 11:20:31PM +0200, Massimiliano Stucchi wrote:
> On 250506, 11:39, David Rio Deiros wrote:
> > 
> > What do you guys think? Is MySQL clustering the only valid solution
> > here?
> 
> Not really.  There is this new method, available only with MySQL 5.1,
> which enables you to have master/master replication.
> 
> http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html
> 
> It'a nice feature.

Thanks for the reply Massimiliano and sorry for the late reply.

Finally I decided to implement a solution based on replication only. The
reason is because the database is going to server reads most of the 
time.

The article you sent is very interesting but there is something that 
still don't understand. When you use the autoincrement feature found
in mysql5, you're solving a problem but you are also introducing another
one since the ids are totally different between servers. That means
you have to make the application aware about it. 

Thanks,
David