Setting up a new shared MySQL (MariaDB) server

The following steps should be taken to setup a new shared mysql server:

  1. In ansible seed repo, edit hosts.yml to copy each line with mailstore002 to your new name.
  2. Execute sower --live generate:mysql --parent hostxxx.mayfirst.org to generate a new mysql yaml file.
  3. Follow regular kvm guest setup steps
  4. Be sure you created the ssh key and enabled quotas in the step above!
  5. Update all weborigins to let them know about the mysql server so they can connect via proxysql: sower --live playbook --tags proxysql-build-origins-file weborigin*.mayfirst.org
  6. Update configuration file for phpmyadmin.mayfirst.org (which is a regular hosting order) to add the new server.