Workshop - MySQL

MySQL Ting vi skal undersøge nærmere/experimentere med

Infrastructure

• Group replication vs galera vs master/slave
  • Forskellige topologier
• Backup tools: Mysqldump, mydumper, xtrabackup/maribackup
• Load balancing: haproxy, proxysql, maxscale
• Monitoring: monyog, Percona PMM, Clustercontrol

SQL Features:

• Engine talk
• index
• query planner
• geometric functions (point mm)
• Common table expressions