[MDEV-7145] Port/merge the CHANGE MASTER TO ... MASTER_DELAY option from MySQL 5.6 Created: 2014-11-20 Updated: 2016-10-16 Resolved: 2016-10-16 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Fix Version/s: | 10.2.3 |
| Type: | Task | Priority: | Critical |
| Reporter: | Arjen Lentz | Assignee: | Kristian Nielsen |
| Resolution: | Fixed | Votes: | 31 |
| Labels: | foundation | ||
| Issue Links: |
|
||||||||
| Sprint: | 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. If we can get this merged into (for instance) 10.1, that'd be great. |
| Comments |
| Comment by Phil Sweeney [ 2015-06-21 ] |
|
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. |
| Comment by Andrey Kashlak [ 2015-08-29 ] |
|
Please add this, it's very good for backups |
| Comment by Nicolas Payart [ 2015-10-13 ] |
|
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). |
| Comment by Su, Jun-Ming [ 2016-09-14 ] |
|
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. |
| Comment by Simon Wright [ 2016-09-14 ] |
|
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. |
| Comment by Su, Jun-Ming [ 2016-09-14 ] |
|
Will this feature be in 10.1.x stable ga? Because 10.2 is the alpha release and not to use for production. |
| Comment by Phil Sweeney [ 2016-10-13 ] |
|
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! |
| Comment by Kristian Nielsen [ 2016-10-16 ] |
|
Pushed into 10.2.3 |