” “Minutes?” “Hours?” © 2018 Percona. 15 Speed of Light Realities •Synchronous – Slow •Asynchronous – Data Loss Can Occur Data Propagation Can Be © 2018 Percona. 16 Scalability Scaling 35 Classical MySQL Replication © 2018 Percona. 36 Classical MySQL Replication Properties Asynchronous or Semi-Synchronous Parallel (since MySQL 5.7) Many Masters to Many Slaves (MySQL 5.7) No MySQL Group Replication (New in 5.7) “Group of Peers” Write-Anywhere or Dedicated Writer Asynchronous Replication with Flow Control Conflicts Prevented through Certification Built in Failover