Difference between revisions of "Workshop - MySQL"
(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 | + | ** 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