29 Jan 2018

Amazon RDS Vs EC2 Instance for Database - What'd you pick?

I'm looking at using RDS vs running database on a dedicated EC2 instance of Amazon AWS. While the RDS option looks promising the pricing is something on the north of what I'm willing to pay.

On the other hand, if I choose to run database on EC2, I'll have to take care of managing the instance on my own and also patching it, upgrading it and other administrative stuff.

I'm looking for advice from those who've worked with AWS. What's your experience with RDS and dedicated EC2 instance? What are the things to keep in mind?
Jeffrey Arulraj

Jeffrey Arulraj

Electronics and Communication
30 Jan 2018
Does ur requirements involve only rdbms functionalities or will be expecting feeds from other systems to flow in to ur database as well.

Cos if the later I would go with EC2 instances as it allows u a better control of what u do with all the ports available.

Else go with RDS if u have plans on running one or more of their cool analytical tools that they have built in for u.


PS: if u r going with a MS SQL server in aws I would suggest u to go with azure as the 2015 and later versions of MS SQL come with huge free spaces in them
30 Jan 2018
@Jeffrey Samuel - No, this would mostly be private database management. The only thing I'm going to need is ability to horizontally scale stuff. I'm beginnging with super small servers and add as need arises. I think with RDS that limitation no longer applies.

I'm considering AURORA and MariaDB. Which one would you recommend between these two?
Jeffrey Arulraj

Jeffrey Arulraj

Electronics and Communication
30 Jan 2018
I have worked with Maria dB personally and kinda like the way clustering and scaling across servers work. I also liked the way they handled identity and auto increment values across their server instances. So if u decide to scale down in the later point of time Maria ensures that the primary key or id constraints are not throwing errors and give out seamless down scaling.

Aurora is a black box to me. So I can't comment on that.

Share this content on your social channels -

Only logged in users can reply.