IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 4 and Version 5 of MySqlReplication


Ignore:
Timestamp:
Oct 28, 2010, 2:15:27 PM (16 years ago)
Author:
Serge CHASTEL
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • MySqlReplication

    v4 v5  
    4444All commands are executed on the slave (''biglefts'')
    4545Documentation is at http://dev.mysql.com/doc/refman/5.1/en/replication-howto-slavebaseconfig.html
     46
    4647* Stop the mysql server: ''sudo service mysql stop''
     48
    4749* Note: ''ps waux | grep mysqld'' should not show anything (except the grep part maybe)
     50
    4851* Edit the mysql configuration and add (or uncomment+modify) the ''[mysqld]'' section so that it contains:
    4952{{{
    5053server-id=2010101302
    5154}}}
     55
    5256* I also activated binary logging (see the last paragraph in the documentation)
    5357{{{
    5458log-bin=/var/log/mysql/mysql-bin.log
    5559}}}
     60
    5661* Start the mysql server: ''sudo service mysql start''
    57 
    5862= Create a User for Replication =
    5963Documentation is at http://dev.mysql.com/doc/refman/5.1/en/replication-howto-repuser.html