Aurora Flashcards
Aurora is compatible with which databases?
It’s compatible Postgres and MySQL
How many read and write replicas are there by default in Aurora?
There are total 6 replicas in 3 AZs for Aurora:
1. 4 copies out of 6 are for write
2. 3 copes out of 6 are for read
What is self healing?
Aurora has self healing with peer-to-peer replication
In how many volumes the data is stored?
Aurora relies on multiple volumes for data storage, with replication, self-healing, and auto-expanding features in the backend. This setup involves three Availability Zones (AZ) and a shared logical volume, ensuring data redundancy by creating six copies in different AZ for each set of data. The data is distributed across different volumes in a striped fashion, enhancing performance and minimizing the risk of data loss. The management of these volumes occurs in the background, providing a robust and reliable storage solution.
How many master nodes are there in Aurora?
There is one master in Aurora. If anything to master, the failover will occur in less than 30 seconds.
How many read replicas are there?
There are 15 read replicas are there. Any of these replicas can become master if master fails. These replicas support cross region replication.
What is the writer endpoint and reader endpoint in Aurora DB?
The writer endpoint is a DNS name that is used for writing the data to the master DB instance. In case of failure, the writer endpoint may point to the read replica and promote it as a master DB instance. The application pointing to the master DB instance would not require any change.
Reader endpoint is also a DNS name used by the applications to read the data from the read replicas. The Aurora database automatically performs the auto-scaling, and new replicas are set up to ensure the desired performance.
Autoscaling in Aurora?
- Aurora storage automatically grows from 10GB to 128TB based on data input.
- Up to 15 read replicas supported with sub-10 ms replica lag.
Failover in Aurora is instantaneous.
Is it possible to backtrack data in Aurora?
Yes the database can be restored at any point of time without using backup put a stop. Aurora uses a different method to do that.
What is Aurora replicas autoscaling?
If there are multiple read requests AWS creates more replicas depending upon the higher CPU usage of the existing read replicas.
What are Aurora’s custom endpoints?
The custom endpoints provide load balancing and high availability for each group of DB instances within your cluster. If one of the DB instances within a group becomes unavailable, Aurora directs subsequent custom endpoint connections to one of the other DB instances associated with the same endpoint.
The custom endpoints can be created to run analytical queries or any other specific purpose. These read replicas can be larger instances compared to other existing replicas.
What is Aurora serverless?
Amazon Aurora Serverless is an on-demand, autoscaling configuration for Amazon Aurora. It automatically starts up, shuts down, and scales capacity up or down based on your application’s needs. You can run your database on AWS without managing database capacity.
Manually managing database capacity can take up valuable time and can lead to inefficient use of database resources. With Aurora Serverless, you create a database, specify the desired database capacity range, and connect your applications. You pay on a per-second basis for the database capacity that you use when the database is active, and migrate between standard and serverless configurations with a few steps in the Amazon Relational Database Service (Amazon RDS) console.
What is Aurora multi-master?
Most kinds of Aurora clusters are single-master clusters. For example, provisioned, Aurora Serverless, parallel query, and Global Database clusters are all single-master clusters. In a single-master cluster, a single DB instance performs all write operations and any other DB instances are read-only. If the writer DB instance becomes unavailable, a failover mechanism promotes one of the read-only instances to be the new writer.
In a multi-master cluster, all DB instances can perform write operations. The notions of a single read/write primary instance and multiple read-only Aurora Replicas don’t apply. There isn’t any failover when a writer DB instance becomes unavailable, because another writer DB instance is immediately available to take over the work of the failed instance. We refer to this type of availability as continuous availability, to distinguish it from the high availability (with brief downtime during failover) offered by a single-master cluster
What is global Aurora?
Amazon Aurora Global Database is designed for globally distributed applications, allowing a single Amazon Aurora database to span multiple AWS Regions. It replicates your data with no impact on database performance, enables fast local reads with low latency in each Region, and provides disaster recovery from Region-wide outages.
What is Aurora Machine Learning?
Amazon Aurora machine learning enables you to add ML-based predictions to applications via the familiar SQL programming language, so you don’t need to learn separate tools or have a prior machine learning experience. It provides simple, optimized, and secure integration between Aurora and AWS ML services without having to build custom integrations or move data around.
