From: Andrew Morgan Date: July 16 2010 8:39am Subject: RE: Active Active Cluster List-Archive: http://lists.mysql.com/cluster/7686 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Hi Erez, Active-active replication is available and is in use. The main think to bear in mind is that there is some effort required on yo= ur part if you want MySQL Cluster to handle the conflict detection or resol= ution (conflict=3Dthe same row being updated on both sites at about the sam= e time). For example, you'd need to include an integer timestamp column in = each of the tables where conflicts need to be handled and maintain that at = the application layer. There are also some limitations on its use (for exam= ple, if using conflict resolution it backs out the change to the row where = the conflict occurs but not the rest of the transaction). This post walks through setting up active-active (multi-master) replicatio= n between 2 MySQL Cluster deployments... http://www.clusterdb.com/mysql-clu= ster/setting-up-mysql-asynchronous-replication-for-high-availability/ Note = that it doesn't explain how to use the conflict detection/resolution - for = that, refer to http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replica= tion-conflict-resolution.html=20 Known limitations of MySQL Cluster replication are documented at http://de= v.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-issues.html=20 Regards, Andrew. --=20 Andrew Morgan | MySQL Senior Product Manager Mobile: +447833483595=20 Web: www.clusterdb.com United Kingdom ORACLE Corporation UK Ltd is a company incorporated in England & Wales | Co= mpany Reg. No. 1782505 | Reg. office: Oracle Parkway, Thames Valley Park, R= eading RG6 1RA=20 Oracle is committed to developing practices and products that help protect = the environment > -----Original Message----- > From: Erez Epstein [mailto:erezep@stripped] > Sent: 15 July 2010 14:33 > To: cluster@stripped > Subject: Active Active Cluster >=20 > Hello >=20 > i have heard on many issued for the bad and good , about active active, >=20 > and as I'm designing a new project, would like to know if the latest > version > of mysql support active active cluster fully, > and that there are no know issues? > is it difficult to maintain such a platform? >=20 >=20 > -- > Erez >=20 > erezep@stripped >=20 > =3D=3D=3D=3D=3D > Show My Ip