Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
2.2.4
-
Centos 6
Description
Hi, We have mysql master server is running on mysql56-server.
I have upgraded maxscale from 2.1.10 to 2.2.4 and binlogrouter is stopped working.
Here is binlogrouter configuration:
[root@dbproxy maxscale.cnf.d]# cat replication.cnf |
# define service replication
|
[Replication]
|
type=service
|
version_string=5.6.17-log |
router=binlogrouter
|
user=***
|
passwd=******
|
router_options=server_id=104,master_id=1,binlogdir=/usr/mysql_binlogs,transaction_safety=1 |
|
[Replication Listener]
|
type=listener
|
service=Replication
|
protocol=MySQLClient
|
port=5308 |
Maxscale log :
2018-04-23 06:01:53 error : (2601) [binlogrouter] Replication: Received error: 1193, 'Unknown system variable 'gtid_domain_id'' from master during 'MariaDB10 GTID Domain retrieval' phase of the master state machine. |
Master server gtid variables:
mysql> show global variables like '%gtid%'; |
+---------------------------------+-------+
|
| Variable_name | Value |
|
+---------------------------------+-------+
|
| binlog_gtid_simple_recovery | OFF |
|
| enforce_gtid_consistency | OFF |
|
| gtid_executed | |
|
| gtid_mode | OFF |
|
| gtid_owned | |
|
| gtid_purged | |
|
| simplified_binlog_gtid_recovery | OFF |
|
+---------------------------------+-------+
|
7 rows in set (0.00 sec) |
I already added option:
mariadb10-compatibility=1 |
But it doesn't help
If your master is a MySQL 5.6 server, you need to set mariadb10-compatibility=0.