3

We're using a master-slave solution using MariaDB 5.5.44. Is there a way to manually introduce an artificial delay between the master and slave? I'm thinking of something like 1 minute or so. Is there a mysqld option that does this?

I see that MySQL 5.6 has the MASTER_DELAY parameter for the CHANGE MASTER TO command, but I suppose it doesn't exist in 5.5 (or MariaDB 5.5). Is there another way to cause a delay?

0
2

The MASTER_DELAY option is currently scheduled to be in MariaDB 10.2. There is an issue for the feature.

Until that is added to MariaDB, your best option is pt-slave-delay from Percona. I've used it before and it is pretty easy to get going but since it isn't part of the mysql server, it's not as reliable.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.