Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 8 of 8

Thread: Is Amazon RDS Cost-Effective?

  1. #1
    Crazy Cat Lady KevinWorkman's Avatar
    Join Date
    Oct 2010
    Location
    Washington, DC
    Posts
    5,424
    My Mood
    Hungover
    Thanks
    144
    Thanked 636 Times in 540 Posts

    Question Is Amazon RDS Cost-Effective?

    tl;dr version: is 11 cents an hour (almost 1000 dollars a year) a good price to pay for a database? If not, are there any alternatives, especially ones that are compatible with AWS (other than SimpleDB, which won't work for my case)?

    Hey all,

    I've been working on a site that allows users to upload games so that people can comment, rate, and interact with the games on the site. I'm using Amazon's AWS stuff (Elastic Beanstalk for the jsp "backend", S3 to store the games, images, and other files), and it all works very well, especially considering how clueless I am.

    I had also been using Amazon RDS to store comments, ratings, user info, etc. It worked perfectly, but it costs 11 cents an hour, and I'd be running the database constantly, so that comes out to be just under 1000 dollars a year- and that's assuming my needs don't grow.

    Then I stumbled upon Amazon's SimpleDB, which seemed perfect- it's all Strings which is fine, it's easy to change the database setup (such as adding a column) without borking things up, and most of all it's free. So I completely redid my site.. and then realized that there are restrictions (can't store anything over 1 KB, which sucks because comments or descriptions can be bigger than that), plus other size restrictions on the tables. So now I'm back to square one- SimpleDB is too restricted for my needs, but RDS seems too expensive for the relatively simple tasks I'd be using it for.

    Or maybe I'm just too inexperienced to realize that 1000 bucks a year isn't that much. I have absolutely no experience with any of this stuff, so I can't tell the difference between being ripped off and finding a great bargain.

    So, can somebody with more experience point me in the right direction? Should I just suck it up and pay for RDS? It did work perfectly, so I can't complain about what I'm getting for the price, but are there any other options I should explore before committing?

    As always, thanks so much for any info you can provide!
    Useful links: How to Ask Questions the Smart Way | Use Code Tags | Java Tutorials
    Static Void Games - Play indie games, learn from game tutorials and source code, upload your own games!


  2. #2
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,318
    Thanks
    181
    Thanked 833 Times in 772 Posts
    Blog Entries
    5

    Default Re: Is Amazon RDS Cost-Effective?

    A shared web server shouldn't cost much ($3-5/month), and will typically give you a MySQL database as a default database. If this is a route worth looking at, one thing to consider would be to make sure the web server allows remote access to the database, as some will only allow connections through localhost. In this configuration you would have 2 server - one for the DB and the other for the view. Of course, if you are transferring a lot of data between, this might not be optimal efficiency-wise, as the data transfer could end up taking a while. Not sure of your configuration as it stands right now, but alternatively if you can run java on your server and have write access you could try out something like Derby (or if you have write access, just install a database yourself - again not sure of the permissions you currently have).
    Last edited by copeg; March 5th, 2012 at 10:51 AM.

  3. The Following User Says Thank You to copeg For This Useful Post:

    KevinWorkman (March 7th, 2012)

  4. #3
    Crazy Cat Lady KevinWorkman's Avatar
    Join Date
    Oct 2010
    Location
    Washington, DC
    Posts
    5,424
    My Mood
    Hungover
    Thanks
    144
    Thanked 636 Times in 540 Posts

    Default Re: Is Amazon RDS Cost-Effective?

    Thanks for the reply. For the site in question, I'm just using AWS, which I don't think is exactly like a regular server. I'm using Elastic Beanstalk to run Java, but that gets rebuilt every time I make a change, so embedding a derby database into the Java itself probably wouldn't work. And I'm using S3 to store files, but I don't think you can host a non-Amazon database there (and my googling seems to confirm this).

    However, you did make me realize a potential solution that I've been overlooking. Although this site is entirely on Amazon, I do already pay for hosting elsewhere for my other site. That site is just static html, but the hosting plan does include access to a database that I've never used. I can perhaps host the database on my existing webhost and access it from Amazon. More research is required, but for now, I'm thinking this is a promising lead.

    Thanks again! This might not pan out (for example I have no idea the kinds of limitations my current plan sets for database access, size, bandwidth, etc), so I'm still open for suggestions, but for now I'm feeling pretty good about exploring this option.
    Useful links: How to Ask Questions the Smart Way | Use Code Tags | Java Tutorials
    Static Void Games - Play indie games, learn from game tutorials and source code, upload your own games!

  5. #4
    Super Moderator Sean4u's Avatar
    Join Date
    Jul 2011
    Location
    Tavistock, UK
    Posts
    637
    Thanks
    5
    Thanked 103 Times in 93 Posts

    Default Re: Is Amazon RDS Cost-Effective?

    I'm not advocating it - I have to confess to never actually using it for anything other than the demo programs - but could you use JuppMap on AWS? Some of the demo programs can be used to test storing / retrieving large binary objects and files. I suspect it would die horribly if you were slashdotted but while your load is low, it might provide free and easy storage. I've just noticed the "Sign up for free account" - that'll be tonight's 'interesting thing to try'.

    [edit]I did try it, but foo ... bar. Editing the demo console app was a silly idea. I'll try another day with a tomcat test
    Last edited by Sean4u; March 6th, 2012 at 10:57 AM. Reason: Realised I'm an idiot

  6. The Following User Says Thank You to Sean4u For This Useful Post:

    KevinWorkman (March 7th, 2012)

  7. #5
    Crazy Cat Lady KevinWorkman's Avatar
    Join Date
    Oct 2010
    Location
    Washington, DC
    Posts
    5,424
    My Mood
    Hungover
    Thanks
    144
    Thanked 636 Times in 540 Posts

    Default Re: Is Amazon RDS Cost-Effective?

    I've been checking out JuppMap, but I'm not sure exactly how I could use it for my purposes. I only need to store primitives, but I need to be able to do things like sort by and average, which is one of the limitations of Amazon's SimpleDB. But out of curiosity, how are you running JuppMap on Amazon? The way my stuff works, all the Java gets blown away and rebuilt every time I update the system, which at this point is several times a day. My info needs to persist indefinitely outside of the Java. I could store everything on S3, but then that makes it hard and very inefficient to do averages, sorts, etc.

    For those reasons, and for help with maintainability, I'm still thinking my best bet is to look at using a simple hostgator database that my Amazon stuff accesses, at least until my needs outgrow it. Unfortunately, real life calls, and I won't be able to try anything until Wednesday night.
    Useful links: How to Ask Questions the Smart Way | Use Code Tags | Java Tutorials
    Static Void Games - Play indie games, learn from game tutorials and source code, upload your own games!

  8. #6
    Super Moderator Sean4u's Avatar
    Join Date
    Jul 2011
    Location
    Tavistock, UK
    Posts
    637
    Thanks
    5
    Thanked 103 Times in 93 Posts

    Default Re: Is Amazon RDS Cost-Effective?

    *<:-) I'm an idiot. I wondered how the Java Console App ran on AWS. I've just looked and seen some keys in my preferences back-end which could only have been created by AwsConsoleApp. I thought the ant config somehow magically deployed the console app on ... I'd better stop now.

    All my free time has suddenly evaporated. One day I'll get round to deploying a tomcat test and retrying. I'll edit my other post just in case it confuses anybody.

  9. #7
    Crazy Cat Lady KevinWorkman's Avatar
    Join Date
    Oct 2010
    Location
    Washington, DC
    Posts
    5,424
    My Mood
    Hungover
    Thanks
    144
    Thanked 636 Times in 540 Posts

    Default Re: Is Amazon RDS Cost-Effective?

    Quote Originally Posted by Sean4u View Post
    *<:-) I'm an idiot. I wondered how the Java Console App ran on AWS. I've just looked and seen some keys in my preferences back-end which could only have been created by AwsConsoleApp. I thought the ant config somehow magically deployed the console app on ... I'd better stop now.
    Haha, don't worry, I've spent the last few months banging my head against various concepts and realizing how little I actually know. That's a big reason why I wanted to get some other opinions on this database stuff.

    Quote Originally Posted by Sean4u View Post
    All my free time has suddenly evaporated. One day I'll get round to deploying a tomcat test and retrying. I'll edit my other post just in case it confuses anybody.
    Same. But the good news is that it's really easy to use Amazon's Elastic Beanstalk to get a webapp up and running. Here's the tutorial I used, it might help you in the future: Getting Started with AWS Elastic Beanstalk Deployment in Eclipse : Articles & Tutorials : Amazon Web Services
    Useful links: How to Ask Questions the Smart Way | Use Code Tags | Java Tutorials
    Static Void Games - Play indie games, learn from game tutorials and source code, upload your own games!

  10. #8
    Crazy Cat Lady KevinWorkman's Avatar
    Join Date
    Oct 2010
    Location
    Washington, DC
    Posts
    5,424
    My Mood
    Hungover
    Thanks
    144
    Thanked 636 Times in 540 Posts

    Default Re: Is Amazon RDS Cost-Effective?

    Update: I've successfully created a hostgator database and can access it using hibernate, which means I can access it through my Amazon stuff. Everything is working perfectly!

    I think I pay something like 60 bucks a year for the hostgator stuff (which I'd be paying for regardless of the database), so this is definitely a step up from the close to 80 bucks per month I'd be paying for Amazon's RDS database.

    Amazon actually did drop their RDS prices yesterday, but for my purposes, I'd only be saving half a cent per hour (still paying 10.5 cents an hour), so it's not really worth it.

    So my current plan is to use hostgator's database for the foreseeable future. Thanks again for your guys' input, it really did help clarify my thoughts.
    Useful links: How to Ask Questions the Smart Way | Use Code Tags | Java Tutorials
    Static Void Games - Play indie games, learn from game tutorials and source code, upload your own games!

Similar Threads

  1. Setting up a reseller hosting company cost
    By Veyper in forum Totally Off Topic
    Replies: 6
    Last Post: November 9th, 2011, 02:34 PM
  2. how to merge java objects with effective dates
    By java4ulok in forum What's Wrong With My Code?
    Replies: 4
    Last Post: June 10th, 2011, 01:24 PM
  3. Basic program which gets cost, adds tax, gets payment then calculates change.
    By bibboorton in forum What's Wrong With My Code?
    Replies: 6
    Last Post: August 25th, 2010, 10:31 AM
  4. Check difference between no. of stops, calculate cost
    By JavaStudent23 in forum Java Theory & Questions
    Replies: 4
    Last Post: November 17th, 2009, 03:29 AM