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

          relates to

          Task - A task that needs to be done. MDEV-8341 Delayed replication implementation

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            arjen Arjen Lentz created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Fix Version/s 10.1 [ 16100 ]
            serg Sergei Golubchik made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 58629 ] MariaDB v3 [ 65521 ]
            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.
            andreymal Andrey Kashlak added a comment -

            Please add this, it's very good for backups

            andreymal Andrey Kashlak added a comment - Please add this, it's very good for backups
            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).

            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).
            ratzpo Rasmus Johansson (Inactive) made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.1 [ 16100 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            danblack Daniel Black made changes -
            Fix Version/s 10.2 [ 14601 ]
            danblack Daniel Black made changes -
            svoj Sergey Vojtovich made changes -
            Labels foundation
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            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.
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.2-4 [ 96 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Assignee Vladislav Vaintroub [ wlad ]
            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.
            knielsen Kristian Nielsen made changes -
            Assignee Vladislav Vaintroub [ wlad ] Kristian Nielsen [ knielsen ]
            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!
            knielsen Kristian Nielsen added a comment -

            Pushed into 10.2.3

            knielsen Kristian Nielsen added a comment - Pushed into 10.2.3
            knielsen Kristian Nielsen made changes -
            Component/s Replication [ 10100 ]
            Fix Version/s 10.2.3 [ 22115 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 65521 ] MariaDB v4 [ 132463 ]

            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.