Workshop - MySQL

From HoerupWiki
Revision as of 12:45, 10 December 2018 by Torben (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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