Basic RDS Example

An example RDS MySQL database creation

Important Notes

  • 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.

Example RDS Database Creation

  1. 1.
    Visit the AWS console and navigate to RDS
    • Select "Create database".
  2. 2.
    Choose a database creation method.
    • Select Standard create.
  3. 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. 4.
    • Select Production.
  5. 5.
    • Specify a DB cluster identifier (for example, rapidfort-rds) and credentials.
  6. 6.
    Instance configuration
    • Select an instance class with at least 4 vCPUs and 32 GB Memory (for example, db.r5.xlarge).
  7. 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. 8.
    • 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. 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. 10.
    • Select the appropriate monitoring options for your environment. RapidFort does not have any specific requirements for database monitoring.
  11. 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. 12.
    Create Database
    • Select Create Database.
  13. 13.
    VERIFY CONNECTIVITY from RapidFort Platform host to the RDS Writer URL.
    • timeout 30 nc -vz DB_AWS_WRITER_URL 3306
      mysql -u admin -P 3306 -p -h DB_AWS_WRITER_URL