replication is actually more functional in MySQL Cluster than with InnoDB:
- You have support for synchronous replication between data nodes within
- If you want to replicate that cluster to a remote data center (or
another rack within the same data center), then you can use MySQL's
native asynchronous replication, but unlike InnoDB, this is
Active/Active, so the cluster will detect and handle conflicts for you
MySQL Cluster does not support Foreign Keys today. You can use triggers
as an alternative - this article demonstrates how to do that:
Are your Foreign Key requirements for constraint checking, or do you
need functionality like cascading updates and deletes as well?
On 31/10/2011 10:03, joan agusti martinez carbonell wrote:
> I have a three servers with mysql cluster, 1 node of managment and 2 nodes of data.
> The replication works very good but when I create a database I didn't have foreign keys.
> My question is, in labs you have a version mysql-cluster-gpl-7.2.2-labs-memcached, this
> version supports foreign keys? If it's necesary for me have foreign keys and replication
> the correct option is InnoDB?
> Excuse my bad english,
> Thank You,
MySQL Cluster& HA Programs
+44 (0)7765 898-605
|• MySQL Cluster||joan agusti martinez carbonell||31 Oct|
| • Re: MySQL Cluster||Mat Keep||31 Oct|