欢迎来到天天文库
浏览记录
ID:34568678
大小:747.83 KB
页数:125页
时间:2019-03-08
《Replication Tutorial Presentation.pdf》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、MySQLReplicationTutorialMatsKindahlSeniorSoftwareEngineerReplicationTechnologyLarsThalmannDevelopmentManagerReplication/BackupTutorialOutlineTerminologyandBasicConceptsBasicReplicationReplicationforscale-outReplicationforhigh-availabilityThebinarylogStatementsandt
2、ransactionsClusterReplicationTerminologyandBasicConceptsMySQLReplicationWhy?How?HighavailabilitySnapshotsFail-overpossibleBackupScale-outmysqlbinlogQueriesonmanymysqldumpserversOff-siteprocessingBinarylogDonotdisturbmasterReplicationReportingPoint-in-timerecoveryMySQLS
3、erverTerminologyMasterMasterserverChangesdataKeepslogofchangesReplicationSlaveserverAskmasterforeventsExecuteseventsSlaveBinarylogLogeverychangeSplitintotransactionalgroupsMasterMySQLServerMySQLServerTerminologySynchronousreplicationMasterTransactionsarenotcommittedunti
4、ldataisreplicatedandappliedProvidesconsistency,butslowerReplicationProvidedbyMySQLClusterAsynchronousreplicationTransactionscommittedimmediatelyandreplicatedSlaveNoconsistency,butfasterProvidedbyMySQLServerrelaylogsessionbinlogdumpSQLI/OReplicationsystemarchitectureMast
5、erSlaveSessionDumpI/OSQLBinarylogRelaylogBinarylog(binlog)recordsallchangesConsistsoftransactionalgroupsUsedforreplicationandpoint-in-timerecoveryrelaylogsessionbinlogdumpSQLI/OReplicationsystemarchitectureMasterSlaveSessionDumpI/OSQLBinarylogRelaylogOnedumpthreadpersla
6、veStartedonrequestfromslaveReadeventsfrombinarylogandsendtoslaverelaylogsessionbinlogdumpSQLI/OReplicationsystemarchitectureMasterSlaveSessionDumpI/OSQLBinarylogRelaylogI/OthreadsenddumprequesttomasterI/OthreadcopieseventstorelaylogRelaylogisadisk-basedbufferforeventsRe
7、laylogshouldbeconsideredvolatilerelaylogsessionbinlogdumpSQLI/OReplicationsystemarchitectureMasterSlaveSessionDumpI/OSQLBinarylogRelaylogSQLthreadreadeventsfromrelaylogSQLthreaddecodesandapplieseventstodatabaseRelaylogRelaylogMasterSQLI/OReplicationsystemarchitectureRel
8、aylogI/OSQLinfoSlaveMasterinfoRelaylog●I/OthreadandSQLthreadeachmaintainbinlogcoordinates●I/Othreadmaintainlas
此文档下载收益归作者所有