Skip to content
O'Reilly home
MySQL

Getting Started with Amazon Aurora

MySQL and PostgreSQL Compatible DB at Scale

174 spots available

Sign up for a free trial!

or sign in.

Registration closes September 2, 2021 10:00 p.m. Coordinated Universal Time

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.

Prerequisites

  • An AWS account
  • A computer with an SQL client such as MySQL Workbench installed
  • A basic understanding of SQL

Recommended follow-up:

Schedule

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
  • Q&A
  • Break

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
  • Q&A
  • Break

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
  • Q&A

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
  • Q&A
  • Break

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)

Your Instructor

  • Sunny Srinidhi

    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.

Start your free 10-day trial

Get started

Want to learn more at events like these?

Get full access to O'Reilly online learning for 10 days—free.

  • checkmark50k+ videos, live online training, learning paths, books, and more.
  • checkmarkBuild playlists of content to share with friends and colleagues.
  • checkmarkLearn anywhere with our iOS and Android apps.
Start Free TrialNo credit card required.