RDS (Relation Database Service) provides pre-configured and easy-to-use databases. Updates, backups, and fail-overs are managed by AWS. While you could setup your own EC2 instances running MySQL, we highly recommend using RDS.
Content Controller works on MySQL 5.6 & 5.7 and the Aurora counterparts for those versions. We recommend MySQL 5.7, and that is the version we test against daily. Content Controller does not support read replicas (you can create one for your own usage, but the application won't take advantage of it).
Go to Services -> Relational Database Service.
Before launching your database, we'll need to create a Subnet Group to launch it in.
- Click on Subnet groups on the left sidebar and click the orange Create DB Subnet Group button.
Rustici CC RDS Subnet Groupfor the name, enter a description, and choose
Rustici CC VPCfor the VPC.
- Under Add Subnets, add both of your private subnets (no public subnets). Note: AWS doesn't show the subnet names here, so you may need to refer to the VPC Subnet list and take note of the IDs.
A parameter group allows you to set certain DB parameters that will be applied when an instance is launched. We'll need a custom one.
- Click on Parameter groups on the left sidebar and click the orange Create parameter group button.
- Choose mysql5.7 for the parameter group family, enter
Rustici-CC RDS-Paramter-Groupfor the name, and enter a description, then click Create.
- Select the newly created parameter group from the list.
- Search for
log_bin_trust_function_creators, check the box beside it, and click Edit parameters. Set it to
1, and click Save changes.
- Click on Instances on the left sidebar and click the orange Launch DB Instance button.
- Select MySQL and click Next.
- Choose Production - MySQL and click Next.
- Enter the following values and click Next
- DB engine version: choose the latest 5.7 version (>= 5.7.21)
- DB instance class: choose your preferred size (at least t2.medium) (contact us if you have questions about which size would be best here)
- Multi-AZ deployment: choose Create replica in a different zone
- Storage type: Choose General Purpose (SSD)
- Allocated storage: Enter at least 100 GB Read here for more information about IOPS vs storage size Note that IOPS are the first limit people usually hit when scaling up with Content Controller
- DB instance identifier:
- Master username:
ccrootor the value you chose when editing
- Master password: the value generated in
- Enter the following values and click Launch DB instance
- Virtual Private Cloud:
Rustici CC VPC
- Subnet group:
rustici cc rds subnet group
- Public accessibility: No
- Availability zone: No preference
- VPC security groups: Choose existing VPC security groups, then remove default, and add
- Database name: leave blank
- Database port: 3306
- DB parameter group:
- Option group:
- IAM DB authentication: Disable
- Encryption: Your preference
- Backup: Your preference - at least 1 day
- Monitoring: Your preference
- Log exports: Your preference
- Maintenance: Your preference (but we recommend Enable auto minor version upgrade so that security patches are applied quickly)
- Virtual Private Cloud:
Now that your database instance is up and running, you will need to setup the playbooks to point Content Controller at it.
- Select your new database from the Instances list in the Relational Database Service console.
- Scroll down to the Details panel, and copy the Endpoint. (It should look something like
- SSH to your Ansible instance and navigate to your
- Find the line
cc_db_host: localhostand replace
localhostwith the endpoint you copied from the RDS console.
- Save and exit.