Wiki source for MySQL
======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
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
