News for hackers. Stuff that matters.
Re:Moving 6 Billion Messages Without Being Noticed by kfool on Sunday February 26, 2012 @10:53AM (#3635831)
The toolkit documentation reports limitations.

What they really needed is ChronicDB http://chronicdb.com

Re:Moving 6 Billion Messages Without Being Noticed by newman314 on Sunday February 26, 2012 @11:20AM (#3635908)
If you are going to flog ChronicDB, please at least disclose if you have some sort of relationship with said company. Most of your previous submissions pertain to ChronicDB.
Re:Moving 6 Billion Messages Without Being Noticed by kfool on Monday February 27, 2012 @10:34PM (#3641771)
Sorry for not disclosing I work on ChronicDB.

The author of the 6b article kindly provided more information about the time it took for the migration:

http://news.ycombinator.com/item?id=3621561

A couple of limitations of the Percona tool are related to changing data in tables with ON DELETE and ON UPDATE foreign key constraints and possible lock-ups of tables. It is a bi-directional replication tool, so it has to deal with the master-master replication case and as such does not guarantee data consistency.

Still the tool is helpful in many cases and congrats to Percona for developing it. Replication safety is a non-trivial problem in general.

Re:Moving 6 Billion Messages Without Being Noticed by waitwhat on Wednesday February 29, 2012 @02:37AM (#3646924)
They weren't doing a master-master sync.
Re:Moving 6 Billion Messages Without Being Noticed by waitwhat on Sunday February 26, 2012 @11:10AM (#3635872)
ChronicDB is a hosted solution. That isn't even remotely what DeviantArt were looking for.
Re:Moving 6 Billion Messages Without Being Noticed by kfool on Monday February 27, 2012 @10:34PM (#3641773)
ChronicDB is not only a hosted solution. It also runs locally.
Re:Moving 6 Billion Messages Without Being Noticed by waitwhat on Wednesday February 29, 2012 @02:33AM (#3646909)
Not according to your own website.

ChronicDB is a combination of a software engineer and a hosted database: You run your database in our datacenters -- http://chronicdb.com/how_it_works

Your database will be hosted in our datacenters -- http://chronicdb.com/features