<!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, 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>
</BODY>
</HTML>