Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1821

Mysql Binlog router for Mysql server is Master

    XMLWordPrintable

Details

    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

      Attachments

        Activity

          People

            Unassigned Unassigned
            charlie Charlie Root
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.