2017年用开源工具之利器善MySQL运维之琐事.pdf

1、开源具之利器，善MySQL运维之琐事 MySQL Development Specification Database Architecture High Availability MySQL Backup System Slow Query Analysis Data Archiving Automated Operation What do we need to do for MySQL in Qunar?What did we do？Percona Xtradb Cluster Percona XtraBackup Percona Toolkit PT-ONLINE-SCHEMA-CHA

2、NGE PT-QUERY-DIGEST .MHA/MMM/Zabbix InceptionWhat tools can we use？Learning Research Secondary Development PracticeInventionHow do we do that？Qunar Database Architecture Galera Cluster Multi-master Replication Synchronous Replication Zero Data Loss Automatic node provisioning Inceased read/write sca

3、lability Improved SST Security through simplifed configurationPercona XtraDB Cluster Fast and reliable backups Uninterrupted transaction processing during backups Savings on disk space and network bandwidth with better compression Automatic backup verification Higher uptime due to faster restore timePercona XtraBackupQunar MySQL Backup System InceptionAutomated OperationAlter table?pt-online-schema-changept-query-digestSlow Query AnalysisData Archiving