Basic RDS Example
An example RDS MySQL database creation
- Customers are responsible for managing and maintaining their own Databases.
- This is for illustrative purposes, please consult AWS RDS documentation for accurate and up-to-date AWS RDS information.
- That said, this is useful useful in helping customers set-up a sandbox / non-production environment.
- Access to the RDS MySQL database from the RapidFort deployment is required:
- Please review the AWS region, availability zone, VPC, subnet, and security group settings for RapidFort and RDS and verify connectivity.
- 1.Visit the AWS console and navigate to RDS
- Select "Create database".
- 2.Choose a database creation method.
- Select Standard create.
- 3.Engine options
- Select an engine type, edition, and version that are compatible with MySQL 8.0+.
- For example: Amazon Aurora MySQL 3.02.2 (compatible with MySQL 8.0.23)
- 4.Templates
- Select Production.
- 5.Settings
- Specify a DB cluster identifier (for example, rapidfort-rds) and credentials.
- 6.Instance configuration
- Select an instance class with at least 4 vCPUs and 32 GB Memory (for example, db.r5.xlarge).
- 7.Availability & Durability
- Select the Multi-AZ deployment option that is appropriate for your environment.
- Please note that the RapidFort deployment must have access to RDS.
- 8.Connectivity
- Remember the RapidFort Host must be able to connect.
- Compute resource
- Select Don’t connect to an EC2 compute resource.
- Network type
- Select the appropriate network type for your environment.
- Virtual private cloud (VPC)
- Select the appropriate VPC for your environment.
- Please note that the RapidFort deployment must have access to the VPC.
- DB Subnet group
- Select the appropriate DB subnet group for your environment.
- Please note that the RapidFort deployment must have access to the DB subnet group.
- Public access
- Select No.
- VPC security group (firewall)
- Select the appropriate VPC security group for your environment.
- Please note that the security group must allow the RapidFort deployment to access RDS.
- Additional configuration
- Database port: 3306.
- 9.Database authentication
- Database authentication options, select Password authentication.
- RapidFort does not currently support Password and IAM database authentication. Please contact RapidFort Support if this is required for your environment.
- 10.Monitoring
- Select the appropriate monitoring options for your environment. RapidFort does not have any specific requirements for database monitoring.
- 11.Additional configuration
- Database options
- Specify an initial database name if desired. This is optional.
- DB cluster parameter group
- Select the appropriate DB cluster parameter group for your environment.
- DB parameter group
- Select the appropriate DB parameter group for your environment.
- Failover priority
- Select the appropriate failover priority options for your environment.
- Backup
- Select the appropriate backup options for your environment.
- Encryption
- Select Enable encryption.
- Select your AWS KMS key.
- Log exports
- Select the appropriate log exports options for your environment.
- Maintenance
- Select the appropriate maintenance option for your environment.
- Deletion protection
- Select the appropriate deletion production option for your environment. We recommend enabling deletion protection.
- 12.Create Database
- Select Create Database.
- 13.VERIFY CONNECTIVITY from RapidFort Platform host to the RDS Writer URL.
- timeout 30 nc -vz DB_AWS_WRITER_URL 3306mysql -u admin -P 3306 -p -h DB_AWS_WRITER_URL
Last modified 6mo ago