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

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

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

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



  Download 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