MySQL performance optimization: 50% more work with 60% less latency variance

Re:MySQL performance optimization: 50% more work with 60% le... by eli on Friday June 26, 2015 @05:33PM (#9787871)

Is it not possible that the peak load is more than 3x the average load? With your own hardware you have to be provisioned for peak load 100% of the time.

[ Parent | on HN ]

Re:MySQL performance optimization: 50% more work with 60% le... by fweespeech on Friday June 26, 2015 @05:46PM (#9787947)

> Oh, did you know you can do the same thing at other providers for cheaper? :|

https://www.stormondemand.com/servers/baremetal.html 32/64GB - $0.75/hr

https://www.linode.com/pricing 20/64GB - $.96/hr and bandwidth

http://aws.amazon.com/ec2/pricing/ 16/64GB - $1/hr + bandwidth costs @ [varies]

Even if you take your premise at face value, AWS is literally the most expensive option.

Personally, I've never seen a real world use case where you dropped below 33% capacity. In practice, you can get hourly billing for cheaper than AWS anyway with providers large enough to meet most customers needs.

[ Parent | on HN ]

Re:MySQL performance optimization: 50% more work with 60% le... by tracker1 on Friday June 26, 2015 @10:28PM (#9788853)

Linode, and most alternatives, don't have S3/Blob storage as a service.. also missing are distributed key-value storage as a service and sql as a service.

Generally, with any given service as you can scale it makes sense to run your own instances.. but realistically someone who knows insert-tech better than AWS/Azure admins is a pretty rare breed, and having to in-source those specific skills costs in terms of time and money, redundancy even more so.

If you have a team of 3-5 people, you can do far more with AWS or Azure than you can most alternatives... Employees aren't free.

[ Parent | on HN ]