Foreign Key constraints between tables
The newly announced GA of MySQL Cluster 7.3 (7.3.2) builds upon
second DMR (7.3.1 m2) released earlier in the year which added
Foreign Keys to MySQL Cluster. Foreign Keys is a feature
requested by many, many people and has often been cited as the
reason for not being able to replace InnoDB with MySQL Cluster
when they needed the extra availability or scalability.
Note that this post is an up-version of the original – and was
first published with the 7.3 labs release in June 2012.
What’s a Foreign Key
The majority of readers who are already familiar with Foreign
Keys can skip to the next section.
Foreign Keys are a way of implementing relationships/constraints
between columns in different tables. For example, in the above
figure, we want to make sure …[Read more]