Workshop - MySQL: Difference between revisions

From HoerupWiki
Jump to navigation Jump to search
Created page with "MySQL Ting vi skal undersøge nærmere/experimentere med * Group replication vs galera vs master/slave ** Forskellige topologiger * Backup tools: Mysqldump, mydumper, xtrabac..."
 
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
MySQL Ting vi skal undersøge nærmere/experimentere med
MySQL Ting vi skal undersøge nærmere/experimentere med


Infrastructure
* Group replication vs galera vs master/slave
* Group replication vs galera vs master/slave
** Forskellige topologiger
** Forskellige topologier
* Backup tools: Mysqldump, mydumper, xtrabackup/maribackup
* Backup tools: Mysqldump, mydumper, xtrabackup/maribackup
* Load balancing: haproxy, proxysql, maxscale
* Load balancing: haproxy, proxysql, maxscale
Line 9: Line 10:


SQL Features:
SQL Features:
* Engine talk
* index
* query planner
* geometric functions (point mm)
* geometric functions (point mm)
* Common table expressions
* Common table expressions

Latest revision as of 11:45, 10 December 2018

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