...
- Create the /usr/local/cams/backup, /usr/local/cams/backup/local, and /usr/local/cams/backup/remote directories.
- Create the /usr/local/cams/sbin directory, if necessary.
- Install the backup-db script in /usr/local/cams/sbin on the MySQL master server.
- Create the backup user in the database on the master, as above.
- Create /usr/local/cams/conf/backup.cnf, with the username and password for the backup account:
No Format [client] user=backup password=<password>
- Install the cams cron file (cams.cron) as /etc/cron.d/cams. This will run the backup every 6 hours. (It also will run the /usr/local/cams/sbin/clean-logs script daily).
On the slave server, the check-slave-status script should also be installed in /usr/local/cams/sbin; it should be run once per hour from cron. This should use a special replicatechecker account in MySQL, created as follows (this should be created on the master, after replication has been set up):
...
No Format |
---|
[client] user=replicatechecker password=<password> |
Install the cams-slave.cron file as /etc/cron.d/cams-slave; this will run the check-slave-status script hourly.
Any problems encountered by either of these procedures will be reported via email to touchstone-support.
...