Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7321

Unable to sync slave to master on Galera Server

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.13, 10.0.14
    • Fix Version/s: 5.5.42-galera, 10.0.16-galera
    • Component/s: Galera, Replication
    • Labels:
      None
    • Environment:
      Hardware is HP Proliant Server with intel SSDs.
      The OS is Debian Wheezy

      Description

      I have a master which is a node in a galera cluster. The cluster is on MariaDB 10.0.14 now, but was in 10.0.13 when firt tested it.

      The slave is a standard MariaDB server 10.0.14.

      When i try to use pt-table-sync to correct some errors on the slave, i have on error about binlog_format which can't be set to STATEMENT. So there's no tool to sync an asynchronous slave to to MariaDB Galera Node.

      I tested with PXC, and by the way, even if at startup, i can't use binlog_format other than ROW, it's possible to set it to STATEMENT on a session base. So i'm able to sync an asyncrhonous slave with a PXC node.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              nirbhay_c Nirbhay Choubey (Inactive)
              Reporter:
              sinfomicien Nicolas BLANC
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: