Changes between Version 14 and Version 15 of MySqlReplication
- Timestamp:
- Jul 30, 2013, 2:00:15 PM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
MySqlReplication
v14 v15 27 27 All commands are executed on the master (''neverland'') 28 28 Documentation is at http://dev.mysql.com/doc/refman/5.1/en/replication-howto-masterbaseconfig.html 29 * Stop the mysql server: ''sudo service mysql stop''30 * Note: ''ps waux | grep mysqld'' should not show anything (except the grep part maybe)31 * Edit the mysql configuration and add (or uncomment+modify) the ''[mysqld]'' section so that it contains:29 * Stop the mysql server: ''sudo service mysql stop'' 30 * Note: ''ps waux | grep mysqld'' should not show anything (except the grep part maybe) 31 * Edit the mysql configuration and add (or uncomment+modify) the ''[mysqld]'' section so that it contains: 32 32 {{{ 33 33 log-bin=/var/log/mysql/mysql-bin.log 34 34 server-id=2010101301 35 35 }}} 36 * Since we are going to use InnoDB, I followed the advice in documentation and added:36 * Since we are going to use InnoDB, I followed the advice in documentation and added: 37 37 {{{ 38 38 innodb_flush_log_at_trx_commit=1 39 39 sync_binlog=1 40 40 }}} 41 * Start the mysql server: ''sudo service mysql start''41 * Start the mysql server: ''sudo service mysql start'' 42 42 43 43 = Set up the slave configuration for replication = … … 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''47 * Stop the mysql server: ''sudo service mysql stop'' 48 48 49 * Note: ''ps waux | grep mysqld'' should not show anything (except the grep part maybe)49 * Note: ''ps waux | grep mysqld'' should not show anything (except the grep part maybe) 50 50 51 * Edit the mysql configuration and add (or uncomment+modify) the ''[mysqld]'' section so that it contains:51 * Edit the mysql configuration and add (or uncomment+modify) the ''[mysqld]'' section so that it contains: 52 52 {{{ 53 53 server-id=2010101302 54 54 }}} 55 55 56 * I also activated binary logging (see the last paragraph in the documentation)56 * I also activated binary logging (see the last paragraph in the documentation) 57 57 {{{ 58 58 log-bin=/var/log/mysql/mysql-bin.log 59 59 }}} 60 60 61 * Start the mysql server: ''sudo service mysql start'' 61 * Start the mysql server: ''sudo service mysql start'' 62 62 63 = Create a User for Replication = 63 64 Documentation is at http://dev.mysql.com/doc/refman/5.1/en/replication-howto-repuser.html
