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
