MySQL Usage
We use MySQL(actually MariaDB) for a few third party applications. Mostly due to them not supporting Postgres. This DB server is currently on ord0.cloud.votesmart.org.
Applications that currently use MariaDB:
- Wikka Wiki
- Mantis
Backups
Backups are currently run using a plain old nightly mysqldump. They're being run by local user root. The MySQL user is backup, which only has read permissions and the credentials are stored in /root/.my.cnf since it's more secure than a crontab.
mysqldump --single-transaction --routines --events --triggers --add-drop-table --extended-insert -u backup -h 127.0.0.1 --all-databases | gzip -9 > /var/data/mysql/mysql-daily.dump.gz
Random Notes
- Local user root will default to authenticating as mysql user backup unless a user is specifically specified, due to the settings in /root/.my.cnf for backups.
CategoryITDoc
