9 messages in com.mysql.lists.clusterWide area MySQL Cluster
FromSent OnAttachments
Michael Gruetzner22 Nov 2007 01:48 
Luis Motta Campos22 Nov 2007 02:11 
Martin Skold22 Nov 2007 02:44 
Luis Motta Campos22 Nov 2007 03:56 
Rayson Ho22 Nov 2007 11:02 
Eric Frazier22 Nov 2007 11:13 
Geert Vanderkelen23 Nov 2007 02:43 
Martin Skold23 Nov 2007 04:36 
Martin Skold23 Nov 2007 04:45 
Subject:Wide area MySQL Cluster
From:Michael Gruetzner (mgru@HTWM.De)
Date:11/22/2007 01:48:29 AM
List:com.mysql.lists.cluster

Hello List,

is the MySQL cluster suitable for a wide-area configuration? For example: There are 3 different sites (A, B, C), connected via WAN. Would it be possible to to install one cluster node on each site and let the clients on site A use the cluster node on site A, the clients on site B use the node on site B and so on ... ? All the inserts aund updates, made on one site need to be replicated to all the other sites.

If such a configuration is possible, how does MySQL cluster handle conflicts like duplicate primary keys (or unique-constraint violation) which may occur if the same value is inseted in two different sites and then replicated?

How does MySQL Cluster deal with network-partition and -merges?

Thank you in advance for answering my questions.

Best regards, Michael