dockerizing MySQL with block storage?
I run a web development consulting agency, and we're planning to upgrade our database infrastructure for hosting managed sites for clients.
Currently we have 1 MySQL database per client, but we would like to move to a more efficient approach by implementing database infrastructure that all clients use.
The plan would be to spin up three droplets for the database infrastructure. 1 would be an HAproxy load balancer, and the other two would host dockerized MySQL instances in master-master replication.
Does it make sense to dockerize MySQL, and would the master-master replication work with block storage?