Amazon Aurora tutorials and sample code

The AWS documentation includes several tutorials that guide you through common Amazon Aurora use cases. Many of these tutorials show you how to use Amazon Aurora with other AWS services. In addition, you can access sample code in .

Note

You can find more tutorials at the AWS Database Blog. For information about training, see AWS Training and Certification.

Tutorials in this guide

The following tutorials in this guide show you how to perform common tasks with Amazon Aurora:

• Tutorial: Create a VPC for use with a DB cluster (IPv4 only)

  Learn how to include a DB cluster in a virtual private cloud (VPC) based on the Amazon VPC service. In this case, the VPC shares data with a web server that is running on an Amazon EC2 instance in the same VPC.

• Tutorial: Create a VPC for use with a DB cluster (dual-stack mode)

  Learn how to include a DB cluster in a virtual private cloud (VPC) based on the Amazon VPC service. In this case, the VPC shares data with an Amazon EC2 instance in the same VPC. In this tutorial, you create the VPC for this scenario that works with a database running in dual-stack mode.

• Tutorial: Create a web server and an Amazon Aurora DB cluster

  Learn how to install an Apache web server with PHP and create a MySQL database. The web server runs on an Amazon EC2 instance using Amazon Linux, and the MySQL database is an Aurora MySQL DB cluster. Both the Amazon EC2 instance and the DB cluster run in an Amazon VPC.

• Tutorial: Restore an Amazon Aurora DB cluster from a DB cluster snapshot

  Learn how to restore a DB cluster from a DB cluster snapshot.

• Tutorial: Use tags to specify which Aurora DB clusters to stop

  Learn how to use tags to specify which Aurora DB clusters to stop.

• Tutorial: Log DB instance state changes using Amazon EventBridge

  Learn how to log a DB instance state change using Amazon EventBridge and AWS Lambda.

Tutorials in other AWS guides

The following tutorials in other AWS guides show you how to perform common tasks with Amazon Aurora:

Note

Some of the tutorials use Amazon RDS DB instances, but they can be adapted to use Aurora DB clusters.

• Tutorial: Aurora Serverless in the AWS AppSync Developer Guide

  Learn how to use AWS AppSync to provide a data source for running SQL commands against Aurora Serverless DB clusters with the Data API enabled. You can use AWS AppSync resolvers to run SQL statements against the Data API with GraphQL queries, mutations, and subscriptions.

• Tutorial: Rotating a Secret for an AWS Database in the AWS Secrets Manager User Guide

  Learn how to create a secret for an AWS database and configure the secret to rotate on a schedule. You trigger one rotation manually, and then confirm that the new version of the secret continues to provide access.

• Tutorials and samples in the AWS Elastic Beanstalk Developer Guide

  Learn how to deploy applications that use Amazon RDS databases with AWS Elastic Beanstalk.

• Using Data from an Amazon RDS Database to Create an Amazon ML Datasource in the Amazon Machine Learning Developer Guide

  Learn how to create an Amazon Machine Learning (Amazon ML) datasource object from data stored in a MySQL DB instance.

• Manually Enabling Access to an Amazon RDS Instance in a VPC in the Amazon QuickSight User Guide

  Learn how to enable QuickSight access to an Amazon RDS DB instance in a VPC.

Tutorials and sample code in GitHub

The following tutorials and sample code in GitHub show you how to perform common tasks with Amazon Aurora:

• Creating an Aurora Serverless v2 lending library

  Learn how to create a lending library application where patrons can borrow and return books. The example uses Aurora Serverless v2 and AWS SDK for Python (Boto3).

• Creating an Amazon Aurora item tracker application with a Spring REST API that queries Aurora Serverless v2 data using SDK for Java 2.x

  Learn how to create a Spring REST API that queries Aurora Serverless v2 data. It's for use by a React application using SDK for Java 2.x.

• Creating an Amazon Aurora item tracker application that queries Aurora Serverless v2 data using AWS SDK for PHP

  Learn how to create an application that uses the RdsDataClient of the Data API and Aurora Serverless v2 to track and report on work items. The example uses AWS SDK for PHP.

• Creating an Amazon Aurora item tracker application that queries Aurora Serverless v2 data using AWS SDK for Python (Boto3)

  Learn how to create an application that uses the RdsDataClient of the Data API and Aurora Serverless v2 to track and report on work items. The example uses AWS SDK for Python (Boto3).

AWS Database Cookbook

The AWS DB Cookbook is a comprehensive database guide that teaches you how to build, deploy, and manage high-performing, cost-effective database solutions on AWS. Step-by-step tutorials guide you through creating production-ready applications and deploying the apps with CloudFormation templates. You'll learn essential AWS services as you build infrastructure, implement networking, develop serverless architectures, manage databases, and integrate generative AI. Learn AWS best practices that help you create secure, scalable solutions while optimizing costs. Whether you're new to AWS or an experienced professional, the AWS DB Cookbook helps you develop skills to solve common database challenges and implement enterprise-ready solutions. The cookbook includes the following sections:

• Getting started with AWS for DB applications – Learn AWS fundamentals like how to set up your account and Jupyter Notebook environment.

• Database fundamentals – Explore essential database concepts and compare AWS database services to choose the right solution for your workloads.

• Serverless web app with Amazon Aurora – Build an end-to-end retail application with Amazon Aurora PostgreSQL that handles inventory, orders, and customer data.

• Monitoring and observability – Set up performance tracking and configure alerts to identify potential database issues before they impact your applications.

• Scaling with Amazon Aurora – Learn to build resilient multi-Region deployments with Aurora DSQL, and how to scale your databases up for more processing power or out across multiple instances for greater capacity.

• Optimization performance and cost – Optimize your database performance and reduce costs with proven tuning strategies.

• Journey to AWS purpose-built databases – Build a secure, reliable infrastructure that scales your generative AI solutions and data-driven applications from prototype to enterprise deployment.

• GenAI applications with RAG – Build an intelligent search system for insurance and healthcare documents that uses Retrieval Augmented Generation (RAG) to deliver accurate, context-aware results.

AWS workshop and lab content portal for Amazon Aurora PostgreSQL

The following collection of workshops and other hands-on content helps you to gain an understanding of the Amazon Aurora PostgreSQL features and capabilities:

• Creating a New Aurora Cluster Manually

  Learn how to create an Amazon Aurora PostgreSQL cluster manually.

• Configure Cloud9 and Initialize Database

  Learn how to configure Cloud9 and initialize the PostgreSQL database.

• Fast Cloning

  Learn how to create an Aurora fast clone.

• Query Plan Management

  Learn how to control execution plans for a set of statements using query plan management.

• Cluster Cache Management

  Learn about Cluster Cache Management feature in Aurora PostgreSQL.

• Database Activity Streaming

  Learn how to monitor and audit your database activity with this feature.

• Using Performance Insights

  Learn how to monitor and tune your DB instance using Performance insights.

• Performance Monitoring with RDS Tools

  Learn how to use AWS and Postgres tools(Cloudwatch, Enhanced Monitoring, Slow Query Logs, Performance Insights, PostgreSQL Catalog Views) to understand performance issues and identify ways to improve performance of your database.

• Auto Scaling Read Replicas

  Learn how Aurora read replica auto scaling works in practice using a load generator script.

• Testing Fault Tolerance

  Learn how a DB cluster can tolerate a failure.

• Aurora Global Database

  Learn about Aurora Global Database.

• Using Machine Learning

  Learn about Aurora Machine Learning.

• Aurora Serverless v2

  Learn about Aurora Serverless v2.

• Trusted Language Extensions for Aurora PostgreSQL

  Learn how to build high-performance extensions that run safely on Aurora PostgreSQL.

AWS workshop and lab content portal for Amazon Aurora MySQL

The following collection of workshops and other hands-on content helps you to gain an understanding of the Amazon Aurora MySQL features and capabilities:

• Creating an Aurora Cluster

  Learn how to create an Amazon Aurora MySQL cluster manually.

• Creating a Cloud9 Cloud-based IDE environment to connect to your database

  Learn how to configure Cloud9 and initialize the MySQL database.

• Fast Cloning

  Learn how to create an Aurora fast clone.

• Backtrack a Cluster

  Learn how to backtrack a DB cluster.

• Using Performance Insights

  Learn how to monitor and tune your DB instance using Performance insights.

• Performance Monitoring with RDS Tools

  Learn how to use AWS and SQL tools to understand performance issues and identify ways to improve performance of your database.

• Analyze Query Performance

  Learn how to troubleshoot SQL performance related issues using different tools.

• Auto Scaling Read Replicas

  Learn how auto scaling read replicas work.

• Testing Fault Tolerance

  Learn about high availability and fault tolerance features in Aurora MySQL.

• Aurora Global Database

  Learn about Aurora Global Database.

• Aurora Serverless v2

  Learn about Aurora Serverless v2.

• Using Machine Learning

  Learn about Aurora Machine Learning.

Using this service with an AWS SDK

AWS software development kits (SDKs) are available for many popular programming languages. Each SDK provides an API, code examples, and documentation that make it easier for developers to build applications in their preferred language.

SDK documentation	Code examples
AWS SDK for C++	AWS SDK for C++ code examples
AWS CLI	AWS CLI code examples
AWS SDK for Go	AWS SDK for Go code examples
AWS SDK for Java	AWS SDK for Java code examples
AWS SDK for JavaScript	AWS SDK for JavaScript code examples
AWS SDK for Kotlin	AWS SDK for Kotlin code examples
AWS SDK for .NET	AWS SDK for .NET code examples
AWS SDK for PHP	AWS SDK for PHP code examples
AWS Tools for PowerShell	AWS Tools for PowerShell code examples
AWS SDK for Python (Boto3)	AWS SDK for Python (Boto3) code examples
AWS SDK for Ruby	AWS SDK for Ruby code examples
AWS SDK for Rust	AWS SDK for Rust code examples
AWS SDK for SAP ABAP	AWS SDK for SAP ABAP code examples
AWS SDK for Swift	AWS SDK for Swift code examples

For examples specific to this service, see Code examples for Aurora using AWS SDKs.

Example availability

Can't find what you need? Request a code example by using the Provide feedback link at the bottom of this page.