WL#3292: Foreign Keys & Cluster: NDB Cluster requirements for SQL-level foreign keys
Affects: Server-7.1 — Status: Un-Assigned — Priority: Low
NDB Cluster storage engine will implement the storage engine API for foreign key support (WL#3288). Additionally, the following is required: In order to check consistency of the foreign key constraint defined via ALTER TABLE, we need to make sure that name locks that are acquired for the time of foreign key creation. Possible solution: inform the cluster that there is only one mysqld server that can modify the table at this given moment (acquire an exclusive lock on the table). Proper support for ALTER TABLE in Cluster is a pre-requirement for SQL layer foreign keys to work properly with this storage engine.
Copyright (c) 2000, 2017, Oracle Corporation and/or its affiliates. All rights reserved.