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

Replicas after maxscale binlog don't get updates

    XMLWordPrintable

Details

    • MXS-SPRINT-215, MXS-SPRINT-216, MXS-SPRINT-217, MXS-SPRINT-218, MXS-SPRINT-219, MXS-SPRINT-220, MXS-SPRINT-221

    Description

      I got next critical issue with maxcale binlogrouter and It repeated twice already

      I have the schema:
      masters ( 2 hosts ) --> maxscale binlog --> replicas (few hosts)

      When I do switchover master to other host that cause problem that replicas after binlogrouter stop getting new updates . Replication process Slave_IO & Slave_SQL are active on these replicas and replicas lools like alive , but Gtid_IO_Pos not changing .
      Only restart of replica (stop slave ; start slave ; ) helps to continue replication.

      On maxscale binllog all looks fine . It's getting update from new master , Slave_IO & Slave_SQL are active and Gtid_IO_Pos position increases

      I've attached log from maxscale binlog and few replicas

      Attachments

        1. maxscale_binlog.log
          1 kB
          Anton
        2. maxscale.cfg
          1 kB
          Anton
        3. mysqld-bin.359897.log
          0.7 kB
          Anton
        4. replicas.log
          3 kB
          Anton

        Activity

          People

            nantti Niclas Antti
            R Anton
            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.