What is a Delay Replica and how does it help?
MySQL Replication is useful, easy to set up, and used for very
different purposes. For example:
- split reads and writes
- run data mining or reporting processes on them
- disaster recovery
To learn more, check out How Does MySQL Replication Work?
It’s important to mention that a replication server is not a
backup by itself. A mistake on the source, for example, a DROP
DATABASE or an UPDATE without a WHERE clause will be replicated
nearly instantly to all replica servers. Simply having a replica
is not going to be helpful here. How can we avoid that kind of
mistake? By having a replica server that intentionally lags
behind.
We can never avoid human error in database infrastructure
operations. But …
[Read more]