We saw yesterday that the new MySQL Shell was out and how we could create a MySQL InnoDB Cluster manually using the Shell.
Today, I would like to show you how easy it is to create recipes to automate all the process. I have created a Puppet module that can be used as Proof-of-concept (You might need more features to use it in production, feel free to fork it).
The module can be found on this github repo.
When using Puppet, I really like to put all configuration in hiera.
We have 3 GNU/Linux servers: mysql1, mysql2 and mysql3.
We won’t install anything related to MySQL manually, everything will be handled by Puppet.
Nodes definition …[Read more]