MySQL Installer ............................................................... 10 4.1.1 Type and Networking .............................................................................................. Installer ....................................................................... 10 4.1.1 Type and Networking .............................................................................................. configure. Configuring MySQL server may include some or all of the steps. 10 Type and Networking 4.1.1 Type and Networking • Server Configuration Type Choose the MySQL server configuration type that describes

Best Practices for MySQL with SSDs Page 3 1. Introduction Imagine a world where networking speeds became mired at 1MB/s, stayed “stuck” at that speed for 20 years and then became “unstuck

” “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