Replication Tutorial Presentation

MySQL Replication TutorialMats KindahlSenior Software EngineerReplication TechnologyLars ThalmannDevelopment ManagerReplication/BackupTutorial Outline Terminology and Basic Concepts Basic Replication Replication for scale-out Replication for high-availability The binary log Statements and transactions Cluster ReplicationTerminology andBasic ConceptsMySQL ReplicationHow?Why?High availability SnapshotsFail-over possible BackupScale-out mysqlbinlogQueries on many mysqldumpserversBinary logOff-site processingDo not disturb master ReplicationReporting Point-in-time recoveryMMyySSQQLL ServerTerminologyMasterMaster serverChanges dataKeeps log of changesReplicationSlave serverAsk master for eventsExecutes eventsSlaveBinary logLog every changeSplit into transactional groupsMaster MySQL ServerMMyySSQQLL ServerTerminologyMasterSynchronous replicationTransactions are not committed until data is replicated and appliedProvides consistency, but slowerReplicationProvided by MySQL ClusterAsynchronous replicationTransactions committed immediately and replicated SlaveNo consistency, but fasterProvided by MySQL ServerresbdeSlIinasum/QyslOoi LonpglogReplication system architectureSlaveMasterSession Dump I/O SQLBinary log Relay logBinary log (binlog) records all changesConsists of transactional groupsUsed for replication and point-in-time recoveryresbdeSlIinasum/QyslOoi LonpglogReplication system ...