Skip to main content

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.

Labels:

Comments

Post a Comment

Popular posts from this blog

How to install/upgrade/downgrade kubectl in Linux (Ubuntu)?

To install the latest version: curl -LO "https://dl.k8s.io/release/$(curl -L -s https://dl.k8s.io/release/stable.txt)/bin/linux/amd64/kubectl" curl -LO "https://dl.k8s.io/$(curl -L -s https://dl.k8s.io/release/stable.txt)/bin/linux/amd64/kubectl.sha256" echo "$(<kubectl.sha256) kubectl" | sha256sum --check sudo install -o root -g root -m 0755 kubectl /usr/local/bin/kubectl kubectl version --client kubectl version To install a specific (v1.19.0) version: curl -LO "https://dl.k8s.io/release/v1.19.0/bin/linux/amd64/kubectl" curl -LO "https://dl.k8s.io/v1.19.0/bin/linux/amd64/kubectl.sha256" echo "$(<kubectl.sha256) kubectl" | sha256sum --check sudo install -o root -g root -m 0755 kubectl /usr/local/bin/kubectl kubectl version --client kubectl version This will install kubectl client. Run minikube start to install kubectl server.
Post a Comment
Read more

AWS Route53 - Private Hosted Zone

Post a Comment
Read more

High availability (Multi-AZ) for Amazon RDS

There is something called failover technology in Amazon. AWS RDS's Multi-AZ deployment uses this technology. If you enable Multi-AZ for an RDS DB, say MySQL DB, RDS automatically creates a standby replica in a different AZ. If the primary DB instance is in AZ-1A, then RDS creates a standby replica in AZ-1B (for example). Suppose I add a new row to a table in the primary DB, then the same row is added, almost in the same time, in the standby replica. This is called as synchronous replication . Thus, standby replicas are useful during DB instance failure/ AZ disruption . How? Because, there is no need to create a backup later because the backup has already been created. This gives high availability during planned system maintenance. Normal backup  operation - I/O activities are blocked in the primary database  Automated backup operation (standby replica) - I/O activities are not blocked This standby replica is not similar to read replica (which is used for disaster recovery). S...
Post a Comment
Read more