From 7326151b6c647e662579d48b89bae085c77e86f0 Mon Sep 17 00:00:00 2001 From: Miod Vallat Date: Fri, 25 Apr 2025 07:27:30 +0200 Subject: [PATCH] Mention foreign keys constraints are incompatible with group replication. --- docs/backends/generic-mysql.rst | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/docs/backends/generic-mysql.rst b/docs/backends/generic-mysql.rst index 811975dfab..1ced43ef65 100644 --- a/docs/backends/generic-mysql.rst +++ b/docs/backends/generic-mysql.rst @@ -48,6 +48,11 @@ domains table. The following SQL does the job: .. literalinclude:: ../../modules/gmysqlbackend/enable-foreign-keys.mysql.sql :language: SQL +.. warning:: + Please note, however, that setting up these foreign key constraints prevents + the PowerDNS database from being usable with mysql group replication, if you + are using multiple servers. + Using MySQL/MariaDB replication ------------------------------- -- 2.47.2