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
Lets create a single AZ deployment
Connecting to mysql db over public network (not recommended)
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.
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
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?