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

Unable to sync slave to master on Galera Server

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.13, 10.0.14
    • 5.5.42-galera, 10.0.16-galera
    • Galera, Replication
    • None
    • 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

          relates to

          Task - A task that needs to be done. MDEV-7322 Option to allow setting the binlog_format with Galera

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              sinfomicien Nicolas BLANC
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.