Percona MySQL About Me Qunar.com DB Director - - PowerPoint PPT Presentation

▶

Jan 21, 2023 119 likes •320 views

Percona MySQL About Me Qunar.com DB Director MySQL Inception MySQL ACMUG Oracle MySQL ACE Director What do we need to do for MySQL in

SLIDE 1

利⽤Percona開源⼯具，實現MySQL優雅維運

周彥偉去哪兒網

SLIDE 2

Qunar.com DB Director
MySQL Inception
《MySQL運維內參塞》
ACMUG
Oracle MySQL ACE Director

About Me

SLIDE 3

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?

SLIDE 4

What did we do？

SLIDE 5

Percona Xtradb Cluster
Percona XtraBackup
Percona Toolkit
PT-ONLINE-SCHEMA-CHANGE
PT-QUERY-DIGEST
…….

What tools can we use？

SLIDE 6

Learning
Research
Secondary Development
Practice＆Invention

How do we do that？

SLIDE 7

Qunar Database Architecture

SLIDE 8

Galera Cluster
Multi-master Replication
Synchronous Replication
Zero Data Loss
Automatic node provisioning
Inceased read/write scalability
Improved SST Security through simplifed configuration

Percona XtraDB Cluster

SLIDE 9

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 time

Percona XtraBackup

SLIDE 10

Qunar MySQL Backup System

SLIDE 11

SLIDE 12

SLIDE 13

SLIDE 14

Automated Operation

SLIDE 15

Alter table … ? pt-online-schema-change

SLIDE 16

Slow Query Analysis

SLIDE 17

SLIDE 18

pt-query-digest

SLIDE 19

Data Archiving

SLIDE 20

Thanks

關注開源數索據庫論壇（ODF）