Pop-Up shops are those short lived stores at malls and other places, often times they are kiosks. They serve to satisfy temporal demands like nano quadcopters or engraved keychains. In this context you can create MySQL instances that are short lived, easily provisioned, and easily disposed of.
Imagine you are a developer, or the DBA who has to tell a developer when their code breaks, and you would like an easy way to validate code against the production schema, but not impact your production systems?
This recipe makes some assumptions:
- You have a MySQL slave or a secondary Innodb Cluster instance to CLONE from
- You are using MySQL 8.0.17 or later
- You don’t have hundreds of gigabytes to terabytes of data
If you have a lot of data in your production environment, this won’t be a viable solution, but if your data is in the 10s of gigabytes, this could work for you.
I’m going to present 2 options: 1) A completely standalone transient instance of MySQL 2) A semi-persistent instance of MySQL that can live on an external encrypted SSD or other secured storage.Continue reading “Using Docker to Create Pop-Up MySQL Instances”