Category Posts Navigation

Amazon Aurora – Relational Database

Posted by Marcus Zillman

Amazon Aurora – Relational Database

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™.

Leave a Reply

Facebook Comments

Browse Categories

AwarenessWatch Newsletter