burgessconsulting-blog

[burgessconsulting-blog]

What is AWS Aurora?

Amazon Web Service more commonly known as AWS offers and develop AWS Aurora, a relational database service. AWS Aurora is compatible with MySQL and PostgreSQL databases. These services are built for the cloud.

AWS Aurora combines performance and availability of traditional large databases with a cost-effective and simple open-source database.

Amazon RDS manages AWS Aurora and fully automates time-consuming tasks like database setup hardware provisioning, backups, and patching.

 Is AWS Aurora a database?

The clear answer is YES. AWS Aurora is a database.

For those of you who do not know a relational database, it is a set of data in tables format (hence database table). That data can be accessed and reassembled in various ways without reorganising the database table.

 In simpler term, a structure to organise data in tables with rows and columns.

 This database contains:

·         one or more data categories in columns sometimes called attributes

·         and rows also called a record or tuple

 Each row contains a unique data, or key, for the columns.

Both row and column comprise a table.

Each table has a unique primary key which identifies the information in a table.  

A foreign key, a key coming from a different table, can be set to link on the primary key of another table. This builds the relationship between tables.  

  How is AWS Aurora compared to MySQL and PostgreSQL?

 Amazon Aurora is surprisingly faster than standard MySQL databases up to five times.

To regular PostgreSQL databases it is three times faster.

Amazon Aurora provides security, reliability, and availability of commercial databases at 1/10th of the price.

Amazon Aurora has 99.99% availability increasing both MySQL and PostgreSQL performance.

It integrates the database engine with an SSD backed virtual storage layer for its workloads.

This storage is self-healing, distributed, and fault-tolerant. The repair on disk failures never loses the available database. AWS Aurora detects database crashes automatically and restarts without the need to rebuild the database cache or crash recovery.

Aurora auto-scales up to 64TB per database instance, if an instance fails, Amazon Aurora will automatically recover to one of fifteen low-latency read replicas. It will backup continuously to Amazon S3 and replicates on three Availability Zones (AZs).

 Summary of Benefits:

·         High Performance and Scalability

o   faster than commercial databases, easily scale database deployment up and down from small to large instances

 ·         High Availability and Durability

o   designed to offer greater than 99.99% availability, replicates and backup on different storages, with global database quick recovery is fast

 ·         Highly Secure

o   Amazon provides multiple levels of security:

§  using Amazon VPC, it can bring network isolation

§  create and control encryption at rest using keys through AWS KMS (Key Management System),

§  use SSL to transit data encryption

 ·         MySQL and PostgreSQL Compatible

o   You can easily migrate MySQL or PostgreSQL databases to Aurora using standard snapshots or import/export tools

 ·         Fully Managed

o   Amazon Relational Database Service gives you worry-free database management tasks such as hardware provisioning, software patching, setup, configuration, or backups

 ·         Migration Support

o   Amazon Aurora is the best for database migrations to the cloud since its compatible with MySQL and PostgreSQL.

#AWS #data migration #AWS aurora

[burgessconsulting-blog]