Skip to main content

Amazon Aurora – Cloud SQL DB Essentials

Course

Intro Video

Photo of Julie  Elkins

Julie Elkins

AWS Training Architect I in Content

Julie credits signing up for Linux Academy and taking the AWS CSA with changing her life. It helped her realize that she wanted to do for others what Linux Academy did for her! She started a YouTube channel with lessons on subjects she struggled with; hoping to help others. She now humbly holds all AWS associate certifications and both AWS Professional certifications as well. Her two daughters encourage and inspire her daily to dream and reach for her goals.

Length

06:44:57

Difficulty

Beginner

Videos

39

Hands-on Labs

3

Course Details

Hi, and welcome to this course on Amazon Aurora!  In this course we will be covering all of the essentials that you need to know for Amazon Aurora with some deeper dives into Aurora's features, management, security, storage, and reliability, data management, performance, and also troubleshooting topics.  

 

Amazon Aurora is a proprietary technology from AWS and it is not open sourced, but Aurora is compatible with both MySQL and PostgreSQL databases.  And the Amazon Aurora db will have compatible drivers so connections from either engine has been made simple and secure.  AWS has made Aurora cloud optimized and Amazon Aurora MySQL has 5x the performance improvement over MySQL on RDS and over 3x the performance over Postgres on RDS plus tons of other performance improvements and features that we will cover throughout this course. One of the key differences we will see is that Aurora's is unique to other databases and its storage automatically grows in increments of 10 gigabytes up to 64 terabytes.

So we start off at 10 gigabytes and as we had more data our Aurora storage automatically grows with our data, so you no longer have to worry about managing your disk.  Another cool feature of Aurora is that you can have up to 15 read replicas with Aurora compared to 5 read replicas with MySQL and the replication process to the Aurora read replicas is faster.  Failover with Amazon Aurora is instantaneous and Aurora is also highly available. Aws estimates that the cost / pricing for Amazon Aurora is around 20% more than RDS, Aurora is more efficient.

 

As I said we will be covering all of the essentials of Aurora in this course plus some deeper dives too!  Let's get started!!!

Syllabus

Getting Started

Getting Started

Course Introduction

00:02:24

Lesson Description:

Hi, and welcome to this course on Amazon Aurora! In this course we will be covering all of the essentials that you need to know regarding Amazon Aurora, with some deeper dives into Aurora's features, management, security, storage, reliability, data management, performance, and also some troubleshooting topics. Amazon Aurora is a proprietary technology from AWS, but it is compatible with both MySQL and PostgreSQL databases. And the Amazon Aurora db will have compatible drivers, so connections from either engine has been made simple and secure. AWS has made Aurora cloud-optimized. Amazon Aurora MySQL delivers 5x the performance over MySQL on RDS, and over 3x the performance of Postgres on RDS. Plus, there are tons of other performance improvements and features that we will cover throughout this course. One of the key differences we will see is that Aurora is unique to other databases: its storage automatically grows in increments of 10 gigabytes, up to 64 terabytes. We longer have to worry about managing a disk! Another cool feature of Aurora is that we can have up to 15 read replicas, compared to 5 read replicas with MySQL, and the replication process to the Aurora read replicas is faster. Failover with Amazon Aurora is instantaneous, and Aurora is also highly-available. AWS estimates that while the cost/pricing for Amazon Aurora is around 20% more than RDS, Aurora is more efficient. As I said, we will be covering all of the essentials of Aurora in this course, plus some deeper dives too. Let's get started!

Using the Interactive Diagram

00:02:01

Lesson Description:

Hi and welcome back! Before we jump into the course, let's briefly look at how to use the interactive diagrams. I am, and have been, a Linux Academy student. These interactive diagrams have really helped enhance my learning. One of the biggest advantages for me is to be able to see the whole design and how all the different services work together. You will see this too throughout the course. In our next section, we will look at dbs, introduce Amazon Aurora, and cover how dbs are used. I will see you in the next section.

Introduction to Amazon Aurora

What Is a Database?

00:09:45

Lesson Description:

Hi and welcome to our first section, Introduction to Aurora. As you may have heard, companies rely on databases to power their applications. Well, that is great, but what is a database? Simply put, a database is a collection of data. A database is simply an organized collection of data and a database can store a variety of information that is usually accessed electronically. These are things like user names, email addresses, phone numbers, song titles, pictures, videos, certification numbers, sometimes encrypted passwords, etc. It can really be any data or information that is needed. And there are different types of databases. The ones we'll discuss in this course are relational databases, non-relational databases, and flat file databases.

What Is Amazon Aurora?

00:10:42

Lesson Description:

Hi and welcome back! We just discussed what databases are and in this video we will learn all about Amazon Aurora. AWS says they built Amazon Aurora because their customers where using RDS for MySQL and PostgreSQL. Customers just like us were interested in better performance, better availability, and better functionality for the open source engines in AWS's managed db environment. This started the Amazon Aurora project, beginning with MySQL and later adding PostgreSQL. There are quite a few things that sets Aurora apart from other dbs in the market. First, Aurora actually gives the performance and availability that you would expect from a high end db, but with the price point and simplicity you would expect with open source. Aurora gives 5x the performance of MySQL and 3x the performance of PostgreSQL. Aurora is different than all of the other databases that we see in AWS. While they are essentially on-premesis dbs running in the cloud, Aurora was built for the cloud!

Aurora Database Cluster - Part One

00:26:42

Lesson Description:

Hi and welcome back! In our last video, we got a high-level overview of Amazon Aurora and talked a bit about Aurora database clusters. So in this video, I want to take a bit of a deeper dive into Amazon Aurora database clusters and walk through the process of creating and deploying one.

Aurora Database Cluster - Part Two

00:09:04

Lesson Description:

Hi and welcome back! We are picking up from our last video and jumping into discussing Aurora database cluster scaling options. We will also look at endpoints, autoscaling, backtrack, and finally high availability.

How Are Databases Used?

00:05:35

Lesson Description:

Hi and welcome back. Let's wrap up our first section and talk about how databases are used. It is important to understand not only how to work with your data in databases, but why you are working with that data.

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

00:45:00

Amazon Aurora Features

MySQL and PostgreSQL

00:14:40

Lesson Description:

Hi and welcome back, we are starting a new section about all of the features of Aurora, and we'll start with Aurora MySQL and Aurora PostgreSQL.

Global Database

00:11:02

Lesson Description:

Hi and welcome back. In this video we will take a look at the features of Aurora Global Database. This a more advanced feature of Aurora, but I do want to do a quick introduction. We will stick to high level architectures and not go too deep.

Multi-Master

00:01:54

Lesson Description:

Hi and welcome back! A new feature that was released in 2019 is Aurora MySQL Multi-Master. Let's jump in and discuss why Multi-Master is a great fit for some environments!

Parallel Query

00:03:42

Lesson Description:

Hi and welcome back. Another feature of Aurora is Parallel Query. Just like Global Database, Parallel Query is a more advanced feature of Aurora. Again, we will just get a quick introduction and stick to high level architecturesn not diving too deep. We will at least see how Parallel Query with Aurora gives great performance benefits.

Performance Insights

00:03:36

Lesson Description:

Hi and welcome back! Another feature of Aurora is Performance Insights. AWS added this feature after listening to their customers who wanted more insight into what was happening to the database. Amazon RDS Performance Insights is a database performance tuning and monitoring feature that helps to quickly assess the load on a database, and determine when and where to take action. We will cover the features and look at the dashboard to see how Performance Insights can provide more visibility to your databases.

Backtrack

00:06:39

Lesson Description:

Hi and welcome back!! Probably one of the most popular features of Amazon Aurora is BackTrack. It is great for anytime there is a database corruption, accidental deletion, etc. Before backtrack was added, we had to recover by using a point in time restore with an old snapshot. We used the snapshot to restore to a new db, and then brought our logs forward to the point of the error. Not only was this time consuming, but what if a backup was old, or if there had been lots of changes since the last snashot was taken? Backtrack is almost instant. It's online, so there is no need to spin up a new database. You are simply "rewinding" your database. Let's talk about the benefits, design, and limitations of BackTrack.

Aurora Serverless

00:04:42

Lesson Description:

Hi and welcome back! Another huge feature of Aurora is Amazon Aurora Serverless. Throughout this video we will disccuss how Amazon Aurora Serverless is a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads and how Aurora Serverless can be a great solution for your environment.

Machine Learning

00:04:00

Lesson Description:

Hi and welcome back! Another huge new feature of Aurora is Aurora Machine Learning. Having this feature available with Aurora makes it easier to run Machine Learning on the data in an Aurora Database cluster. In this video, we will go through a high-level overview of Aurora and Machine Learning, the features, uses cases, and pricing, to see how you too can use Aurora Machine Learning for your data.

RDS Proxy

00:03:04

Lesson Description:

Hi, and welcome back! A brand new feature that was just announced at re:Invent 2019 is RDS Proxy. In this video we will look at how RDS Proxy can solve the issue that many applications face: having a large number of open database connections and a high connection open/close rate, which exhausts our database resources.

Additional New Aurora Features

00:06:18

Lesson Description:

Hi and welcome back. Let's wrap up this section and discuss some of the additional features that Amazon Aurora has.

Pricing

Amazon Aurora Pricing

00:07:43

Lesson Description:

Hi and welcome back. This is a brief section about Amazon Aurora pricing. One of the advantages of Aurora is that you can turn off all of the compute for your database cluster, and just pay for storage. In this video, we will talk about the pricing of Aurora, and also look at how to make sure you are cost optimizing your environment.

Creating and Managing Your Aurora DB Cluster

Performing a Proof of Concept

00:19:01

Lesson Description:

Hi, and welcome to another section where we will discuss creating and managing Aurora DB instances. We'll first take a step back to look at creating a proof of concept with Aurora, and how this can help you.

Security, Configuring Access, and Connecting to Your Aurora Database

00:08:45

Lesson Description:

Hi and welcome back! In this video we will cover how to secure and configure access to your Aurora database. We'll also look at different ways to connect to it.

Importing and Exporting Data

00:11:47

Lesson Description:

Hi and welcome back! Amazon Aurora supports various different ways of migrating data in. In this video we will be discussing different ways to import and export data into and out of Aurora, and if we are using MySQL or PostgreSQL it is a very simple procedure.

Managing Performance and Scaling for Your Aurora DB Cluster

00:03:58

Lesson Description:

Hi and welcome back! So far we have covered quite a bit on creating and managing Aurora database instances. But we're also going to take a look at options for managing performance and scaling for Aurora database clusters and database instances.

Best Practices

00:03:10

Lesson Description:

Hi and welcome back. Let's go over some AWS best practices regarding Amazon Aurora, and talk about the general options for using or migrating data to an Amazon Aurora DB cluster.

Connecting to an Aurora DB to Transfer Data

00:02:47

Lesson Description:

Hi and welcome back! Let's wrap up this section and talk about connecting to an Aurora DB to transfer data, and the different options we have.

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

00:30:00

Aurora Serverless

Using Amazon Aurora Serverless

00:09:18

Lesson Description:

Hi and welcome to another section, where we'll cover Aurora Serverless. What is Aurora Serverless? Well, let's find out!

How Amazon Aurora Serverless Works

00:10:09

Lesson Description:

Hi and welcome back! In this video, we will look at how Amazon Aurora Serverless works!

Creating an Aurora Serverless DB Cluster

00:09:00

Lesson Description:

Hi and welcome back! In our last two lessons, we learned what Amazon Aurora Serverless is and how it works. In this video we will see how to create an Aurora serverless database and a cluster. Let's get started.

Restoring, Modifying, and Viewing Your Aurora Serverless DB

00:04:13

Lesson Description:

Hi and welcome back! In our last video, we created an Aurora Serverless cluster, and in this video we will cover modifying, restoring, and viewing an Aurora Serverless DB cluster.

Using the Data API for Aurora Serverless

00:03:08

Lesson Description:

Hi and welcome back! In this video we will discuss the Data API for Aurora Serverless and how we can use it for our applications.

Using the Query Editor for Aurora Serverless

00:02:17

Lesson Description:

Hi and welcome back! Another big advantage or benefit of using Amazon Aurora Serverless is that you can utilize the query editor. In this video, we will discuss what the query editor is and how to log into our Aurora Serverless DB cluster and use the query editor from the management console.

Amazon Aurora Storage and Reliability

Storage and Reliability with Amazon Aurora

00:11:08

Lesson Description:

Hi and welcome back! In this video lesson we are going to take a bit of a deeper dive into one of the innovations that allows Aurora to deliver such great performance, availability, and reliability. What do you think that is? Let's get started and find out!

High Availability with Amazon Aurora

00:02:47

Lesson Description:

Hi and welcome back! In this video, we learn how Aurora's high availability is designed and how it can benefit our applications.

Replication and Data Management

Working with Amazon Aurora Global Databases

00:06:43

Lesson Description:

Hi and welcome back! In our Creating and Managing an Aurora DB Cluster section, we covered a huge chunk of Aurora replication and data management. But in this video, we will talk specifically about how an Aurora global database works.

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

01:00:00

Performance and Troubleshooting

Performance Tuning and Benchmarking with Amazon Aurora

00:07:07

Lesson Description:

Hi and welcome back! In this video we are going to complete a walkthrough of using the Aurora Performance Assessment Benchmarking CloudFormation template and discuss other options for managing our performance and scaling.

Amazon Aurora Troubleshooting

Troubleshooting

00:09:57

Lesson Description:

Hi and welcome back! In this video, we will discuss Aurora troubleshooting with CloudWatch logs, standard MySQL and Postgres engine specifics, and common issues along with solutions.

Setting the Capacity of an Aurora Serverless DB Cluster

00:02:03

Lesson Description:

Hi and welcome back! You may think that Aurora Serverless scales seamlessly, based on the workload on the database cluster. But in some cases, the capacity might not scale fast enough to meet a sudden change in workload. We can set the capacity explicitly for our Aurora Serverless database cluster, and afterward Aurora Serverless will be able to automatically scale the database cluster.

Troubleshooting Data API Issues

00:02:29

Lesson Description:

Hi and welcome back! In this video, we will troubleshoot common Data API issues and error messages that we may encounter.

Amazon Aurora Limits

00:01:55

Lesson Description:

Hi and welcome back! Let's wrap up our troubleshooting section and cover the limits of Amazon Aurora. What do you think Aurora's limits could be, now that we're near the end of this course? Let's find out!

Course Conclusion

Amazon Aurora Best Practices and Key Take Aways

00:04:27

Lesson Description:

Hi and welcome back. This is the last section of this course! Thank you so much for exploring Amazon Aurora with me. Let's talk about Amazon Aurora best practices, along with some key takeways from the course.

Take this course and learn a new skill today.

Transform your learning with our all access plan.

Start 7-Day Free Trial