To Create a Database Instance on Amazon RDS

After you set up the EC2 instance, you can create a database instance by using the RDS console.

To Create a Database Instance on Amazon RDS

1. Sign in to the AWS Management Console and open the Amazon RDS console.
2. In the top right corner of the Amazon RDS console, select the region in which you want to create the database instance.
   Note: You must select the same region for your EC2 and RDS instances and for the key pair you use to sign in to your instances.
3. In the navigation pane, click Instances.
4. Click Launch DB Instance to start the Launch DB Instance wizard.

   The wizard opens on the Engine Selection page.

5. If you want to use MS SQL database, do the following:
   1. In the Launch DB Instance Wizard window, click the Select button for the MS SQL Server Web Edition.
   2. On the DB Instance Details page, specify your database instance information, including the following settings:
      • DB Instance Class: db.m5.large
      • Allocated Storage: 20 GB
      • DB Instance Identifier
      • Master User Name
      • Master Password
6. If you want to use MySQL database, do the following:
   1. In the Launch DB Instance Wizard window, click the Select button for the MySQL Community Edition.
   2. On the DB Instance Details page, specify your database instance information, including the following settings:
      • DB Engine: as specified in System Requirements for MYOB Acumatica 2024.1
      • DB Instance Class: db.m5.large
      • Allocated Storage: 20 GB
      • Multi-AZ Deployment: No
      • DB Instance Identifier
      • Master User Name
      • Master Password
7. Click Next Step.
8. On the Additional Configuration page, provide the additional information that RDS uses to launch the SQL Server database instance, including the following setting:
   • DB Security Groups: Select the prepared security group you used when launching the EC2 instance.
9. Click Next Step.
10. On the Management Options page, you can specify backup and maintenance options for your database instance.
11. Click Next Step.
12. On the Review page, review the options for your database instance. When you're certain of all the settings, click Launch DB Instance.
13. On the final page of the wizard, click Close.
14. On the RDS console, the new database instance appears in the list of instances. The database instance will have a status of creating until it is created and ready for use. When the state changes to available, you can connect to the database instance. Depending on the database instance class and store allocated, it could take several minutes for the new instance to be available.
15. On the RDS console, select the database and check the DNS name of the instance in the Endpoint box; you will need this name during MYOB Acumatica installation.