“ I have checked the documents of AWS to get into a contours on mysql aurora database with blue/green deployment and switch over. 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.

When you create a blue/green deployment, you specify the DB cluster to copy in the deployment. The DB cluster you choose is the production DB cluster and it becomes the DB cluster in the blue environment. RDS copies the blue environment's topology to a staging area, along with its configured features. The db cluster is copied to the green environment and rds configures replication from the db cluster in the blue environment to the db cluster in the green environment. RDS also copies all of the db instances in the db cluster.

A switchover promoted the db cluster, including its db instances, in the green environment to be the production db cluster. Before you switch over, production traffic is routed to the cluster in the blue environment. After you switch over production traffic is routed to the db cluster in the green environment.

In this post, you will experience how to contours on mysql aurora database with blue/green deployment and switch over. Here I have created an amazon rds mysql aurora database with a custom db parameter group and blue/green deployment. Also the addition of a switch over feature on aurora database.

Architecture Overview

The architecture diagram shows the overall deployment architecture with data flow, amazon rds mysql aurora, cloudwatch, blue/green deployment.

Solution overview

The blog post consists of the following phases:

1.Create of Amazon RDS Mysql Aurora with Custom DB Cluster Parameter Group
2.Create of Blue/Green Deployment on Aurora RDS
3.Output of Blue/Green Deployment with Switch Over Option

Phase 1: Create of Amazon RDS Mysql Aurora with Custom DB Cluster Parameter Group

1. Open the console of Amazon RDS, create a db cluster parameter group. Update the value of binlog_format as ROW in the parameter group. Create aurora mysql rds with a custom db cluster parameter group.

Phase 2: Create of Blue/Green Deployment on Aurora RDS

1. Select the database and choose the blue/green deployment option from action drop down. Start creating the deployment as a staging environment with specifying identifiers and other required parameters.

Phase 3: Output of Blue/Green Deployment with Switch Over Option

Clean-up

Delete of Amazon RDS, DB Cluster Parameter Group 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 (6.342 Hrs) = $1.84

Cost of Amazon Aurora Storage and I/O = $0.20 per 1 million I/O requests (Aurora) x 82,413 IOs = $0.02

Cost of Cloudwatch = $0.0

Total Cost = $1.86

Summary

In this post, I showed “how to contours on mysql aurora database with blue/green deployment and switch over”.

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