PapaScott I like big blogs and I cannot lie! 🐘

SELECT * FROM error;

I haven't seen this explicitly stated anywhere, but you probably don't want to run mysqlsnapshot on a database that is already an active master, since the script issues a RESET MASTER which will stop replication in its tracks.

Another good hint for mysql is to make sure that the mysql user has write privileges in its data directory. That's such a basic mistake that you don't even think it could go wrong, but it can.

comments powered by Disqus