Setting up a new shared MySQL (MariaDB) server
The following steps should be taken to setup a new shared mysql server:
- In ansible seed repo, edit
hosts.ymlto copy each line withmailstore002to your new name. - Execute
sower --live generate:mysql --parent hostxxx.mayfirst.orgto generate a new mysql yaml file. - Follow regular kvm guest setup steps
- Be sure you created the ssh key and enabled quotas in the step above!
- 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 - Update configuration file for
phpmyadmin.mayfirst.org(which is a regular hosting order) to add the new server.