Please enable JavaScript.

Coggle requires JavaScript to display documents.

Database Service - Coggle Diagram

- - - - Strict schema
      - Table is based on row and column column
      - query based on select cmd
  - - - dynamic schema
      - based on key value
      - Query bsed on query function or scan (less efficient)
    - - features
        
        serverless
- - - - 2 type of AWS service
        
        Managed Service (RDS)
        
        AWS will install DB engine, daily backup, HA option and patching
        
        HA option
        
        AWS will auto create standby DB instance at a different AZ
        
        standby instance will be promoted to master when master instance
        
        this feature is called Multi-AZ
        
        name of the service is RDS (Relational Database Services)
        
        Rrequirement
        
        1.region
        
        VPC
        
        subnet grouppublic subnet and private subnet
        
        How long to retain the backup
        
        MAster user ID and pwd to access RDS DB instance
        
        security group
        
        window for maintenance and backup
        
        backup type
        
        Automatic backup
        
        snapshot
        
        point in time backup
        
        6 DB engines to choose
        
        setup steps
        
        specify instance class
        
        type
        
        GP
        
        Memory optimized
        
        burstable performance
        
        type of storage
        
        SSD GP
        
        SSD Provision IOPS
        
        Magnetic
        
        Unmanage services
        
        Setup by by launching Ec2, install DB engine and do backup by yourself