Difference between revisions of "Workshop - MySQL"

From HoerupWiki
Jump to: navigation, 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...")
 
 
(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 12: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