一號學(xué)院老師課程第五周14.replication

注replicationPARTBinary建立

ReplicationenablesdatafromoneMySQLdatabaseserver(themaster)tobereplicatedtooneormoreMySQLdatabaseservers(theslaves)

data

dumpIOSQL

Binary

Binary自增relaylogs同樣也是binaryrow

Binary

將SQL語句寫入到binary不支持UPDATELIMITwithoutORDER BinaryMySQL5.1

Binary

Binary

Binary

Binary會

Binary查看binaryshowbinlogSHOWBINLOG[IN'log_name'][FROMpos][LIMIT[offset,]

Binary

#at#12010615:19:13serverid9999end_log_pos203!Query!CREATEDATABASE#at#12010615:19:32serverid9999end_log_pos312!Query!thread_id=11!exec_time=1!useSET CREATETABLErepl(aINT)#at#12010615:19:55serverid9999end_log_pos387!Query!thread_id=11!exec_time=0!SET #at#12010615:19:55serverid9999end_log_pos484!Query!thread_id=11!exec_time=0!SET INSERTINTOreplVALUES#at#12010615:19:55serverid9999end_log_pos511!Xid=14Binary

#at#at#12010615:55:06serverid1end_log_pos937!Table_map:`replication`.`repl`mappedtonumber17#12010615:55:06serverid1end_log_pos971!Write_rows:tableid17BINLOG'AAEDAAE=SgsHTxcBAAAAIgAAAMsDAAAAABEAAAAAAAEAAf/+AQAAAA==#at#12010615:55:06serverid1end_log_pos998Binary

#12010615:55:06serverid1end_log_pos937!number#12010615:55:06serverid1end_log_pos971Table_map:`replication`.`repl`mappedtoWrite_rows:tableid17flags:STMT_END_FBINLOG'###INSERTINTOreplication.repl###SET###@1=1/*INTmeta=0nullable=1is_null=0Binary

Binary

Binary

備份文件包含binarylogandCHANGEMASTER

InnoDB:LastMySQLbinlogfileposition ,filename./mysql-...snip...Ifyouusebinaryloganddon'tuseanyhackofgroupcommit,thebinarylogpositionseemstobe:InnoDB:LastMySQLbinlogfileposition ,filename./mysql-是否注釋CHANGEMASTER

[root@xen-server~]#mysqldump--single-transaction--add-drop-database--master-data=1--databasestest>test_backup.sql[root@xen-server~]#cat--MySQLdump10.13Distrib5.5.1-m2,forunknown-linux-gnu

Rotatebinarylog:FLUSHBINARYRemovebinaryPURGEMASTERLOGSTO‘mysql-PURGEMASTERLOGSBEFORE‘2012-01-01Removeallbinarylogs:RESETRemoveslaveconfigurationandfiles:RESETOnSHOWMASTERSHOWSHOWBINLOGOnSHOW

mysql>showvariableslike |Variable_name|Value |b