| Name | MySQL |
|---|---|
| Deployed on | sown-auth, sown-vpn, sown-dev |
| Website | http://www.mysql.com/ |
Both sown-auth and sown-vpn run MySQL to hold the database used by the authentication scripts.
sown-auth holds the master copy, and changes to it are replicated onto sown-vpn.
Do not make changes to the sown-vpn copy of the database, as your changes will not be replicated, and will likely cause replication errors.
Both machines take daily and monthly snapshots of the database, and store these on disk. 7 days worth of daily snapshots are held, three months of monthly.
A good tutorial on MySQL replication is available [here]