Changes between Version 8 and Version 9 of InstallationGuidelines/MySQL


Ignore:
Timestamp:
06/04/10 12:39:45 (12 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/MySQL

    v8 v9  
    5151In order to have a backup instance, configure replication from the Master node to a Backup node:
    5252 * http://www.debiantutorials.net/mysql-database-replication-masterslave/
    53 On Master:
     53==== On Master: ====
    5454{{{
    5555pico /etc/mysql/my.cnf
     
    6868Read log filename & position for configuring the slave (see below).
    6969
    70 On Slave:
     70==== On Slave: ====
    7171{{{
    7272pico /etc/mysql/my.cnf
     
    8585CHANGE MASTER TO MASTER_HOST='ma.st.er.ip', MASTER_USER='username', MASTER_PASSWORD='mypassword', MASTER_LOG_FILE='log_file', MASTER_LOG_POS=log_position;
    8686SLAVE START;
     87
     88crontab -e
     89# m h  dom mon dow   command
     9055 * * * * /home/instance/scripts/automysqlbackup
     9155 * * * * /home/instance/scripts/sync-dir
    8792}}}
    8893