[Kea-users] Kea 1.6 with MySQL Cluster

[Fernando Ruza Rodriguez]

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 <fernandor at sescam.jccm.es>
Para: Kea-users at lists.isc.org <Kea-users at lists.isc.org>
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 <cdrole at gmail.com>
Para: Fernando Ruza Rodriguez <fernandor at sescam.jccm.es>
Cc: Kea-users at lists.isc.org <Kea-users at lists.isc.org>
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
<fernandor at sescam.jccm.es> 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
Kea-users at lists.isc.org
https://lists.isc.org/mailman/listinfo/kea-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20190426/de031142/attachment.htm>