Amazon Aurora (Aurora) is
a fully managed relational database engine that's compatible with MySQL and
PostgreSQL. You already know how MySQL and PostgreSQL combine the speed and
reliability of high-end commercial databases with the simplicity and cost-effectiveness
of open-source databases.
The code, tools, and
applications you use today with your existing MySQL and PostgreSQL databases
can be used with Aurora.
With some workloads, Aurora can deliver up to five
times the throughput of MySQL and up to three times the throughput of
PostgreSQL without requiring changes to most of your existing applications.
Aurora includes a high-performance storage subsystem.
Its MySQL- and
PostgreSQL-compatible database engines are customized to take advantage of that
fast distributed storage.
The underlying storage
grows automatically as needed, up to 64 terabytes. Aurora also automates and
standardizes database clustering and replication, which are typically among the
most challenging aspects of database configuration and administration.
Aurora is part of the managed database service Amazon Relational
Database Service (Amazon RDS). Amazon RDS is a web service that makes it easier
to set up, operate, and scale a relational database in the cloud.
The following points
illustrate how Aurora relates to the standard MySQL and PostgreSQL engines
available in Amazon RDS:
1. You choose Aurora as a DB
engine option when setting up new database servers through Amazon RDS.
2. Aurora takes advantage of
the familiar Amazon Relational Database Service (Amazon RDS) features for
management and administration. Aurora uses the Amazon RDS AWS Management
Console interface, AWS CLI commands, and API operations to handle routine
database tasks such as provisioning, patching, backup, recovery, failure detection,
and repair.
3. Aurora management
operations typically involve entire clusters of database servers that are
synchronized through replication, instead of individual database instances. The
automatic clustering, replication, and storage allocation make it simple and
cost-effective to set up, operate, and scale your largest MySQL and PostgreSQL
deployments.
4. You can bring data from
Amazon RDS for MySQL and Amazon RDS for PostgreSQL into Aurora by creating and
restoring snapshots, or by setting up one-way replication. You can use
push-button migration tools to convert your existing Amazon RDS for MySQL and
Amazon RDS for PostgreSQL applications to Aurora.
Aurora Scaling
- If we start with 10 GB, and we exceed the 10 GB, then it automatically scaled up to 10 GB storage. 10 GB can be incremented up to 64 TB.
- Compute resources can scale up to 32VCPUs and 244 GB of memory.
- It maintains 2 copies of your data in each availability zone, with a minimum of three availability zones. Therefore, we can say that it maintains 6 copies of your data.
- It is designed to transparently handle the loss of up to two copies of data without affecting database write availability and up to three copies without affecting read availability. It is highly redundant.
- It is also self-healing means that data blocks and disks are continuously scanned for errors repaired automatically if the errors have been detected.
Replicas
There are two types of Replicas:
- Aurora Replicas
- MySQL Read Replicas
Aurora Replicas
- Aurora Replicas are the separate points in an Aurora DB cluster which is used for scaling read operations and increasing availability.
- It can distribute up to 15 Aurora Replicas across the Availability Zones.
- The DB cluster volume is made up of multiple copies of data, and the data in a DB cluster volume is represented as single to Aurora Replicas in the DB cluster. All the Aurora Replicas return the same result of a query.
- Aurora replicas perform well for read scaling not for write operations as they are fully dedicated to the read operations in DB cluster. Write operations are mainly managed by a primary instance.
- Aurora Replicas are set as failover targets to increase the availability, i.e., if Aurora instance fails, then the Aurora Replica is promoted as a primary instance.
- If Aurora DB cluster does not include Aurora Replicas, then you need to recreate the DB instance to recover from the failure event. Aurora Replica is faster than the recreating the DB instance.
MySQL Read Replica
- It can create up to 5 Read Replicas across the Availability Zones.
- It enhances the availability of DB instance, and this feature can scale out the capacity of a single DB Instance for read-heavy database workloads.
- You can create more than one replica of a source DB instance and can serve a large volume of application read traffic from multiple copies of your data, thus increasing the read throughput.
Features of Amazon Aurora
The following are the features of Amazon Aurora:
- Available and Durable
- Higher Security
- High Scalability and performance
- Compatibility with MySQL and PostgreSQL
- Fully Managed
- Available and Durable
It provides a feature of fault-tolerant and self-tolerant storage. It offers a more than 99.99% availability, replicating 6 copies of data, i.e., 2 copies each across three availability zones and backing up the data to S3 continuously. It recovers from the physical storage failure in less than 30 seconds. With the Global Database, a single Aurora database can spread across multiple AWS regions to provide faster read and disaster recovery. - Higher Security
An Amazon Aurora provides multiple levels of security to your database. It provides network isolation using Amazon VPC, encryption using keys that you create and control through AWS Key Management Service. - High Scalability and Performance
Amazon Aurora serves up to five times better performance than MySQL at a price one -tenth of that Commercial databases while delivering similar performance and availability. You can scale up or scale down resources as your needs vary. The storage can be incremented up to 64 TB per database instance. For example, if we start with 10 GB and we exceed 10 GB, then the storage size scaled up to 10 GB automatically. - Compatibility with MySQL and PostgreSQL
An Amazon Aurora is fully compatible with MySQL and PostgreSQL. This means that you can easily migrate from MySQL or PostgreSQL to Aurora using MySQL or PostgreSQL import/export tools. The code, applications, drivers, and tools that you use with the existing databases can also be used with the Amazon Aurora. - Fully Managed
An Amazon Relational database service completely manages Amazon Aurora.You do not have to worry about various database management tasks such as hardware provisioning, software patching, setup, configuration or backups. An Amazon Aurora continuously backs up the data to Amazon S3 and provides point-in-time recovery. You can also monitor your database performance by using Amazon CloudWatch which is a tool used to detect the performance problems quickly.
No comments:
Post a Comment