CODEWITHSUNDEEP
amazon-web-servicesamazon-ec2amazon-rds
disasterkid
disasterkid

Reputation: 7278

Accessing a database inside an EC2 instance

Is it possible to create a database server (MySQL or PostgreSQL) inside an EC2 instance (running Windows 2016) and access it the way we access an RDS or do I need to have a separate RDS for that purpose?

My plan was to have an EC2 instance and use it as a server for accessing some Windows applications to my (small) company as well as an always-available database to store our reports.

Please let me know if I am on the wrong path.

Upvotes: 1

Views: 1203

Answers (2)

Jogendra Kumar
Jogendra Kumar

Reputation: 513

You can install and configure DB on windows and access from your app. the endpoint will be windows machine IP and running service port. you have to allow the application from the security group.

Upvotes: 1

E.J. Brennan
E.J. Brennan

Reputation: 46879

Yes, you can install MySQL or PostgreSQL on an EC2 instance, just like you would for a server that was within your company.

You of course won't have all of the extra redundancy/backup features that RDS provides for you - unless you start adding all of that yourself i.e. automated backups, slave/master configurations, read replicas etc. (and if you do start adding all of those extra features in I would reconsider your decision not to use RDS).

I do this for some smaller, less mission critical solutions I support, and generally have not had many issues; I still prefer RDS when possible, but its not always an option for me.

Upvotes: 7

Related Questions