Deep Dive on MYSQL Aurora Database with Global Database Region Availability

GargeeBhatnagar - May 11 - - Dev Community

“ I have checked the documents of AWS to get into a deep dive on the mysql aurora database with global database region availability feature. In terms of cost, need to pay for amazon rds and cloudwatch.”

Amazon Aurora is a fully managed relational database engine that's compatible with Mysql and Postgresql. As 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 upto 5 times the throughput of mysql and upto 3 times the throughput of postgresql without requiring changes to most of your existing applications.

In this post, you will experience how to deep dive on mysql aurora database with global database region availability. Here I have created an amazon rds mysql aurora database with a global database.

Architecture Overview

Image description
The architecture diagram shows the overall deployment architecture with data flow, amazon rds mysql aurora, cloudwatch.

Solution overview

The blog post consists of the following phases:

  1. Create of Amazon RDS Mysql Aurora with Multi-AZ Configuration
  2. Addition of AWS Region on Regional Cluster to get a Global Database with Primary and Secondary Cluster
  3. Output of Global Database and Cloudwatch Log Group

Phase 1: Create of Amazon RDS Mysql Aurora with Multi-AZ Configuration

  1. Open the console of Amazon RDS, create a database with mysql aurora compatible. Choose the required parameters as engine version, credentials, instance configuration, availability as multi-az, vpc, database authentication, monitoring configuration with database option. Database is created as a regional cluster with reader and writer instances.

Image description

Image description

Image description

Image description

Image description

Image description

Image description

Image description

Image description

Image description

Image description

Phase 2: Addition of AWS Region on Regional Cluster to get a Global Database with Primary and Secondary Cluster

  1. Select the regional cluster and click on add aws region option. Configure the global database settings with region, instance configuration, availability, connectivity and additional configurations.. Also enable the read replica write forwarding option.

Image description

Image description

Image description

Image description

Image description

Image description

Image description

Image description

Image description

Phase 3: Output of Global Database and Cloudwatch Log Group

Image description

Image description

Image description

Clean-up

Delete of Amazon RDS and Cloudwatch Log Group.

Pricing

I review the pricing and estimated cost of this example.

Cost of Amazon Relational Database Service for Aurora MYSQL in US East (N. Virginia) = ($0.29 per RDS db.r5.large Single-AZ instance hour (or partial hour) running Aurora MySQL) x (1.458 Hrs) = $0.42

Cost of Amazon Relational Database Service for Aurora MYSQL in US West (Oregon) = ($ 0.26 per RDS db.r6g.large Single-AZ instance hour (or partial hour) running Aurora MySQL) x (0.532 Hrs) = $0.14

Cost of Cloudwatch = $0.0

Total Cost = $0.56

Summary

In this post, I showed “how to deep dive on mysql aurora database with global database region availability”.

For more details on Amazon RDS, Checkout Get started Amazon RDS, open the Amazon RDS console. To learn more, read the Amazon RDS documentation.

Thanks for reading!

Connect with me: Linkedin
Image description

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .