======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