MultiCloud Classroom notes 31/Oct/2024

AWS RDS (Relational Database Services)

• In AWS for every region we have a default network available
• We can create RDS in default or our custom vpc
• While creating database we select or create a subnet group which helps in choosing subnets (AZs)
• RDS database gives a endpoint for connecting to the database
• Endpoints are generally categorized into
  • Read Enpoint
  • Read Write Endpoint
• When we create a single databases we get only one endpoint which supports both read write
• We will have a security group around database
  
• AWS gives us an option for public endpoint (accesible over internet) which is not a good idea for application databases
• For experimentation purposes we will create database with public endpoints.
• AWS RDS is Database as a service and it will not have all the versions of the database,
• AWS RDS generally offers 3 types of Database Deployment options
  • Single DB Instance:
    • This creates one db instance in any one of the subnets in subnet group
  • Multi AZ DB Instance
  • Multi AZ DB Cluster
• DB instance class: This is size of database server which includes cpu and RAM (type of hardware) Refer Here
• Disk Types:
  • io2
  • io1
  • gp3
  • gp2
• Storage Autoscaling: AWS will automatically increase disk size

Create a rds single instance for mysql

• Ensure we have a security group for mysql or create as discusse d in the session
• Watch classroom recording for guided creation
  
  
• To connect to database, we need clients
• I recommend installing azure data studio Refer Here
• Install mysql and postgres extensions
  
  

Create a rds single instance for postgresql

• Watch the classroom recording