Are there any less costly alternatives to Amazon's Relational Database Services (RDS)?

amazon-web-services amazon-rds
Swapnonil Mukherjee picture Swapnonil Mukherjee · May 30, 2010 · Viewed 8.5k times · Source

I have the following requirement. I have with me a database containing the contact and address details of at least 2000 members of my school alumni organization. We want to store all that information in a relation model so that

  1. This data can be created and edited on demand.
  2. This data is always backed up and should be simple to restore in case the master copy becomes unusable.
  3. All sensitive personal information residing in this database is guaranteed to be available only to authorized users.
  4. This database won't be online in the first 6 months. It will become online only after a website is built on top of it.

I am not a DBA and I don't want to spend time doing things like backups. I thought Amazon's RDS with it's automatic backup facility was the perfect solution for our needs. The only problem is that being a voluntary organization we cannot spare the monthly $100 to $150 fees this service demands.

So my question is, are there any less costlier alternatives to Amazon's RDS?

Answer

August picture August · Jun 7, 2010

In your case of just contact and address data I would choose Amazon SimpleDB. I know SimpleDB might not be suitable for a large number of tables with relationships and all, but for your kind of data I think SimpleDB is sufficient. And costs is much much cheaper than Amazon RDS.

I also wanted to use RDS, but the smallest db size costs $80 p/month.

Related questions

Access denied; you need (at least one of) the SUPER privilege(s) for this operation

So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G mysql -h xxxx.rds.amazonaws.com -u user -ppass --max-allowed-packet=33554432 db < db.sql It got stuck at: ERROR 1227 (42000) at line 374: Access …

Read More
MySQL/Amazon RDS error: "you do not have SUPER privileges..."

I'm attempting to copy my mysql database from an Amazon EC2 to an RDS: I successfully did a mysqldump of my database into my root folder using this: root@ip-xx-xx-xx-xx:~# mysqldump my_database -u my_username -p > my_database.…

Read More
Creating A New MySQL User In Amazon RDS Environment

I need to create a new MySQL user with limited permission on an existing Amazon RDS instance. After encountering a couple error messages I was sort of able to do this using the official MySQL Administrator tool and the user …

Read More