News for hackers. Stuff that matters.
Re:Aurora - New MySQL-Compatible Database Engine by zippergz on Wednesday November 12, 2014 @01:11PM (#8597104)
Has anyone been able to find specific pricing on this? All of the language I've seen about it has been vague. One of the things that's kept me from using RDS for toy projects is that it basically amounts to running another instance on top of what I already have. For a "real" project, that's a drop in the bucket, but for toys and prototypes, it can be a significant chunk of the cost (so I usually end up just running my own db on the same instance as the web server for those projects).
Re:Aurora - New MySQL-Compatible Database Engine by sciurus on Wednesday November 12, 2014 @01:16PM (#8597150)
Pricing is at http://aws.amazon.com/rds/aurora/pricing/

The cheapest is a db.r3.large for $0.29 / hr

Re:Aurora - New MySQL-Compatible Database Engine by zippergz on Wednesday November 12, 2014 @01:16PM (#8597152)
Ouch. Thanks.
Re:Aurora - New MySQL-Compatible Database Engine by astral303 on Wednesday November 12, 2014 @01:27PM (#8597219)
Reserved pricing knocks that down a significant amount if you decide to stick with this.
Re:Aurora - New MySQL-Compatible Database Engine by cjg_ on Wednesday November 12, 2014 @02:21PM (#8597559)
Just slightly more expensive than the same instance with MySQL on RDS ($0.24)
Re:Aurora - New MySQL-Compatible Database Engine by meritt on Wednesday November 12, 2014 @02:26PM (#8597584)
Yes but "Storage is automatically replicated across three AWS Availability Zones (AZs) for durability and high availability, with two copies of the data in each Availability Zone."

Is that included in the server cost? Or will you actually be paying ~3x the server + storage costs?

Re:Aurora - New MySQL-Compatible Database Engine by dk8996 on Wednesday November 12, 2014 @05:02PM (#8598543)
The pricing needs to be more clear. For example we run MYSQL RDS in production with two AZ enabled, we pay x2 the prices.... so if its only costs a bit more than MYSQL RDS and you get 3 AZ for the same price -- this is good. Moreover, there are costs that come with storage (database size), this thing seems to be smart about being more efficient with allocating space.
Re:Aurora - New MySQL-Compatible Database Engine by Wouter33 on Thursday November 13, 2014 @10:31AM (#8601973)
As i understood this your database storage is replicated to multiple places, but it still runs on one instance. It does not have failover to those replicated places. You'll have to launch multiple instances for that just like RDS. So cheaper, no.
Re:Aurora - New MySQL-Compatible Database Engine by cjg_ on Wednesday November 12, 2014 @03:14PM (#8597854)
Good question.

"Storage consumed by your database, up to 64 TB, is billed at $0.10 a GB per month and IOs consumed by your database are billed at $0.20 per million requests"

Sounds like the replication is included in this, but Amazon really should clarify that.

Re:Aurora - New MySQL-Compatible Database Engine by caw on Wednesday November 12, 2014 @05:56PM (#8598826)
Based on how Amazon's pricing tables are, it should be included.

If you go to the normal RDS pricing, there's "Single AZ" and "Multi AZ" pricing. The Multi is 2x Single because it transparently runs the 2nd instance. http://aws.amazon.com/rds/pricing/

Re:Aurora - New MySQL-Compatible Database Engine by zippergz on Wednesday November 12, 2014 @02:28PM (#8597592)
Right, but you can also get much smaller MySQL instances. It's not necessarily an "ouch" given the capacity, but it is in combination with the fact that there are no smaller instance types.
Re:Aurora - New MySQL-Compatible Database Engine by cjg_ on Wednesday November 12, 2014 @03:08PM (#8597822)
If you need a smaller instance you are probably fine with regular MySQL instance though.
Re:Aurora - New MySQL-Compatible Database Engine by AgentConundrum on Wednesday November 12, 2014 @07:43PM (#8599322)
20% is "just slightly" more expensive?
Re:Aurora - New MySQL-Compatible Database Engine by cjg_ on Thursday November 13, 2014 @04:46AM (#8600704)
For the claimed 5x performance and 6 way replication, it seems pretty cheap.
Re:Aurora - New MySQL-Compatible Database Engine by ssharp on Wednesday November 12, 2014 @01:32PM (#8597265)
I'd think for most toy projects, running more than an EC2 instance or two is overkill. At least in my experiences, running the full stack on a single server works well enough for most hobby projects.

I certainly don't want to spend $7 a day playing around with RDS for fun!

Re:Aurora - New MySQL-Compatible Database Engine by zippergz on Wednesday November 12, 2014 @01:51PM (#8597383)
Definitely. But one of the nice things about a lot of the AWS stuff is that you can build on the same infrastructure you'd use if you wanted to scale up. So if you have a toy project that ends up being more successful than you expect, it's pretty easy to just add resources. For example, DynamoDB is ultra cheap for the lowest usage levels, but simply by reserving more capacity you can scale up with absolutely no changes to your app. Makes it easy to prototype or play on the real system and not have to re-do your work later if the project becomes more than a toy.

I guess since this is MySQL-compatible it wouldn't be that hard to migrate from MySQL to Aurora, other than moving the data...

Re:Aurora - New MySQL-Compatible Database Engine by dangrossman on Wednesday November 12, 2014 @03:54PM (#8598074)
> other than moving the data

Moving data from one instance of MySQL to another is usually straightforward as a one-liner, piping a SQL dump from the old database into the new one over the network...

    mysqldump -hOldHost | mysql -hNewHost
...and waiting.
Re:Aurora - New MySQL-Compatible Database Engine by patman81 on Wednesday November 12, 2014 @01:13PM (#8597132)
During the keynote they said that Aurora starts at $0.29 per hour (that's about $200 per month).