Amazon Aurora: Database for the cloud

Slides from 7th AWS User Group Bosnia (Mostar) meetup.
https://www.meetup.com/AWS-User-Group-Bosnia/events/244684702/

Transcript

1. Amazon Aurora: Database for the cloud #7 AWS User Group Bosnia Meetup
2. Agenda • Amazon RDS • What is Amazon Aurora • Amazon Aurora Deep Dive • Q&A
3. Amazon Relational Database Service (RDS)
4. Amazon RDS Engines
5. Amazon Aurora • Speed and availability of commercial databases • Simplicity and cost-effectiveness of open source databases • Drop-in compatibility with MySQL and PostgreSQL
6. A service-oriented architecture applied to databases
7. Scale-out, distributed, multi-tenant architecture • Purpose-built log-structured distributed storage system designed for databases • Storage volume is striped across hundreds of storage nodes distributed over 3 different availability zones • Six copies of data, two copies in each availability zone to protect against AZ+1 failures
8. Leveraging cloud eco-system
9. Automate administrative tasks
10. Who is moving to Aurora and why?
11. Aurora performance tenets
12. IO traffic in MySQL
13. I/O traffic in Aurora (database)
14. I/O traffic in Aurora (storage node)
15. Asynchronous group commits
16. Adaptive thread pool
17. I/O Traffic in Aurora (read replica)
18. Performance Best Practices
19. Performance Best Practices
20. Important systems and OS metrics
21. Important database metrics
22. Availability “Performance only matters if your database is up”
23. Storage node availability
24. Instant crash recovery
25. Survivable caches
26. Faster, more predictable failover
27. High availability with Read Replicas
28. Up to 15 promotable read replicas
29. Database cloning
30. Amazon Aurora migration option
31. Thank you! Questions?