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