AWS Aurora

What are the two modes of Aurora you can have?

MySQL

PostgreSQL

What are the different Database locations you can provision your Aurora DB with?

Regional - Provision Aurora DB in a single AWS region

Global - In multiple AWS regions. It has primary & secondary regions. Data written in DB in primary region gets replicated in the secondary regions in < 1 sec.

How will you achieve fast failover/high availability?

Through Multi-AZ deployment

Can you backup Aurora DB?

Yes, by creating point-in-time snapshots. We can set up retention period for these backups. We can also copy tags to snapshots.

Can you encrypt data in Aurora DB?

Yes. You can use the KMS keys.

I have added few incorrect data and I want to go back to my previous good state in Aurora DB. How would I achieve this?

You can quickly rewind to a specific point-in-time by Enabling Backtrack. But, this will cost you to save the changes you made for backtracking.

What are the various DB features available in Aurora DB?

One writer and multiple readers

One writer and multiple readers - Parallel query

Multiple writers

Serverless

What is an Aurora Cluster?

It consists the following:

Multiple DB instances

A Cluster Volume which manages data of those DB instances

When you create a regional/global Aurora DB, what are the different DBs created?

The following DBs are created:

A writer DB (writer endpoint)

A reader DB (reader endpoint)

What is Add replica auto scaling?

You can set up auto scaling for an Aurora DB (for example when the CPU utilization is > 80%). On scaling, it creates a Replica DB. You can set up min. & max. capacities (replicas) in that scaling policy.