How to prevent bad queries from breaking replication?
- by nulll
For my personal experience, mysql replication is fragile.
I know that there area many things not to do beacuse they could break replication, but we are humans and the error could always occur.
So I was thinking... is there a way to enforce mysql replication? Something that prevents queries that are dangerous for the replication to be runt?
In other words I'm searching for something that saves replication even if I accidentally run evil queries.