In the MySQL Management node I have: ndb_mgm> show Cluster Configuration --------------------- [ndbd(NDB)] 3 node(s) id=2 @192.168.100.6 (mysql-5.7.25 ndb-7.6.9, Nodegroup: 0, *) id=3 @192.168.110.16 (mysql-5.7.25 ndb-7.6.9, Nodegroup: 0) id=4 @192.168.120.26 (mysql-5.7.25 ndb-7.6.9, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s) id=1 @192.168.100.7 (mysql-5.7.25 ndb-7.6.9) [mysqld(API)] 3 node(s) id=5 @192.168.100.6 (mysql-5.7.25 ndb-7.6.9) id=6 @192.168.110.16 (mysql-5.7.25 ndb-7.6.9) id=7 @192.168.120.26 (mysql-5.7.25 ndb-7.6.9) Regards, Fernando. -----Mensaje original----- De: Fernando Ruza Rodriguez <[email protected]> Para: [email protected] <[email protected]> Asunto: Re: [Kea-users] Kea 1.6 with MySQL Cluster Fecha: Fri, 26 Apr 2019 15:09:34 +0200 Sorry, I've installed: mysql-cluster-community-server-7.6.9-1.el7.x86_64 Regards, Fernando. -----Mensaje original----- De: Philippe Havard <[email protected]> Para: Fernando Ruza Rodriguez <[email protected]> Cc: [email protected] <[email protected]> Asunto: Re: [Kea-users] Kea 1.6 with MySQL Cluster Fecha: Fri, 26 Apr 2019 09:04:27 -0400 Not all version of ndb support foreign key. Wich version are you using? On Friday, April 26, 2019, Fernando Ruza Rodriguez <[email protected]> wrote: 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
