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

Add replication crash-safety for non-GTID slave.

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Replication
    • None

    Description

      The way to achieve replication crash safety in MariaDB 10.0 is to enable GTID slave negotiation, but this is not always possible and comes with drawbacks:

      1. 1. It is not possible to enable GTID slave negotiation when the master is not MariaDB 10.
      2. 2. GTID slave negotiation put extra burden on the master.
      3. 3. GTID slave negotiation does not yet works with MaxScale Binlog Servers.
      4. 4. GTID slave negotiation overloads the master NIC on restarting IO_THREAD on lagging slave (MDEV-8945).

      Having replication crash-safety in file/position replication with MariaDB would be useful. This does not look very hard to implement and is implemented in MySQL 5.6. See this post for more information and pitfalls in the MySQL implementation:
      http://blog.booking.com/better_crash_safe_replication_for_mysql.html

      Thanks,

      JFG

      Attachments

        Activity

          People

            Unassigned Unassigned
            jgagne Jean-François Gagné
            Votes:
            7 Vote for this issue
            Watchers:
            10 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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