5. Database Setup

Roost stores the status of the EaaS workflow and other relevant information in Database. Below are the steps to setup an Amazon Aurora DB in AWS

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.

    # 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

     


Revision #6
Created 14 March 2023 20:39:34 by Rakesh
Updated 15 March 2023 16:36:47 by Rakesh