Changes between Version 4 and Version 5 of MySqlReplication
- Timestamp:
- Oct 28, 2010, 2:15:27 PM (16 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
MySqlReplication
v4 v5 44 44 All commands are executed on the slave (''biglefts'') 45 45 Documentation is at http://dev.mysql.com/doc/refman/5.1/en/replication-howto-slavebaseconfig.html 46 46 47 * Stop the mysql server: ''sudo service mysql stop'' 48 47 49 * Note: ''ps waux | grep mysqld'' should not show anything (except the grep part maybe) 50 48 51 * Edit the mysql configuration and add (or uncomment+modify) the ''[mysqld]'' section so that it contains: 49 52 {{{ 50 53 server-id=2010101302 51 54 }}} 55 52 56 * I also activated binary logging (see the last paragraph in the documentation) 53 57 {{{ 54 58 log-bin=/var/log/mysql/mysql-bin.log 55 59 }}} 60 56 61 * Start the mysql server: ''sudo service mysql start'' 57 58 62 = Create a User for Replication = 59 63 Documentation is at http://dev.mysql.com/doc/refman/5.1/en/replication-howto-repuser.html
