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