News for hackers. Stuff that matters.
Re:The Future of NoSQL by skybrian on Wednesday November 12, 2014 @11:32PM (#8599949)
Migrations get expensive and risky when you have lots of data. Being able to do them incrementally is sometimes worth the complication of maintaining code to read older versions. A traditional database doesn't let you do that; you have to execute an "alter table" statement all at once.
Re:The Future of NoSQL by Rapzid on Thursday November 13, 2014 @04:21AM (#8600626)
The current state-of-the art with MySQL uses temporary tables and triggers to perform online migrations.
Re:The Future of NoSQL by nrser on Wednesday November 12, 2014 @11:56PM (#8599994)
yup. once upon a time we had a MySQL db on commodity hardware doing around 6K QPS with over 100M rows in the biggest table. you can't do much to it without taking it offline, and even then you have no idea if/when the migration will complete.