<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/4.6.6">
</HEAD>
<BODY>
In the MySQL Management node I have:<BR>
<BR>
ndb_mgm> show<BR>
Cluster Configuration<BR>
---------------------<BR>
[ndbd(NDB)] 3 node(s)<BR>
id=2 @192.168.100.6 (mysql-5.7.25 ndb-7.6.9, Nodegroup: 0, *)<BR>
id=3 @192.168.110.16 (mysql-5.7.25 ndb-7.6.9, Nodegroup: 0)<BR>
id=4 @192.168.120.26 (mysql-5.7.25 ndb-7.6.9, Nodegroup: 0)<BR>
<BR>
[ndb_mgmd(MGM)] 1 node(s)<BR>
id=1 @192.168.100.7 (mysql-5.7.25 ndb-7.6.9)<BR>
<BR>
[mysqld(API)] 3 node(s)<BR>
id=5 @192.168.100.6 (mysql-5.7.25 ndb-7.6.9)<BR>
id=6 @192.168.110.16 (mysql-5.7.25 ndb-7.6.9)<BR>
id=7 @192.168.120.26 (mysql-5.7.25 ndb-7.6.9)<BR>
<BR>
<BR>
Regards, Fernando.<BR>
<BR>
<BR>
-----Mensaje original-----<BR>
<B>De</B>: Fernando Ruza Rodriguez <<A HREF="mailto:Fernando%20Ruza%20Rodriguez%20%3cfernandor@sescam.jccm.es%3e">fernandor@sescam.jccm.es</A>><BR>
<B>Para</B>: Kea-users@lists.isc.org <<A HREF="mailto:%22Kea-users@lists.isc.org%22%20%3cKea-users@lists.isc.org%3e">Kea-users@lists.isc.org</A>><BR>
<B>Asunto</B>: Re: [Kea-users] Kea 1.6 with MySQL Cluster<BR>
<B>Fecha</B>: Fri, 26 Apr 2019 15:09:34 +0200<BR>
<BR>
Sorry, I've installed:<BR>
<BR>
mysql-cluster-community-server-7.6.9-1.el7.x86_64<BR>
<BR>
Regards, Fernando.<BR>
<BR>
<BR>
-----Mensaje original-----<BR>
<B>De</B>: Philippe Havard <<A HREF="mailto:Philippe%20Havard%20%3ccdrole@gmail.com%3e">cdrole@gmail.com</A>><BR>
<B>Para</B>: Fernando Ruza Rodriguez <<A HREF="mailto:Fernando%20Ruza%20Rodriguez%20%3cfernandor@sescam.jccm.es%3e">fernandor@sescam.jccm.es</A>><BR>
<B>Cc</B>: Kea-users@lists.isc.org <<A HREF="mailto:%22Kea-users@lists.isc.org%22%20%3cKea-users@lists.isc.org%3e">Kea-users@lists.isc.org</A>><BR>
<B>Asunto</B>: Re: [Kea-users] Kea 1.6 with MySQL Cluster<BR>
<B>Fecha</B>: Fri, 26 Apr 2019 09:04:27 -0400<BR>
<BR>
Not all version of ndb support foreign key. Wich version are you using?<BR>
<BR>
On Friday, April 26, 2019, Fernando Ruza Rodriguez <<A HREF="mailto:fernandor@sescam.jccm.es">fernandor@sescam.jccm.es</A>> wrote: <BR>
<BLOCKQUOTE>
Hi, I'm trying to setup kea 1.6 with MySQL NDB Cluster backend. Has someone experienced with them?<BR>
<BR>
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:<BR>
<BR>
<TT>...</TT><BR>
<BR>
<TT>ERROR 1215 (HY000): Cannot add foreign key constraint</TT><BR>
<TT>Query OK, 0 rows affected (0,46 sec)</TT><BR>
<BR>
<TT>Query OK, 0 rows affected (1,50 sec)</TT><BR>
<TT>Records: 0 Duplicates: 0 Warnings: 0</TT><BR>
<BR>
<TT>Query OK, 0 rows affected (1,77 sec)</TT><BR>
<TT>Records: 0 Duplicates: 0 Warnings: 0</TT><BR>
<BR>
<TT>Query OK, 0 rows affected (0,48 sec)</TT><BR>
<BR>
<TT>ERROR 1146 (42S02): Table 'keadhcp.dhcp4_pool' doesn't exist</TT><BR>
<TT>Query OK, 0 rows affected (0,48 sec)</TT><BR>
<BR>
<TT>...</TT><BR>
<BR>
<TT>ERROR 1215 (HY000): Cannot add foreign key constraint</TT><BR>
<TT>ERROR 1215 (HY000): Cannot add foreign key constraint</TT><BR>
<TT>Query OK, 0 rows affected (1,65 sec)</TT><BR>
<TT>Records: 0 Duplicates: 0 Warnings: 0</TT><BR>
<BR>
<TT>Query OK, 0 rows affected (1,36 sec)</TT><BR>
<TT>Records: 0 Duplicates: 0 Warnings: 0</TT><BR>
<BR>
<TT>Query OK, 0 rows affected (0,57 sec)</TT><BR>
<BR>
<TT>ERROR 1146 (42S02): Table 'keadhcp.dhcp6_pool' doesn't exist</TT><BR>
<TT>Query OK, 1 row affected (0,03 sec)</TT><BR>
<TT>Rows matched: 1 Changed: 1 Warnings: 0</TT><BR>
<BR>
<BR>
Thanks in advanced for any help.<BR>
<BR>
Regards, Fernando.<BR>
<BR>
<BR>
</BLOCKQUOTE>
<PRE>
_______________________________________________
Kea-users mailing list
<A HREF="mailto:Kea-users@lists.isc.org">Kea-users@lists.isc.org</A>
<A HREF="https://lists.isc.org/mailman/listinfo/kea-users">https://lists.isc.org/mailman/listinfo/kea-users</A>
</PRE>
</BODY>
</HTML>