Sorry, I said kea version 1.6 and I wanted to say: kea version 1.5. It is a restriction regarding foreign keys and on update cascade:
https://dev.mysql.com/doc/mysql-cluster-excerpt/5.7/en/mysql-cluster-limitations-syntax.html Restrictions on foreign keys. Support for foreign key constraints in NDB 7.5 is comparable to that provided by InnoDB, subject to the following restrictions: * ON UPDATE CASCADE is not supported when the reference is to the parent table's primary key. This is because an update of a primary key is implemented as a delete of the old row (containing the old primary key) plus an insert of the new row (with a new primary key). This is not visible to the NDB kernel, which views these two rows as being the same, and thus has no way of knowing that this update should be cascaded. I have downloaded and installed kea version 1.4.0-P1 and replaced in mysql script the engine from INNODB to NDBCLUSTER and now the database is created correctly. Thanks and regards, Fernando. -----Mensaje original----- De: Fernando Ruza Rodriguez <[email protected]> Para: [email protected] Asunto: [Kea-users] Kea 1.6 with MySQL Cluster Fecha: Fri, 26 Apr 2019 14:55:19 +0200 Hi, I'm trying to setup kea 1.6 with MySQL NDB Cluster backend. Has someone experienced with them? I have changed the "ENGINE" in all create tables statements with ENGINE=NDBCLUSTER in the script dhcpdb_create.mysql however when I run it I get the following errors, I think, when created the tables keadhcp.dhcp4_pool and keadhcp.dhcp6_pool for the foreign keys they have: ... ERROR 1215 (HY000): Cannot add foreign key constraint Query OK, 0 rows affected (0,46 sec) Query OK, 0 rows affected (1,50 sec) Records: 0 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (1,77 sec) Records: 0 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0,48 sec) ERROR 1146 (42S02): Table 'keadhcp.dhcp4_pool' doesn't exist Query OK, 0 rows affected (0,48 sec) ... ERROR 1215 (HY000): Cannot add foreign key constraint ERROR 1215 (HY000): Cannot add foreign key constraint Query OK, 0 rows affected (1,65 sec) Records: 0 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (1,36 sec) Records: 0 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0,57 sec) ERROR 1146 (42S02): Table 'keadhcp.dhcp6_pool' doesn't exist Query OK, 1 row affected (0,03 sec) Rows matched: 1 Changed: 1 Warnings: 0 Thanks in advanced for any help. Regards, Fernando. _______________________________________________ Kea-users mailing list [email protected] https://lists.isc.org/mailman/listinfo/kea-users
_______________________________________________ Kea-users mailing list [email protected] https://lists.isc.org/mailman/listinfo/kea-users
