3 ways your MySQL migration project can shake you up
Once a development or operations team gets over the hurdle of
open-source, and start to feel comfortable with the way software
works outside of the enterprise world, they will likely start to
settle in and feel comfortable. Best not to get too cushy
though for there are more surprises hiding around the
corner. Here are a few of the biggest ones.
1. Replication Is Not Perfect
Yes, you've installed MySQL, setup a slave, and got it
replicating properly. You check the slave and it's 0
seconds behind the master. What's more you monitor the
error log file, and have a check in place to alert you if
something happens there. Job completed, good job!
Not so fast. Unfortunately this is not the end of the
story. Many MySQL replication slaves are not consistent
with their masters, but they drift apart silently. …[Read more]