Changes between Version 8 and Version 9 of InstallationGuidelines/MySQL

Timestamp:

06/04/10 12:39:45 (14 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/MySQL

@@ -51 +51 @@
 In order to have a backup instance, configure replication from the Master node to a Backup node:
  * http://www.debiantutorials.net/mysql-database-replication-masterslave/
-On Master: 
+==== On Master: ====
 {{{
 pico /etc/mysql/my.cnf
@@ -68 +68 @@
 Read log filename & position for configuring the slave (see below).
 
-On Slave: 
+==== On Slave: ====
 {{{
 pico /etc/mysql/my.cnf
@@ -85 +85 @@
 CHANGE MASTER TO MASTER_HOST='ma.st.er.ip', MASTER_USER='username', MASTER_PASSWORD='mypassword', MASTER_LOG_FILE='log_file', MASTER_LOG_POS=log_position;
 SLAVE START;
+
+crontab -e 
+# m h  dom mon dow   command
+55 * * * * /home/instance/scripts/automysqlbackup
+55 * * * * /home/instance/scripts/sync-dir
 }}}