3. Database Setup

Amazon Aurora

Select RDS
Choose Create Database
You can select “Easy Create” for “Amazon Aurora with MYSQL compatibility.”
Modify the RDS Security Group to allow TCP port 3306 access to the Controlplane Instance security group only
Make a note of the writer instance database end-point, user, and password (It is needed later in the config below)
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

<< OAuth Provider Setup VPC, Subnet & NAT Setup >>

Roost EaaS User Guide

3. Database Setup

Analytics

Related content