AWS Classroom Series – 07/Jan/2021

High Availability (HA) on Amazon RDS

  • AWS RDS supports High Availability Architectures, So lets explore options
    • Single-AZ Deployment
    • Multi-Az Deployment

Note: Install mysql workbench

  • Install mysql workbench using chocolatey
choco install mysql.workbench

Single AZ Deployment

  • If we want to use RDS for some Proof of Concept (POC), deploy development environment or deploy non critical, non production environments, we might not need HA, so in these case we can launch RDS instance in Single AZ Preview
  • Lets create a single AZ deployment Preview
  • Connecting to mysql db over public network (not recommended) Preview Preview

High AVAILABILITY MULTIPLE AZ (multi Az)

  • When we are planning for mission-critical databases for production usage, we want to have High Availability since we cannot afford downtimes
  • AWS gives option to deploy a data base in multi-AZ architecture
  • We can choose AZ where we want primary database instance to be in, AWS will choose standy instance and storage in other AZ of same region. Preview
  • When failover happens, the standby is automatically propagated to the aster and application traffic fails over to the new master/primary.
  • In AWS RDS database is exposed using DNS endpoint which is mapped to master and standby instances Preview Preview Preview Preview

Next Steps

  • In Reality databases will never be exposed to public networks, so how can i create a private database which is accesible only to my networks in aws
  • We need a performing database with decent cpu, ram and storage where can we configure these details
  • How i change the size of my database as the load increases
  • Will i need to go through all of the ui options to create a database rds or writing some kind of script will be better?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About learningthoughtsadmin