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. |
Step 4: From Engine Options, select Amazon Aurora and select the following as per the requirement of your DB instance.
| Edition | Aurora with MySQL or PostgreSQL compatibility. |
| Capacity type | Provisioned (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. |
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. |
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. |
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.
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. |
Step 10: Lastly, click Create the 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!
Cloud
