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

Port/merge the CHANGE MASTER TO ... MASTER_DELAY option from MySQL 5.6

Details

    • 10.2.2-4

    Description

      This feature was earlier a port-in-progress in the OurDelta builds, but wasn't included in the work for 5.1 that Monty and I did for MariaDB.
      It's in stock MySQL 5.6. It's a useful feature, and clients still sometimes need it. The pt-slave-delay tool does the job, but it's nicer to have it in the server - and heck, the code already exists.

      If we can get this merged into (for instance) 10.1, that'd be great.
      thanks

      Attachments

        Issue Links

          Activity

            philsweeney Phil Sweeney added a comment -

            Would love this feature - I'm struggling with pt-slave-delay issues where it is behaving erratically, and obviously you have to run it as a separate process. Plus, there are quirks with it such as that it will die after 10 failed attempts to connect, and it's not 'guaranteed' to keep things delayed as much as if it was built into the database.

            philsweeney Phil Sweeney added a comment - Would love this feature - I'm struggling with pt-slave-delay issues where it is behaving erratically, and obviously you have to run it as a separate process. Plus, there are quirks with it such as that it will die after 10 failed attempts to connect, and it's not 'guaranteed' to keep things delayed as much as if it was built into the database.

            Please add this, it's very good for backups

            andreymal Andrey Kashlak added a comment - Please add this, it's very good for backups

            Waiting for this feature too. It can be useful in a testing environment to detect failures on the client side because of asynchronous replication delay (which may occur on a master/slave production environment).

            nico Nicolas Payart added a comment - Waiting for this feature too. It can be useful in a testing environment to detect failures on the client side because of asynchronous replication delay (which may occur on a master/slave production environment).
            sujunmin Su, Jun-Ming added a comment -

            Waiting for this feature, and hope it in the 10.1.x series. It will help the users who use the replication as a buffer for preventing the wrong sql usage.

            sujunmin Su, Jun-Ming added a comment - Waiting for this feature, and hope it in the 10.1.x series. It will help the users who use the replication as a buffer for preventing the wrong sql usage.
            sjwright Simon Wright added a comment -

            Waiting for this as well. Right now we're using pt-slave-delay which works but isn't stable; our sysadmin is yelling at me to switch to Percona. I would prefer to stay with MariaDB but data integrity trumps all other concerns.

            sjwright Simon Wright added a comment - Waiting for this as well. Right now we're using pt-slave-delay which works but isn't stable; our sysadmin is yelling at me to switch to Percona. I would prefer to stay with MariaDB but data integrity trumps all other concerns.
            sujunmin Su, Jun-Ming added a comment -

            Will this feature be in 10.1.x stable ga? Because 10.2 is the alpha release and not to use for production.
            Thanks.

            sujunmin Su, Jun-Ming added a comment - Will this feature be in 10.1.x stable ga? Because 10.2 is the alpha release and not to use for production. Thanks.
            philsweeney Phil Sweeney added a comment -

            For those tracking this bug, knielsen has begun work on this and posted an update on the developers mailing list:

            https://lists.launchpad.net/maria-developers/msg09993.html

            Thanks Kristian!

            philsweeney Phil Sweeney added a comment - For those tracking this bug, knielsen has begun work on this and posted an update on the developers mailing list: https://lists.launchpad.net/maria-developers/msg09993.html Thanks Kristian!

            Pushed into 10.2.3

            knielsen Kristian Nielsen added a comment - Pushed into 10.2.3

            People

              knielsen Kristian Nielsen
              arjen Arjen Lentz
              Votes:
              31 Vote for this issue
              Watchers:
              30 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.