IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 14 and Version 15 of MySqlReplication


Ignore:
Timestamp:
Jul 30, 2013, 2:00:15 PM (13 years ago)
Author:
Mark Huber
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • MySqlReplication

    v14 v15  
    2727All commands are executed on the master (''neverland'')
    2828Documentation 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:
    3232{{{
    3333log-bin=/var/log/mysql/mysql-bin.log
    3434server-id=2010101301
    3535}}}
    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:
    3737{{{
    3838innodb_flush_log_at_trx_commit=1
    3939sync_binlog=1
    4040}}}
    41 * Start the mysql server: ''sudo service mysql start''
     41 * Start the mysql server: ''sudo service mysql start''
    4242
    4343= Set up the slave configuration for replication =
     
    4545Documentation is at http://dev.mysql.com/doc/refman/5.1/en/replication-howto-slavebaseconfig.html
    4646
    47 * Stop the mysql server: ''sudo service mysql stop''
     47 * Stop the mysql server: ''sudo service mysql stop''
    4848
    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)
    5050
    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:
    5252{{{
    5353server-id=2010101302
    5454}}}
    5555
    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)
    5757{{{
    5858log-bin=/var/log/mysql/mysql-bin.log
    5959}}}
    6060
    61 * Start the mysql server: ''sudo service mysql start''
     61 * Start the mysql server: ''sudo service mysql start''
     62
    6263= Create a User for Replication =
    6364Documentation is at http://dev.mysql.com/doc/refman/5.1/en/replication-howto-repuser.html