Few weeks ago I started up a project migrating a development mysql to the production environment.
Doing this change included a lot of tests and updates I wanted to do for a long time.
The short story is that I migrated user defined mysql data (permissions and triggers was vetted before) to Master Slave on docker images and a different user with the entire environment configured via Ansible (yes yes I went overboard with the design – but hey, now I have all the templates I need and every docker and mysql needs and documentation and all orchestrated by ansible)
I’ve needed to create a special docker image for MySQL 5.1 for this project – I will post a followup post with the information about the docker
After all the hard work preparation etc I was ready to do the migration! Finally! I’ve dumped the data, Upload it to the new Master and Slave, Changed the users (Create new Delete the old ones), sync everything and set the backup.
The next day I woke up and checked the backup and found it didn’t work, I was not in a good mood – the backup failed… Continue reading MySQL Why Won’t you Dump already!