Getting Started with Amazon Aurora
Published by O'Reilly Media, Inc.
MySQL and PostgreSQL Compatible DB at Scale
December 10, 2021
1:00 p.m. - 4:00 p.m. Coordinated Universal Time
185 spots availableSign up for a free trial!
or sign in.
Registration closes December 9, 2021 11:00 p.m. Coordinated Universal Time
A lot of analytics workloads today still depend on SQL databases—no matter how fast or how scalable a NoSQL database is, it doesn’t have the ability to make relations or join different datasets seamlessly to convert data into meaningful and actionable information. But SQL databases aren’t built for scalability, a critical requirement in today’s environment. When you reach the maximum limit of scale that your on-prem or cloud installation of MySQL can support, you start looking for other viable options.
Amazon Aurora is a cloud-based relational database service that’s designed to be compatible with MySQL and PostgreSQL drivers while bringing the benefits of scale and replication into the mix. So when you want to make the switch from MySQL or PostgreSQL to Aurora, you don’t have to make many changes to your application layer.
Join expert Sunny Srinidhi to explore design and performance considerations for Amazon Aurora and learn how to get the most out of the service. You’ll dive into the architecture that makes its scalability, replication, and fault tolerance possible; examine the primary node and replica nodes in-depth; discover how Aurora can recover from a failure in just a few seconds; and see how Aurora manages replication. Along the way, you’ll get hands-on to learn how to create DB clusters, tables, and databases, load test data, and run SQL queries on Aurora.
What you’ll learn and how you can apply it
By the end of this live online course, you’ll understand:
- Amazon Aurora architecture
- How Aurora manages replication
- How Aurora manages failures
- How Aurora guarantees reads and writes
- How to use the Aurora console for simple SQL queries
And you’ll be able to:
- Explain Amazon Aurora’s design considerations and how it works
- Create DB clusters, databases, and tables
- Use the Aurora console to run ad hoc SQL queries
- Connect to Aurora from a stand-alone SQL client
This live event is for you because…
- You’re a developer or DBA looking to transition from an on-premises database to a cloud or managed database.
- You’re a business intelligence (BI) professional who works with big data and runs ad hoc queries on your data.
- You’re experienced with SQL but aren’t well-versed or comfortable with new query languages.
- You want to understand Aurora as a product before making tech stack decisions.
- You want to evaluate Aurora before moving your data from an on-premises database to a cloud or managed database.
- An AWS account
- A computer with an SQL client such as MySQL Workbench installed
- A basic understanding of SQL
- Read Learning SQL, third edition (book)
The timeframes are only estimates and may vary according to how the class is progressing.
Amazon Aurora overview (10 minutes)
- Presentation: Overview of Amazon RDS and Amazon Aurora
Why choose Amazon Aurora over on-prem SQL databases? (10 minutes)
- Presentation: The problem of scaling SQL databases—vertical and horizontal scaling; issues with horizontal scaling—caching, storage, replication, query distribution, etc.; how NoSQL brought the solution—distributed and replicated; “But that’s not SQL...”—coming back to SQL from NoSQL (modern scaling solutions)
Amazon Aurora architecture (25 minutes)
- Presentation: Introduction to Amazon Aurora; high-level review of Aurora architecture; availability zones, replication, and the primary node; read replicas
Getting started with Amazon Aurora (50 minutes)
- Presentation: Creating a free AWS account; the RDS Management Console
- Hands-on exercises: Create a DB cluster (MySQL compatible); configure security groups, public access, replication, and backup
Amazon Aurora replication, failover, and backups (30 minutes)
- Presentation: The purpose of replica sets; acks from multiple nodes for both writes and reads; What happens if a primary fails?; Backups are created almost in real time; Backups range from 1 day to 35 days; shared logical volume
- Hands-on exercise: Configure replication and backups for a database
Amazon Aurora security features (15 minutes)
- Presentation: Security overview of Amazon Aurora; using IAM to configure access to resources; sharing with other AWS accounts; encryption
Hands-on with the Aurora console (30 minutes)
- Presentation: Connecting to database already created
- Hands-on exercise: Create a table; insert data to the table; query data from the table; connect to database from a standable SQL client
Wrap-up and Q&A (10 minutes)
Sunny Srinidhi is a senior software engineer at Lowe’s India, where he writes microservices to work with data at scale. He’s been working in the data space for over eight years and has experience using a variety of databases, including Oracle, MySQL, MongoDB, and Apache HBase. A frequent blogger on Medium and his own personal blog, Sunny is always interested in learning about and exploring the next exciting data-related tool. He has a primary’s degree in embedded systems from Manipal University, India.