[Kea-users] Kea 1.6 with MySQL Cluster

Fernando Ruza Rodriguez fernandor at sescam.jccm.es
Fri Apr 26 12:55:19 UTC 2019


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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20190426/d16d7ae6/attachment.html>


More information about the Kea-users mailing list