Database

  • Provision an RDS Database
    • Create security group for RDS instance
    • Engine Options: MySQL
    • Templates: Free tier
    • DB Instance Identifier
    • Master Username:
    • Master Password:
    • VPC Security Group: Security_Group
    • Initial Database Name:
    • Enable Automatic Backups:
      • Backup Retention Period: 0 days
    • View the DNS endpoint
  • Launch EC2 Instance
    • Apply bootstrap script
    • View the web page of the EC2 instance
    • Configure the database setup configuration
    • Configure the wp-config.php file
    • Run the Installation
    • Install WordPress
  • Multi-AZ
    • Enable Multi-AZ
    • Verify database is “modifying”
    • Verify Multi-AZ has been enabled (i.e. available)
    • Verify read replica is “grayed out”
    • Configure backups
      • Retention Period: 35 Days
    • Verify database is “modifying”
    • Create a read replica
      • Specify the AZ
      • Specify the DB instance identifier
      • Verify the read replica may be promoted (will break replication)
      • Delete the read replica
  • Create Aurora Read Replica
    • Create Aurora read replica
      • Create replica in different zone
      • DB instance identifier: DB-AURORA-CLUSTER
    • Verify the writer node
      • View DNS endpoint address
    • Verify the reader node
      • View DNS endpoint address
    • Promote writer node to read replica
    • Take a snapshot of the writer node