Database Setup

Amazon Aurora

1. Select RDS

2. Choose Create Database

3. Select “Easy Create” for “Amazon Aurora with MYSQL compatibility.”

4. Modify the RDS Security Group to allow TCP port 3306 access to the Control plane Instance security group only

5. Make a note of the writer instance database end-point, user, and password (It is needed later in the config below)

6. Create a new user with read-write privileges and avoid using an admin login.

   1. # Sample command to create a user using MySQL CLI 
      # Provide password on prompt 
      
      mysql -h <SQL Host URL> -u <root|master|admin> -p

   CREATE 

   USER 'Roost'@'%' identified WITH mysql_native_password by 'Roost#123'; CREATE DATABASE roostio; GRANT ALL on roostio.* to 'Roost'@'%'; # Execute the Roost Schema file, if available \. /var/tmp/Roost/db/roost.sql