???????????????????????????server-id????????????????????????????
?????????????????InnoDB???????????????????????????
?????????????????my.cnf????????innodb_flush_log_at_trx_commit=1??sync-binlog=1??
????mysql> show variables; (??????read-only?????????slave????slave?????????SUPER??????????????????????????slave?????????????????????????)
????mysql> show processlist; (??????slave-start)
?????????mysql???????slave??
????mysqld_safe –user=mysql –read-only & (???MySQL?????????????slave??I/O???)
????mysql> SHOW SLAVE STATUSG;
????5.?л?slave?master????slave???
????mysql> STOP SLAVE;
????mysql> RESET MASTER;
??????.??????????
????–read_only
???????????????????????????????????????SUPER?????????????????????????????????????????????
????–replicate_do_db=db_name
?????????????????????????(??USE?????)?db_name??????????????????????????????????????????????Ρ????????????????????
????–replicate_do_table=db_name.tbl_name
???????????????????????????????????????????????????????????????Ρ??–replicate-do-db??????????????????
????–replicate_ignore_db=db_name
?????????????????????????????(??USE?????)?db_name??????????????????????????????????????????Ρ?
????–replicate-ignore-table=db_name.tbl_name
?????????????????????????????????κ????(?????????????????????)??????????????????????????????????Ρ?
????–replicate_wild_do_table=db_name.tbl_name
??????????????????????????μ???????????????????????????????????‘%’??‘_’????????LIKE?????????????????????塣???????????????????????????????Ρ?????????????????и????
????–replicate_wild_ignore_table=db_name.tbl_name
???????????????????????????????????????????????????????????????????????????Ρ?????????????????и????
????–replicate_rewrite_db=from_name->to_name
?????????????????????????(??USE?????)????????????from_name???????to_name???????б?????
????–report_host=slave_name
??????????????????б??????????????????????IP????????????????????????SHOW SLAVE HOSTS??????С????????????????????????????????????????????
????–report_port=slave_port
????????????????TCP/IP???????????????????б??????????????
????–skip_slave_start
?????????????????????????????????????????????START SLAVE???????????????
????–slave_skip_errors=[err_code1??err_code2??… | all]
????????????????????????????????????????????????????????е?????????????????????????SQL??????????κ??????????е??????????????
???????磺
????–slave-skip-errors=1062??1053
????–slave-skip-errors=all
????????????????????????
???????????
????????????????????????????????????????????????????????????????(???SHOW MASTER STATUS????????)?????????????裺
??????????????????????????????ID??? ??????????????????????? ????????????????????????????????????????
????mysql> CHANGE MASTER TO
????-> MASTER_HOST=’master_host_name’??
????-> MASTER_USER=’master_user_name’??
????-> MASTER_PASSWORD=’master_pass’??
????-> MASTER_LOG_FILE=’recorded_log_file_name’??
????-> MASTER_LOG_POS=recorded_log_position;
????4.?????????????START SLAVE???
???????????б????????????????????????????????????????в??趼?????????????????????С?
?????????????
????mysql> FLUSH TABLES WITH READ LOCK?? ????????????и?????????????壩??
????shell> tar zcf /tmp/backup.tar.gz /var/lib/mysql
???????????????????? ????????????????????????????????
????mysql>SHOW MASTER STATUS?? ???????
????mysql> UNLOCK TABLES??
????????????
????????????????????????????????SQL????????沽???е???????????????????????????????????????mysqldump –master-data????????SQL????????????????????????????ж???????????????
???????????
????1.???????????????????????????????????t?????????????????????????
????2.????????????????????????????????????5.1.x?汾????????????????????????????5.1?汾???????????????????д??????м?????????????а???????????????????????????м?????5.1?????
????3.??????????????????????????????????????????????У?????(–default-character-set??–default- collation)?????????????????????????????????????????????????????б?????????????????????????п????????
????4.Q??????????????????????????????
????A????????????????????????崻????????????С????????????????????????????
????5.Q???????????????????????????????±??? ???仰??????????????????????????????????????
????A????????SHOW SLAVE STATUS????Seconds_Behind_Master?е?????
????Q??????????????????????????????????????????
????A????????????裺 ??????????????????Щ???
????mysql> FLUSH TABLES WITH READ LOCK;
????mysql> SHOW MASTER STATUS;
???????SHOW?????????????????????????Щ?????????
????2.???????????????????????????Master_POS_WAIT()?????????????沽???е???????????????
????mysql> SELECT MASTER_POS_WAIT(‘log_name’?? log_offset);
????SELECT????????????????????????????????????????????????????????????????????????
????3.?????????????????????????????????????????????????￡?
????mysql> UNLOCK TABLES??
????7.Q???????????????????????????
????A??????????????????????????????????????д???÷???????????????????t?????????????????????????????????????????????????????????????????–skip-innodb??–skip-bdb??–low-priority-updates???–delay-key- write=ALL?????????????????????????????????????????????￡????????????????????÷?????MyISAM????????InnoDB?? BDB???