Workshop - MySQL

From HoerupWiki
Revision as of 11:45, 10 December 2018 by Torben (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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