Lock, Stock and Backup: Data Guaranteed
Backups are crucial in a world where data is digital and uptime is revenue. Environments are no longer bound to traditional data centers, and span multiple cloud providers as well a plethora of heterogeneous environments. We need bulletproof backups and impeccable recovery processes. This talk aims to answer the big question "how should I backup my MySQL databases?" by providing 3-2-1 backup designs, best practices and real-world solutions leveraging key technologies, automation techniques and major cloud provider services. Topics include: 1. Backup and Recovery Primer 2. Binary Log Backups 3. Logical Backups with Mydumper 4. Physical Backups with Xtrabackup 5. Leveraging Snapshots - 6.1 LVM Snapshots - 6.2 ZFS / ZVOL Snapshots (ZFS on Linux) - 6.3 AWS: Amazon S3 & EBS Snapshots - 6.4 GCP: Google Cloud Storage and Compute Engine Snapshots 7. "3-2-1" in the Cloud 8. Monitoring, Testing and Recovery 9. Encryption and Security
Engineer Engineering Engineers, Percona
Jervin is a member of the Technical Services at Percona where he partners with its customers on building reliable and highly performant MySQL infrastructures while also doing other fun stuff like watching cat videos on the internet, reading bugs for novels, and playing around servers for numbers.
MySQL Practice Manager, Percona
Loves MySQL, Dolphins and reading.