News for hackers. Stuff that matters.
Re:Linode NextGen: The Hardware by isalmon on Monday March 18, 2013 @01:56PM (#5395913)
One of the reason why I had to switch to Digital Ocean is exactly this. I need my DB to be extremely fast, I ran some tests and, unsurprisingly, their SSD's were sometimes 10-20x faster. If Linode had an expensive SSD plan, I would totally use it for my DB and keep the same HDD linodes for the rest.
Re:Linode NextGen: The Hardware by phillmv on Monday March 18, 2013 @03:57PM (#5396742)
How big is your database? Why are you not keeping it in memory? Was this an actual, real bottleneck? How many servers do you currently rent?
Re:Linode NextGen: The Hardware by benmccann on Monday March 18, 2013 @04:44PM (#5397016)
SSDs are cheaper than RAM. I'm not keeping a 1TB database in memory.
Re:Linode NextGen: The Hardware by CCs on Monday March 18, 2013 @10:59PM (#5398648)
How about SAP HANA? They keep 100TB in memory...

They have startup program: http://www.saphana.com/community/learn/startups

Re:Linode NextGen: The Hardware by taligent on Tuesday March 19, 2013 @12:02AM (#5398842)
I've used SAP HANA and it's a fantastic piece of software arguably the best SQL database on the market today.

It also costs an absolute fortune (only approved hardware allowed) and even the AWS instance which costs $3.50/hour is not certified for production deployments. I don't know many startups who can afford $5000 a month for minimum redundancy.

Re:Linode NextGen: The Hardware by isalmon on Monday March 18, 2013 @07:36PM (#5397883)
That's not an option for me, my database is more than 20G.
Re:Linode NextGen: The Hardware by rorrr on Tuesday March 19, 2013 @05:43AM (#5399820)
32GB of RAM is $220 on Newegg.
Re:Linode NextGen: The Hardware by ericd on Tuesday March 19, 2013 @06:37AM (#5400001)
Re:Linode NextGen: The Hardware by jedicoffee on Monday March 18, 2013 @04:35PM (#5396939)
Preach!
Re:Linode NextGen: The Hardware by rorrr on Tuesday March 19, 2013 @05:44AM (#5399825)
DB in RAM still requires to write to disk, which is often the bottleneck, not the reads.
Re:Linode NextGen: The Hardware by buro9 on Tuesday March 19, 2013 @02:24AM (#5399283)
That's my conundrum.

To get what I want from my database, I want SSDs. If I move my database to another provider, then I have to move everything else to keep the latency to the database low.

Not having an SSD option even when it's expensive leaves me shopping around for where to move all of my Linodes.

Re:Linode NextGen: The Hardware by account_taken on Monday March 18, 2013 @07:01PM (#5397743)
That's suprising, when I benchmarked I/O on several DigitalOcean VPS I was getting mechanical disk performance. Which plan are you running? 10-20x faster is kind of high, are you sure you weren't hitting a cache? I usually see around a 5x speed increase on a good host with sSD.
Re:Linode NextGen: The Hardware by lukeman on Monday March 18, 2013 @08:29PM (#5398116)
I had some benchmarks show odd results and others were the expected increase.

You might try building a new server on Digital Ocean with VirtIO enabled. It's an experimental option for new servers and you can contact support to have it enabled on existing ones, but should show further improvements according to some other folks in the support community.

Re:Linode NextGen: The Hardware by isalmon on Monday March 18, 2013 @07:34PM (#5397873)
My database is on their $20/month plan. I'm not sure, maybe I was just unlucky with Linode. Just to give you an example - I have an SQL query that was taking ~90 seconds on Linode and when I moved it became 5 seconds. Again, YMMV.
Re:Linode NextGen: The Hardware by rickyc091 on Tuesday March 19, 2013 @07:45AM (#5400266)
Linode's 8GB($319) plan to Digital Ocean's 4GB($40) plan and we were seeing a 10-12% increase in performance for large queries.