The team leveraged Amazon Web Services to move the database to a cloud platform.
The services utilized include:
Relational Database Service – Host the MYSQL database.
Virtual Private Cloud – Manages the network for the RDS instance, allowing port 3306 on select IP ranges.
Identity Access Management – IAM accounts for managing the RDS and VPC on the AWS console.
To begin testing, RDS was used to create and host the new MYSQL database.
Initial test settings include:
Instance class – db.t3.micro
20gb initial storage, expandable up to 1000gb
MYSQL engine version 8.0.33
Current settings can be expanded due to the scalability of AWS if further performance is needed.
Reflects physical networking infrastructure, but virtually in a cloud environment.
Used in combination with the RDS instance to manage inbound connections to the database.
Current set up is to allow specified IP ranges for Port 3306, which is utilized by MYSQL.
Allows us to control access permissions and enforce "least privilege" by granting only the necessary privileges to conduct tasks.
Scales well by leveraging attribute-based access controls.
Allows the ability to transfer this product over to another person or group.
All team members have IAM accounts to manage AWS and future IAM accounts will be created as needed.