setting GTID replication
mysql Ver 15.1 Distrib 10.1.19-MariaDB, for Linux (x86_64) using readline 5.1
I'm trying to set a replication with the following options in my.cnf: [mysqld] server-id = 1 log-bin = mysql-bin binlog_format = ROW enforce_gtid_consistency (tryed the following values: = True / = on / no value) gtid_mode = on log_slave_updates
I get the following error when trying to start the MariaDB service: mysqld: 2016-11-08 14:42:39 139882797168896 [ERROR] /usr/sbin/mysqld: unknown option '--enforce_gtid_consistency' mysqld: 2016-11-08 14:42:39 139882797168896 [ERROR] Aborting
What am I missing? Fedora system TY
Answer Answered by Brian Evans in this comment.
MariaDB has a different GTID implementation than MySQL and the variable enforce_gtid_consistency does not exist.
Please see https://mariadb.com/kb/en/global-transaction-id/ for details on configuration.