MySQL Replication

TOPIC

client
INSERT
binary log -> INSERT
Sender thread
network
received thread
relay log
Master info
INSERT
???
Applier threads
Relay log ing
binary log -> INSERT

binary log
begin E1 E2 E3 .... En COMMIT

MySQL Framework

Helps with write scaleout

Data drift

ginkgeomaps.com Fair use maps

What is new in 5.7

Higher slave throughput
Multi-threaded slave timestamp based applite (MTS)
Better Monitoring of Replicatoon
Loss-less Semi-sync replication
Improved SSL options for mysqlbinlog
mysqlbinlog --read-from-remote-server -ssl -u rpluser ...
Semi-sync replication - ACK receiver theread
allow binlog transactions to stream and not stall waiting for ACK

MultiSource replicatio

Slaves can have more than one master
Used to collect data from multiple sources
Aggrigating shards

Multi-threaded slave

binlog group commit, BGC
BGC tuning of Multi-threaded slaves, MTS

MySQL utilities high availablity

mysqlfailover
mysqlreplicate
mysqlrpladmin
mysqlrplcheck
mysqlrplshow

GTID

Global Transaction ID