Question

How can I connect databases server to EC2 server

Answer 1

Hi@Trinu,

You can create one database in AWS using Amazon RDS service. You will find all the database available in the market. You can go through the bellow steps.

To create a DB instance

1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

2. In the upper-right corner of the Amazon RDS console, choose the AWS Region in which you want to create the DB instance.

3. In the navigation pane, choose Databases.

4. Choose Create database.

5. In Choose a database creation method, select Standard Create.

6. In Engine options, choose the engine type: MariaDB, Microsoft SQL Server, MySQL, Oracle, or PostgreSQL. Microsoft SQL Server is shown there.

7. For Edition, if you're using Oracle or SQL Server choose the DB engine edition that you want to use.

8. For Version, choose the engine version.

9. In Templates, choose the template that matches your use case. If you choose Production, the following are preselected in a later step:

   • Multi-AZ failover option

   • Provisioned IOPS storage option

   • Enable deletion protection option.

10. Set your master password.

11. Choose Create database.

It will create one database for you and you can use this. For better understanding you can go through the below link.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateDBInstance.html