Amazon Cloud Adds Hosted MySQL
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."
Turns out "the cloud" is just another name for "datacenter". Who knew?
My turnips listen for the soft cry of your love
I was a little disappointed that MySQL was the only choice offered. I was hoping for Postgres to be offered along side. It's strange to me that most ISPs/hosting companies still don't offer Postgres. MySQL is prevalent but its future is a bit shaky at the moment. Postgres is open source and offers some great features.
EvilCON - Made Famous by
I guess the warning bell is, if your business model is to host something simple and obvious on EC2, then resell it, you can expect direct competition - in this case from Amazon themselves.
To be sustainable, you need to add something difficult, or non-obvious, or that fills a niche, or stands out in some other way.
Cloud Avenue could still do OK, if they can make their offering better than Amazon's, by whatever means - a nicer UI, better management tools, better customer support, etc.
Do they offer any good databases?
With the two new types, their instance list looks like the McDonalds menu.
I'd like a Quadruple Extra Large with cheese please.
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.
The smallest instance is 11 cents an hour or ~$80 a month. That just seems like a lot to me, atleast for a personal DB. That $80 only gets you a virtual box with "1.7 GB memory, 1 ECU (1 virtual core with 1 ECU), 64-bit platform." with a max of 1 TB storage (also an additional cost). It just doesn't seem worth it, tbh.
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.
http://soylentnews.org/~tibman
I wonder if programming for cloud services will bring back the need for code that is optimized for speed (or using as little resources as possible), since you pay for the actual usage of these resources.
Pretty good is actually pretty bad.
If you run your site on a single server then it's much smaller than slashdot, no matter how many cores or ram you have. Also, it means that your site is down much more often than it should. If you want a serious infrastructure with redundancy, EC2 is a quite cheap solution, with many advantages in terms of maintenance and scaling.
Are you taking into account what the 8core xeon server with 16 GB RAM costed you and what it will cost in the future to replace it?
Pretty good is actually pretty bad.
This surprises me. Even if you go for "Extra Large" at 80c/hour that would only account for $584/month. And it's much cheaper if you go for a reserved instance.
So you must be using $1000/month worth of bandwidth and storage: wow.
If you've done your sums right, though, I'd take it as a sign that you've got a fairly unique set of requirements, that are a bad fit for the Amazon billing model.
What happens when your Xeam server with 16GB of RAM develops a hardware fault, incidentally?
Are you taking into account what the 8core xeon server with 16 GB RAM costed you and what it will cost in the future to replace it?
its rented, no upfront costs, no setup costs
and it runs an nginx web server and php-fpm instances running the site as well as the DB
cpu: E5410 8x @ 2.33GHz
ram: 16GB DDR2-667 ECC Registered
disk: 32GB SSD (OCZ-VERTEX)
bandwidth: 10TB/month
google analytics visitors/month: 7,026,784
google analytics pageviews/month: 27,389,317
mysql queries/month: 2,149,784,446
alexa ~1000 (/. is ~1100)
It rids the customers of any need for time consuming database administration tasks.
I'm sorry but administering a db just isn't that difficult or time-consuming. It takes a certain level of technical knowledge to write good SQL. If you can do that, usually you have enough skill to handle the little bit of maintenance MySQL requires. This isn't like running an Exchange or SQL Server with a ton of overhead, licensing fees, and required add-ons. You can scale MySQL for the cost of hardware. I'm not seeing a compelling reason to let Amazon run my databases.
And then there's no question of who owns the data, who has access to it, and what happens to your data if you can't pay the hosting bill? If your application or web site is so wildly successful that you have to manage failover and load balancing, then you can afford to hire people to solve those happy problems.
That's our life, the big wheel of shit. - The Fat Man, Blue Tango Salvage
see my reply before yours:
http://aws.amazon.com/rds/#pricing
Extra Large DB Instance 15 GB 8 ECUs $0.88 USD / hour
thats $642.4 / month
2,149,784,446 queries/ month @ $0.10 per 1 million I/O requests
thats another $214.9
data transfer is about 5-10mbit month between database and php/server @ First 10 TB per Month $0.17 per GB
thats another $800 or so
this amazon thing is an absolute ripoff
and so far i have had no downtime this year, compare that to the much publicized amazon downtimes ;)
There needs to be a 5 year "promise" of service by Amazon. I for one wouldn't move my junk to them without a 5 year "community pledge" or something. When a big company starts providing everything, it scares me. The only way I would sleep at night using them is if/when my servers were burning up.
wikispeedia
actually i had 0 downtime this year
i dont see how amazon can justify and order of magnitude difference in costs
IT develops in a spiral, with old ideas being re-introduced in new and better ways every few years. Sure, remote hosting has existed a long time, and virtualization was invented more than 40 years ago.
So what is new about cloud computing? The idea that a virtualized guest can run on any server, anywhere in the cloud. If you boot up an EC2 instance, you neither know nor care what the underlying hardware is, or whether it is in California or Timbuktu. In fact, one day your instance may be in one data center, and another day somewhere else entirely. With live migration, it is even possible for an instance to move from one host to another while running.
This degree of dynamic resource allocation is entirely new. It is made possible by (a) some pretty snazzy virtualization technology (Xen & co), plus (b) the hardware support (virtualization extensions) built into Intel and AMD processors since 2006.
Enjoy life! This is not a dress rehearsal.
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.
I am not sure why people are so confused about what cloud computing means in this context. It is pretty straightforward-
(1) Yes, the underlying technology is "just" a data-center that you could provision through standard channels.
(2) Yes, it is "just" a normal MySQL server that you could manage and scale through normal means.
Now take those above functions, and put them behind an API that we can call into from our software. Could you manage the same things directly? Of course! However there are use cases where being able to control these functions through is very desirable.
Now take a bunch of other infrastructure resources and put control of them all behind APIs too. One ends up with a very different thing then traditional hosting. You can't provision 100x servers/databases/hadoop nodes for a single hour or night at a traditional host based on some event your software manages, and then pay less then $100. Sure the underlying tools are the same, and there are many traditional use cases where AWS is actually more expensive. However there are an equal number of situations where the reverse is also true.
As for who owns the data, thats just FUD resulting from an unfortunate overlap in terms with things like Facebook. The AWS TOS and contract is quite clear on who owns the data. Just like any other data center, if you don't secure/encrypt your stuff it is possible for the host to look into it, but this is no more likely in AWS then at Rack Space or Data Pipe.
theres 745 Queries per second avg (see http://pastebin.com/m7f6415a1)
there are many background tasks running all the time, crunching alot of data, beside serving pages
most of the data fits nicely into the RAM (database is 12GB, most of that is log data) and the SSD drive helps alot, average loads are 2.5 @ 50% idle
also the application/site is highly tweaked and designed from the ground up
backups are done to another server on local network and to backup server on another continent which is configured to take over if theres hardware failure
"The cloud" is simply Other People's Servers. Not too buzzwordy. Of course, buzzwords' only real use to to make people think you understand things you don't, so since people are starting to understand what "the cloud" is, you can use the new acronym "OPS". If they ask what "OPS" is you can tell them, but they won't ask because they'll be afraid you'll think they're stupid.
Free Martian Whores!
forgot to mention, the site makes heavy use of javascript/ajax so the pageview figures are deceptive, considering there are alot of asynch requests
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.
-B
Ash and Hickory, straight-grained and true, make excellent bludgeons, dandy for the cudgeling of vegetarians.
I wonder how many sites are accepting and or storing credit card data on the Amazon cloud without knowing they're breaking the terms of their merchant account contracts.
Until Amazon, or any other "cloud" provider can guarantee PCI-Compliance, we can't even consider them. Our current data center guarantees Level-I compliance and we have it in writing.
"The problem with socialism is eventually you run out of other people's money" - Thatcher.
Until Amazon, or any other "cloud" provider can guarantee PCI-Compliance, we can't even consider them. Our current data center guarantees Level-I compliance and we have it in writing.
It's a valid observation.
If I was to launch a retail web site -- say, hypothetically, ThinkGeek hadn't been invented yet, and I got there first today -- then I'd expect (once I got a Slashvertisment out there) huge numbers of moochers looking at the T-shirt designs but not buying, along with a much smaller number of buyers.
So I would consider hosting images and perhaps the catalogue site on EC2/S3/RDS or some other cloud service - where I can dynamically scale to a slashdotting - and pass buyers to a secure checkout service hosted somewhere else.
Not necessarily. Amazon's offering as far as the 'cloud' goes is that you pay for a virtual server at a specific data center. Although they do have a level of hardware redundancy at one location, for full redundancy you would have to pay Amazon for 2 instances and tell them to host it at both data centers. That means it's double as expensive. But that would be the same with his setup. He would have to pay for another dedicated server at another hosting company to get redundancy.
But his point stands, if you have legitimate use for a full-blown server it would be much cheaper to host it or buy it from a random hosting company. Amazon only comes in where usage of a single server is on average 1% or less. But if all you care about is serving a webpage, there are shared hosting (even redundant) solutions that are much cheaper than Amazon. I would only recommend Amazon for custom applications where web sessions don't work but that you would want a shared server for and that is something hardly any regular hosting company accepts.
One example where Amazon makes sense would be data crunching - a customer enters some information on a website and behind the curtains, that data has to be crunched. It can't be crunched in real time for whatever reason (it is crunched by a cron job or so) and it would be too expensive to get your own virtual or dedicated server.
Custom electronics and digital signage for your business: www.evcircuits.com
If you get the High-CPU Extra Large, and pay for a 12 month reserved instances ($1820), then $0.24/hour ($173), your monthly cost is down to £325. Reserve it for 3 years ($2800) and $0.24/hour and you're down to $251 per month.
It sounds like your website needs to be up 24/7, so when considering EC2 a reserved instance might be a better way to go. If you didn't need your instance 24/7, then just pay for it by the hour.
The reserved instance does take away some of the advantage of scalability, but you have the same issue with your ISP hosted dedicated box anyway.
Brought to you by the author of such childrens' classics as "Some Kittens can Fly!" and "All Dogs go to Hell."
Ignore this new Amazon RDS thing; it's not worth the premium if you can set up MySQL yourself. An Extra-Large EC2 instance is only $584/month ($497/month with the just-announced price drop).
Regarding your queries/month calculation, each MySQL query does not necessarily result in disk I/O, especially if your entire database fits in RAM. I would be surprised if you had to spend more than $50/month on this.
I was going to suggest hosting both your web server and MySQL server on EC2, but the bandwidth costs would kill you: $1,700/month for the 10TB you mentioned in another post (assuming it's all outbound). Ouch.
[applause]
Can I quote you in full, when the next cloud story hits?
That statement sums up the whole "cloud" debate for me.
yes I know it was referring to the start-ups offering services on top of the amazon services. But my point stands.
15 milliseconds to my customers?
Deleted
Care to post some details? "Apparently " doesn't even count as personal anecdote and don't forget that anecdote is not a synonym for data.
what you are going to do long term.
note: i'm known as plugwash most places but i screwd up registering that here somehow in the past and now can't register
Copying from my blog (http://markwatson.com/blog/2009/10/i-just-tried-amzons-new-relational.html):
Amazon just released a beta of their Relational Database Service (RDS). You pay by the EC2 instance hour, about the same cost as a plain EC2, but about $0.01/hour more for a small instance, plus some storage costs, and bandwidth costs if you access the database outside of an Amazon availability zone.
RDS MyQL compatible (version 5.1) and is automatically monitored, restarted, and backed up.
Currently, there is no master slave replication, but this is being worked on (RDS beta just started today).
Here are my notes on my first use of RDS:
* Install the RDS command line tools :-)
* rds-create-db-instance --db-instance-identifier marktesting123 --allocated-storage 5 --db-instance-class db.m1.small --engine MySQL5.1 --master-username marktesting123 --master-user-password markpasstesting123
* Wait a few minutes and see if the RDS instance is ready: rds-describe-db-instances
* Open up ports for external access, if required (note, here I am opening up for world wide access just for this test): rds-authorize-db-security-group-ingress default --cidr-ip 0.0.0.0/0
* Use a mysql client to connect: mysql -h marktesting123.cyvbi77nio5f.us-east-1.rds.amazonaws.com -u marktesting123 -p
* create database recipes;
* in another bash shell: cat recipes.sql | mysql -h marktesting123.cyvbi77nio5f.us-east-1.rds.amazonaws.com recipes -u marktesting123 -p
* In the mysql client: use the remote RDS hosted database and be happy
* delete RDS instance (to stop paying for it): rds-delete-db-instance marktestng123 --skip-final-snapshot
Any mysql client libraries should work fine.
SaaS is a model of software delivery and licensing (which predates cloud computing, though since cloud computing has been available, it is mostly deployed using cloud technology) in which software is remotely hosted and access is provided over the web, usually for a fee (which may be by number of users, or by some other measure of usage.) The essential feature of SaaS is that the vendor provides a particular suite of packaged software, and the client pays for access.
Cloud computing is a model of server provisioning in which logical/virtual servers are dynamically provisioned under software control in a manner which abstracts the underlying physical hardware. Except for the software which actually manages server instances, and operating system software for the instances, there may be little or no actual software provided by the vendor -- e.g., the more basic EC2 instances -- with the application software provided by the client. The essential feature of cloud computing is dynamic server provisioning, not who provides the application software.
Cloud computing is frequently used by SaaS vendors, sometimes on their own clouds, sometimes on someone else's cloud (e.g., a third-party SaaS vendor may use Amazon EC2 or Google AppEngine to host their applications, which is why some have dubbed EC2, AppEngine, and similar cloud offerings "Platform-as-a-Service" offerings.)
But cloud computing can also be used within a company's own datacenters for its own internal applications -- again, the defining characteristic is the dynamic provisioning that abstracts physical servers -- and Software-as-a-service can be done without using cloud technology as all. Cloud computing has approximately the same relationship to Software-as-a-service that freeways have to automobiles; they're related and often used together, but very diffferent things.
yes really
So could you use this with mysqlfs to do backups?
Clearly, you've gone to a lot of effort to make sure your application fits in the hardware footprint you have for it. While I applaud that on technical grounds, I question it from a business perspective; particularly in the early stages of a startup, it might be a much better use of resources to work on features or other things that will appeal to customers, rather than on extensive tweaks or ground-up custom coding. That's the sort of thing you can do later, when you have money coming in.
The advantage of EC2 and other services like it is that they let you get a product out in front of customers, hopefully generating revenue, very quickly and with little upfront cost (either in hardware or in development time/effort), which you can scale out linearly as demand requires. Once you have something out there and are generating revenue, there are often better hosting options and lots of ways to improve performance.
There's a lot of risk in producing a highly tweaked, built-from-scratch application before you have users and cash coming in. If the project or company fails, that's a lot of time wasted. Cloud services allow what are sometimes little more than "working proof-of-concept" apps to go live, and then be improved iteratively if they actually make money (or attract more VC cash, as the case sometimes seems to be...).
I'm sure there are a lot of people who aren't fans of that development or business model, but it's pretty close to dominant in the startup world and that's where I see a lot of cloud services being used right now.
"Ladies and gentlemen, my killbot features Lotus Notes and a machine gun. It is the finest available."
Unfortunately Postgres still scales out very poorly compared to MySQL
...
Sloany cluster degrades very quickly
Where did you get your information?
Social scientists are inspired by theories; scientists are humbled by facts.