Integrate replication to percona operator pxc cluster frm existing mysql cluster

MySQL & MariaDB Percona Operator for MySQL
21

It appears that way since MariaDB is incompatible with basic replication protocol. Even the most recent version of mariadb still shows it missing. System Variable Differences Between MariaDB 10.8 and MySQL 8.0 - MariaDB Knowledge Base
And you’re sure you disabled GTID on the PXC cluster? gtid_mode=OFF?

2 Likes
22

It appears that way since MariaDB is incompatible with basic replication protocol. Even the most recent version of mariadb still shows it missing. System Variable Differences Between MariaDB 10.8 and MySQL 8.0 - MariaDB Knowledge Base

yes I’d looked system variable diffecrences

And you’re sure you disabled GTID on the PXC cluster? gtid_mode=OFF?

yes, my my.cnf configmap

apiVersion: v1
data:
my.cnf: |
[mysqld]
slow_query_log=1
long_query_time=1
gtid_mode=OFF
kind: ConfigMap
metadata:
name: cluster-pxc

and online check :

MySQL [(none)]> show variables like "%gtid_mode%";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| gtid_mode     | OFF   |
+---------------+-------+
1 row in set (0,053 sec)

thanks!

1 Like