Slashdot is powered by your submissions, so send in your scoop


Forgot your password?
Databases Data Storage The Internet

Amazon Cloud Adds Hosted MySQL 173

1sockchuck writes "Amazon Web Services has added a relational database service to host MySQL databases in the cloud, and is also dropping prices on its Amazon EC2 compute service by as much as 15 percent. Amazon says the new service lets users focus on development rather than maintenance, but it will probably be bad news for startups offering database services built atop Amazon's cloud. Cloud Avenue warns that Amazon RDS should serve as 'a warning bell for the companies that build their entire business on Amazon ecosystem. ... They are just one announcement away from complete destruction.' Data Center Knowledge has a roundup of analysis and commentary on Amazon RDS and its impact on the cloud ecosystem."
This discussion has been archived. No new comments can be posted.

Amazon Cloud Adds Hosted MySQL

Comments Filter:
  • by Richard_at_work ( 517087 ) <{richardprice} {at} {}> on Tuesday October 27, 2009 @10:26AM (#29883561)
    While not directly comparable, the Azure platform being launched next month by Microsoft includes two relational database options:

    1. Small database (1GB)- $9.99/month
    2. Large database (10GB) - $99.99/month

    Each SQL Azure database is triple redundant automatically, and you do not pay for storage or load balancing. The Amazon model has you paying for the instance ($81 per 31 days for the small instance) plus storage charges and other costs.

    Not too impressed at the moment.
  • Re:Cost (Score:2, Informative)

    by JPDeckers ( 559434 ) on Tuesday October 27, 2009 @10:43AM (#29883785) Homepage

    No, you don't.

    You pay on run-time, not CPU time consumed, so pay 0.11*24*31 for a month, regardless of usage.

    Unless ofcourse you have a script that fires up an instance on the moment your website is accessed, and shuts it down afterward, but that might be sub-optimal in responsetime :)

  • Re:I did some maths (Score:1, Informative)

    by Anonymous Coward on Tuesday October 27, 2009 @11:15AM (#29884197)

    data transfer is about 5-10mbit month between database and php/server @ First 10 TB per Month $0.17 per GB

    It's $0.00 (per GB) if it's within the same availability zone, and $0.01 (per GB) between zones. If you're using AWS for the database, you should probably be using it for the php/server too, and you can control the zone your instances are launched in, so you can get the $0.00.

    Not sure if the rest is accurate, but I (hopefully) just cut your bill in half.

  • by raylu ( 914970 ) on Tuesday October 27, 2009 @11:22AM (#29884291) Homepage Journal

    What? []

    # Web Edition: Up to 1 GB relational database = $9.99 / month
    # Business Edition: Up to 10 GB relational database = $99.99 / month
    # Bandwidth = $0.10 in / $0.15 out / GB

    Web Edition Relational Database includes:

    * Up to 1 GB of T-SQL based relational database
    * Self-managed DB, auto high availability
    * Best suited for Web application, Departmental custom apps.

    Business Edition DB includes:

    * Up to 10 GB of T-SQL based relational database
    * Self-managed DB, auto high availability
    * Additional features in the future like auto-partition, CLR, fanouts etc.
    * Best suited for ISVs packaged LOB apps, Department custom apps []

    # Small DB Instance: 1.7 GB memory, 1 ECU (1 virtual core with 1 ECU), 64-bit platform.
    # Large DB Instance: 7.5 GB memory, 4 ECUs (2 virtual cores with 2 ECUs each), 64-bit platform
    # Extra Large DB Instance: 15 GB of memory, 8 ECUs (4 virtual cores with 2 ECUs each), 64-bit platform
    # Double Extra Large DB Instance: 34 GB of memory, 13 ECUs (4 virtual cores with 3,25 ECUs each), 64-bit platform
    # Quadruple Extra Large DB Instance: 68 GB of memory, 26 ECUs (8 virtual cores with 3.25 ECUs each), 64-bit platform

    (Price per hour)
    Small DB Instance $0.11
    Large DB Instance $0.44
    Extra Large DB Instance $0.88
    Double Extra Large DB Instance $1.55
    Quadruple Extra Large DB Instance $3.10

    Provisioned Database Storage

    For each DB Instance class, Amazon RDS provides you the ability to select from 5 GB to 1 TB of associated storage capacity for your primary data set.

    * $0.10 per GB-month of provisioned storage
    * $0.10 per 1 million I/O requests

    Data Transfer In

    * All Data Transfer $0.10 per GB

    Data Transfer Out

    * First 10 TB per Month $0.17 per GB
    * Next 40 TB per Month $0.13 per GB
    * Next 100TB per Month $0.11 per GB
    * Over 150 TB per Month $0.10 per GB

    Data transferred between two Amazon Web Services within the same region (e.g. between Amazon RDS US and Amazon EC2 US) is free of charge.

    The minimum on Amazon is 5GB, so let's compare 10GB. For Amazon at 1 month, you're paying $0.10 * 10 = $1 for storage and your $81.84 is about right. Note that this $82.84 is not comparable to the "Web Edition" offering from Microsoft, as that's for 1GB of storage. The "Small DB Instance" offering from Amazon is for an instance, not for storage, which you pay for completely separately.

    So this $82.84 figure is really only comparable to Microsoft's "Business Edition" offering at $99.99, both before bandwidth costs. Bandwidth costs apply to Azure too under a different pricing model. The data in cost is exactly the same and the data out cost is $0.02/GB more expensive for Amazon for the first 10 TB and cheaper after that. You do have to pay Amazon an additional $0.10 per 1 million I/O requests, though.

    On the other hand, Amazon allows you to buy way more than 10GB of storage, different instances, and

  • by slim ( 1652 ) <john@hartnu p . net> on Tuesday October 27, 2009 @12:27PM (#29885133) Homepage

    What you don't mention is that you pay a premium for using only what you need instead of building out your own infrastructure. In some cases, the premium is upwards of 100% (have had to run the numbers for several clients, for some it works out well, for some it's grossly more expensive).

    I think that's fair. It would be pretty amazing if it worked out cheaper in all cases, and everyone should run the numbers and evaluate the benefits before going into it.

    I know believe they're $500K by using S3 instead of their own storage servers. []

    But, there are plenty of scenarios where due to predictable loads (or simply low loads), or simple requirements Amazon's pricing model is a bad fit.

    I would be most tempted by Amazon's model if I was starting up a service, was hoping for huge sudden growth, but didn't have the confidence to invest upfront in my own hardware for that capacity.

  • by Wee ( 17189 ) on Tuesday October 27, 2009 @12:49PM (#29885439)
    I guess if a company is counting hardware costs, payroll, electricity, and stuff like that.. $80 might be a good deal. But i think most people would rather have a normal server hosted for $10-20 a month.

    "Might be a good deal"? Are you kidding? It's a raging deal! You get patching, sysadmin, hosting, etc for that $80. You likely even get more in terms of resources than you would on your "normal" $20/month hosted server (which is probably going to be some pokey virtualized instance on a grossly overloaded server some place).

    You also get backups and redundancy for that eighty bucks. The PSU blows in that hosted server and you're looking at downtime. You lose a disk and then you're looking at paying one of your employees to re-install everything, reload the DB, test it, etc.

    You can do a hell of a lot with what they're giving you. I wouldn't use it for a personal web site or anything, but for a small business who needs a basic DB-backed web site/service, it's quite a deal (especially if they are short on internal IT resources). Given MySQL's popularity in its nice, I'd say the DB choice was appropriate as well.


How many NASA managers does it take to screw in a lightbulb? "That's a known problem... don't worry about it."