This short blog will show you how to create a database with Amazon Aurora. Amazon Aurora has many benefits, which makes it worthwhile to use on a large scale. In addition, its gamut of fault-tolerant and self-healing storage systems makes it one of the most trusted databases around. 

So what are you waiting for? Learn to create a database and migrate to Amazon Aurora today. 

What is Amazon Aurora?

Aurora is a relational database system compatible with MySQL and PostgreSQL. Aurora has better performance, security and availability when compared to traditional relational database systems. Moreover, it is five times faster than MySQL and three times faster than PostgreSQL. 

What is Amazon RDS (Relational Database Service)?

Amazon Relational Database Service (RDS) can manage the complex tasks of migrating, backup, replication, patching of Aurora DB automatically. 

How To Create A Database Using Aurora

Follow these steps, and you can create a database in Aurora. 

Step 1: Navigate to RDS from the AWS console. 

Step 2: Click on Create Database. 

Step 3: Choose a database creation method and select “Easy Create” or “Standard Create”. Here is what the options mean. 

Easy Create Give only essential details to create a DB instance. 
Standard Create Provides more options to custom create a DB instance.
standard create option
Choose an Easy Create or Standard Create option.

Step 4: From Engine Options, select Amazon Aurora and select the following as per the requirement of your DB instance. 

Engine options
selecting engine options
Selecting Engine Options
EditionAurora with MySQL or PostgreSQL compatibility. 
Capacity typeProvisioned (to manage instances on their own) Serverless (Specify Maximum and Minimum resources, and Aurora will scale your instances depending on the database load)

Replication Features: 

Single-Master General-purpose option with a single master  
Multi-Master Multiple instances are connected to the same storage volume. 
Engine Version Select the desired version for your Aurora MySQL/PostgreSQL instances. 

Step 5: In Templates, choose the template type based on the requirement. The two options are shown below for you: 

Production Highly Available, Consistent and Fast for production environments. 
Dev/Test Normal instances for development. 

Step 6: Under the Action Settings, choose the following options: 

DB cluster identifier Name of DB cluster 
Credential Settings Give Master Username and Password for creating DB. 
configuring the action settings
Configuring the Action Settings

Step 7: In the DB instance class, select the instance class, the memory, computational and network depending on the workload.

Memory-optimized classes (includes r classes) For production-grade, highly demanding DB instances. 
Burstable classes (includes t classes) General-purpose classes, with the ability to burst to full CPU usage. 
 Configuring the database instance class
Configuring the database instance class

Step 8: Under “Availability & durability”, select the option if replication is required. 

  • Multi-AZ deployment 
Don’t create an Aurora Replica As its name suggests, no replicas 
Create an Aurora Replica or Reader node in a different AZ Create a replica of the DB instance in a different Availability zone than the DB instance. 
choosing settings
Choosing the settings under Availability and durability. 

Step 9:  In the section Connectivity, configure the network parameters for the DB instances as per requirement. Here we can configure the VPC, Subnet Group, Security Group and Public Access. Then, expanding Additional Configuration, we can configure the custom port for a DB instance. 

Choosing the settings for Connectivity
Choosing the settings for Connectivity

Step 10: If the Capacity type in Step 3 is selected as Provisioned, we will have an additional configuration of Database Authentication. 

Password authentication Authentication using database password. 
Password and IAM database authentication Authentication using DB engine’s native password and IAM users and roles.
The Database authentication step
The Database authentication step

Step 10: Lastly, click Create the Database. 

create database

Wrapping Up 

That was all about how to set up an Amazon Aurora database. Amazon Aurora is a far superior database and handles millions of queries speedily. Hence, migrating to this database is undoubtedly worth your while. 

At SysAlly, we experiment with Cloud and the most useful information is passed on to the world as blogs. Signup for the updates.

Until later, here’s SysAlly signing off!

Get new insights right to your inbox

How can our experts help you?

Schedule your consultation

You may also like

  • By admin
  • in Tech Corner

How to Create an Amazon ECS Cluster? 

  • May 25, 2022 .
  • 5 min min
Read More
  • By admin
  • in Tech Corner

Features and Operations of Amazon EBS (Elastic Block Store)

  • Apr 21, 2022 .
  • 5 min min
Read More

Be in the know

Techno tips served hot! Subscribe now and stay atop.