[MXS-1821] Mysql Binlog router for Mysql server is Master Created: 2018-04-23  Updated: 2018-07-31  Resolved: 2018-07-31

Status: Closed
Project: MariaDB MaxScale
Component/s: binlogrouter
Affects Version/s: 2.2.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Charlie Root Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: replication
Environment:

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

 Comments   
Comment by markus makela [ 2018-04-23 ]

If your master is a MySQL 5.6 server, you need to set mariadb10-compatibility=0.

Comment by Charlie Root [ 2018-04-26 ]

Thanks. Let me try that setting. I though it is default mariadb10-compatibility=0.
Please help one more question:
For Master failover, I am using master - master replicate, and maxscale shows that both of servers are "relay master"
Should i change to Master - slave ?

Generated at Thu Feb 08 04:09:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.