MySQL Group Replication doesn't support foreign key cascade
COMPLETELY UPDATED
I'm using Kea 1.7.0 (installed via the cloudsmith.io yum repo) on CentOS 7.7.1908 with all updates installed. I'm using MySQL 8.0.18 installed from MySQL's yum repo for the backend. MySQL is configured with Group Replication.
I ran into this issue trying to insert into dhcp4_options while doing a host reservation.
After digging into MySQL logs I found these errors:
[ERROR] [MY-011543] [Repl] Plugin group_replication reported: 'Table dhcp4_audit has a foreign key with 'CASCADE' clause. This is not compatible with Group Replication.'
[ERROR] [MY-011543] [Repl] Plugin group_replication reported: 'Table dhcp6_audit has a foreign key with 'CASCADE' clause. This is not compatible with Group Replication.'
I set the following foreign keys to no action:
- fk_dhcp4_audit_revision on update
- fk_dhcp6_audit_revision on update
- fk_dhcp4_subnet_shared_network on delete
- fk_dhcp6_subnet_shared_network on delete
- fk_dhcp4_pool_subnet_id on update
- fk_dhcp6_pool_subnet_id on update
- fk_dhcp6_pd_pool_subnet_id on update
Making these changes appears to work. I can insert and delete reservations and reservation specific options and Kea uses the reservations to respond to requests. However, I'm assuming these constraints are in there for a reason so what have I broken by doing this?