Migrating to Aurora and Monitoring with PMM
Tuesday 11:30AM-12:20PM
@ Room G
Autodesk
50 minutes conference
Intermediate
Tracks:Business / Case Studies, Operations
AWS Aurora is one of the promising cloud-based RDBMS Solution. The main reason for the Aurora success is because it's based on InnoDB storage engine.
In this session, We are going to talk about how can you plan for Aurora migration in an efficient way using Terraform & Percona Products. We will be sharing our Terraform code to launch AWS Aurora clusters, tricks to check data consistency, migration path and effective monitoring using PMM.
The abstract of the session includes :
1. Why AWS Aurora? Future of AWS Aurora?
2. Build Aurora Infra
i. Using Terraform (Without Data)
ii. Restore Using Terraform & Percona XtraBackup (Using AWS S3 Bucket)
3. Verify data Consistency
4. Aurora Migration
i. 1:1 Migration
ii. Many:1 migration using Percona Server multi-source replication
5. Show Benchmarks and PMM dashboard
6. Demo
Speakers
VINEET KHANNA (Autodesk)
Senior Database Engineer
Biography:
Vineet Khanna, Senior Database Engineer at Autodesk, having 10+ years of experience as a MySQL DBA. His main professional interests are managing complex database environments, improving database performance, architecting High Availability solutions for MySQL. He has handled database environments of organizations like Chegg, Zendesk, Adobe.
Sanjeet Deshpande (Autodesk)
Senior DevOps Engineer
Biography:
Sanjeet is a Senior DevOps having 10+ years of experience and currently working with Autodesk, Singapore. experienced in architecting, deploying and managing the cloud infrastructures/applications and automation experience. he has worked extensively on AWS services like Lambda,SQS, RDS, SNS to name a few. Worked closely with engineering team of different application to suggest changes to improve uptime of the application.
Tate McDaniel (Percona)
MySQL DBA
Biography:
Tate joined Percona in June 2017 as a Remote MySQL DBA. He holds a Bachelors degree in Information Systems and Decision Strategies from LSU. He has 10+ years of experience working with MySQL and operations management. His great love is application query tuning. In his off time, he races sailboats, travels the Caribbean by sailboat, and drives all over in an RV.
Slides
Connect with Percona
Stay Connected on:
Percona Live Conferences
The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
Contact Us
For general information about the event/expo/conference, including registration, please contact us at:
- info(@) percona.com
- +1-888-401-3401
- +1-919-948-2863