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

Unable to sync slave to master on Galera Server

        Details

        • Type: Bug
        • Status: Closed
        • 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.

            Gliffy Diagrams

              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

                  Hide
                  Permalink
                  nirbhay_c Nirbhay Choubey added a comment -

                  Fixed in MDEV-7322.

                  Show
                  nirbhay_c Nirbhay Choubey added a comment - Fixed in MDEV-7322 .

                    People

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

                      Dates

                      • Created:
                        Updated:
                        Resolved: