<!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>
Hi again!<BR>
<BR>
I've read in the kea 1.5.0 release notes: <A HREF="https://ftp.isc.org/isc/kea/1.5.0/Kea150ReleaseNotes.txt">https://ftp.isc.org/isc/kea/1.5.0/Kea150ReleaseNotes.txt</A> the following:<BR>
<BR>
<PRE>
<TT><I>**Configuration Backend design** - The Configuration Backend feature is </I></TT>
<TT><I>now planned for Kea 1.6.0. It will provide the ability to use a database as </I></TT>
<TT><I>a source of configuration information for the Kea DHCP servers. Even though </I></TT>
<TT><I>the Configuration Backend is not functional in the Kea 1.5.0 release, the </I></TT>
<TT><I>design for this feature was created and some basic elements implementing </I></TT>
<TT><I>this design are included in the current version. The most prominent change </I></TT>
<TT><I>is the update of the MySQL schema to include new tables, constraints and </I></TT>
<TT><I>indexes to be used by the Configuration Backend feature once it is </I></TT>
<TT><I>implemented. These elements are currently unused, but they will be created </I></TT>
<TT><I>in the existing database instances once the MySQL database is upgraded to </I></TT>
<TT><I>the version supported by Kea 1.5.0 release. The design of the Configuration </I></TT>
<TT><I>Backend is available at </I></TT>
<TT><I>https://gitlab.isc.org/isc-projects/kea/wikis/designs/configuration-in-db-des</I></TT>
<TT><I>ign.</I></TT>
</PRE>
<BR>
And I see in the "Kea Configuration Backend Design: https://gitlab.isc.org/isc-projects/kea/wikis/designs/configuration-in-db-design" that the both tables what I'm having problems with MySQL NDB cluster are for this Configuration Backend feature that it's not used by kea version 1.5.0 yet. So, Could I obviate these tables and keep engine to innodb in them and still use kea version 1.5.0 in MySQL NDB cluster ?? What do you think ??.<BR>
<BR>
Thanks for any reply.<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>: <A HREF="mailto:Kea-users@lists.isc.org">Kea-users@lists.isc.org</A><BR>
<B>Asunto</B>: Re: [Kea-users] Kea 1.6 with MySQL Cluster<BR>
<B>Fecha</B>: Mon, 29 Apr 2019 11:53:53 +0200<BR>
<BR>
Sorry, I said kea version 1.6 and I wanted to say: <B>kea version 1.5</B>. It is a restriction regarding foreign keys and on update cascade:<BR>
<BR>
<A HREF="https://dev.mysql.com/doc/mysql-cluster-excerpt/5.7/en/mysql-cluster-limitations-syntax.html">https://dev.mysql.com/doc/mysql-cluster-excerpt/5.7/en/mysql-cluster-limitations-syntax.html</A><BR>
<BR>
<B>Restrictions on foreign keys. </B> Support for foreign key constraints in NDB 7.5 is comparable to that provided by <FONT COLOR="#000000"><A HREF="https://dev.mysql.com/doc/refman/5.7/en/innodb-storage-engine.html">InnoDB</A></FONT>, subject to the following restrictions:<BR>
<BR>
<UL>
<LI><FONT COLOR="#000000">ON UPDATE CASCADE</FONT> is not supported when the reference is to the parent table's primary key.<BR>
<BR>
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 <FONT COLOR="#000000">NDB</FONT> kernel, which views these two rows as being the same, and thus has no way of knowing that this update should be cascaded.<BR>
<BR>
</UL>
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.<BR>
<BR>
Thanks and regards,<BR>
<BR>
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>: <A HREF="mailto:Kea-users@lists.isc.org">Kea-users@lists.isc.org</A><BR>
<B>Asunto</B>: [Kea-users] Kea 1.6 with MySQL Cluster<BR>
<B>Fecha</B>: Fri, 26 Apr 2019 14:55:19 +0200<BR>
<BR>
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>
<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>
_______________________________________________
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>