Re: replication - Sebastien LELIEVRE - com.mysql.lists.cluster

7 messages in com.mysql.lists.clusterRe: replication

From	Sent On	Attachments
gdi...@libero.it	04 May 2007 00:37
Sebastien LELIEVRE	04 May 2007 00:45
Sebastien LELIEVRE	04 May 2007 01:11
Geert Vanderkelen	04 May 2007 01:41
gdi...@libero.it	04 May 2007 09:20
Jimmy Guerrero	04 May 2007 09:41
Matthew Montgomery	04 May 2007 14:45

Subject:	Re: replication
From:	Sebastien LELIEVRE (slel...@tbs-internet.com)
Date:	05/04/2007 01:11:32 AM
List:	com.mysql.lists.cluster

gdi...@libero.it a écrit :

For what I see mySql guarantee syncronous replication. Does it guarantee asyncronous replication? I mean in a such instant i want that
remote and local data base do sync!

Yes, Asynchronous Replication is also supported.

Where could I find usefull documentations?

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster.html and http://www.mysql.com/why-mysql/white-papers/ (those regarding to High-Availability and Clustering) are the best place to start with :)

Regards,

Sebastien.

gdi...@libero.it a écrit :

Does MySql support a valid replication system?

MySQL Cluster uses synchronous replication through a two-phase commit mechanism.

http://en.wikipedia.org/wiki/Two-phase_commit

Oracle offers Multimaster and materialized view.Does MySql 5 strong enough to
guaratee such methods?

By Multimaster, would you mean load-balancing between nodes ? If so, yes, it can offer that. Some white papers explains you how to achieve such a configuration.

Regards,