
Amazon Aurora – Relational Database
https://searchaws.techtarget.com/definition/Amazon-Aurora
Amazon Aurora is a relational database engine from Amazon Web Services.
The engine is compatible with MySQL, which means code, applications and
drivers used in databases relying on MySQL can be used in Aurora with
minimal or no changes. MySQL is an open source database management
system based on Structured Query Language (SQL). Amazon Relational
Database Service (RDS) manages Aurora databases by handling
provisioning, patching, backup, recovery and other tasks. A developer
can migrate to and from MySQL databases by using the mysqldump (export)
and mysqlimport (import) utilities or by using RDS’ DB Snapshot
migration feature. Data migration typically takes one hour. Aurora
stores a minimum of 10 GB and scales automatically to a maximum of 64
TB. The service divides the volume of a database into 10 GB chunks,
which are spread across different disks. Each chunk is replicated six
ways across three AWS Availability Zones (AZs). If data in one AZ fails,
Aurora attempts to recover data from another AZ. Aurora is also
self-healing, meaning it performs automatic error scans of data blocks
and disks. A developers can scale up resources allocated to a database
instance and improve availability through Amazon Aurora Replicas, which
share the same storage as the Elastic Compute Cloud (EC2) instance. An
Amazon Aurora Replica can be promoted to a primary instance without any
data loss, which helps with fault tolerance if the primary instance
fails. If a developer has made an Aurora Replica, the service
automatically fails over within one minute; it takes about 15 minutes to
fail over without a replica. Amazon is a pay-per-use service in which a
user pays per instance; customers can opt for either On-Demand or
Reserve pricing. AWS also bills customers for any storage Aurora uses in
GB per month increments and according to I/O rate (per million
requests). This will be added to World Wide Web Reference Subject Tracer™. This will be added to eCommerce Resources Subject Tracer™. This will be added to Business Intelligence Resources Subject Tracer™. This will be added to Entrepreneurial Resources Subject Tracer™. This will be added to the tools section of Research Resources Subject Tracer™.
