Mysql Master-Master Replication MYSQL数据库主主同步设置

1. db setup; 55.109
2. mysql instance from 109 to new machine, update ralated password;
3. dump SLIMDB from 125 to new db;  --routines
   a. change SLIMDB password on 125;
   b. restart Slimdb;
   C. dump data > bak.sql;      #mysqldump -uslim -palps --routines SLIMDB > /var/log/mysql125_0215.sql
   d. reset master; use command, reference to document
   e. config my.cnf on 125 and disable duplicattion by comment the command, modify innodb location;
   f. remove master.info on 125;
   g. restart mysql on 125;
   h. insert primaryLocation record into SLIM_CONFIG;   #insert into SLIM_CONFIG(ITEMNAME,ITEMVALUE) values('slimg2.global.site.location','primaryLocation');
4. import data into new machine;
   a. dump data into 126;
   b. reset master;
   c. remove master.info;
   d. conf my.cnf;
   e. restart mysql;
5. check the status of duplication; show slave status\G
   a. /opt/slimg2/WEB-INF/shell/mysql/slimdb_replication_monitor.sh monitor
   b. wait for Seconds_Behind_Master: 0
6. enable the duplication in my.cnf on 125 and restart 125 db, modify innodb location;
7. start slimdb_replication_monitor.sh on 125 and 126;
8. start all web and JCs for 126;
   1. modify the value of location to backupLocation for all web and JCs;
  


changes:

slimg2.global.site.location=backupLocation for 126
slimg2.global.site.location=primaryLocation for 125



#error log

1. no innodb engine .
resolve:  
my.cnf : "innodb_buffer_pool_size = 4G"  larger than memory of server.
rename  $MYSQL_HOME/ib_logfile*
restart mysql