News for hackers. Stuff that matters.
Re:How we made editing Wikipedia twice as fast by tracker1 on Tuesday December 30, 2014 @05:34PM (#8817120)
Thanks for sharing... I'm kind of surprised they are using MariaDB over something like Cassandra.
Re:How we made editing Wikipedia twice as fast by gwicke on Wednesday December 31, 2014 @12:55AM (#8818401)
We are actually working on a storage service called RESTBase (https://www.mediawiki.org/wiki/RESTBase). RESTBase has pluggable table storage backends, starting with Cassandra. Other backends will scale this down for small installations.

The medium-term goal is to store all revisions as HTML, so that views and HTML-based saves can become storage-bound operations with low double-digit ms latencies. This will mostly eliminate the remaining 2-4% of cache misses, and should get us closer to actual DC fail-over without completely cold caches.

There is still a large amount of work to be done until all the puzzle pieces for this are in place, but we are hard at work to make it a reality. A major one, the bidirectional conversion between wikitext and HTML in Parsoid (https://www.mediawiki.org/wiki/Parsoid), is already powering VisualEditor and a bunch of other projects (https://www.mediawiki.org/wiki/Parsoid/Users). Watch this space ;)

Re:How we made editing Wikipedia twice as fast by tracker1 on Monday January 05, 2015 @07:23PM (#8842201)
Thanks for letting me know... I had some exposure to C* while at GoDaddy, and it would seem to be a great fit for what you are talking about...

GD is using it to store user-generated content, and it works very well, most responses (lookup and processing) were sub 20ms consistently under heavy load... (I'm hoping they write a DNS service that does similar).

Re:How we made editing Wikipedia twice as fast by duskwuff on Tuesday December 30, 2014 @06:18PM (#8817315)
They started with MySQL. Replacing that with MariaDB is a whole lot simpler (not to mention, less risky!) than replacing it with something completely different like Cassandra.
Re:How we made editing Wikipedia twice as fast by rimantas on Wednesday December 31, 2014 @07:03AM (#8819043)
They started with PostgreSQL iirc, only later migrated to MySQL.
Re:How we made editing Wikipedia twice as fast by samspenc on Tuesday December 30, 2014 @06:23PM (#8817336)
MariaDB is MySQL compatible. Had they gone with Cassandra, they would have had to replace the PHP-based MediaWiki software with something else. So not only the database, the entire software stack would have to be replaced as well.

Also, speaking from a few years' personal experience with HBase / Cassandra, the support for non-Java languages on these two NoSQL databases is small (though it is getting better.)

Re:How we made editing Wikipedia twice as fast by tracker1 on Monday January 05, 2015 @07:27PM (#8842223)
I worked on a project that used C* with node.js and it worked out very well... cluster of node servers, with minimal processing over a cluster of C* servers... very fast response times under some really big load.

Though node.js tends to be very flexible in terms of wrapping a friendlier interface around a less friendly one.

Re:How we made editing Wikipedia twice as fast by driverdan on Tuesday December 30, 2014 @07:46PM (#8817709)
Why? The vast majority of the requests they serve are cached at multiple layers above the DB. Switching to an entirely different DB would require rewriting a lot of code, a much larger learning curve to contribute (MediaWiki is FOSS), and limit its use to large sites (MediaWiki is widely used by small sites).
Re:How we made editing Wikipedia twice as fast by tracker1 on Monday January 05, 2015 @07:28PM (#8842229)
I'm not familiar enough with their data structure to comment, but the concern would seem to be around write performance... if they have to use sharding in an rdbms like my/mariadb, then it's not too much harder to change databases at that point.. not to mention improvements with distributed reads on a cache miss..
Re:How we made editing Wikipedia twice as fast by gpvos on Wednesday December 31, 2014 @06:23AM (#8818958)
NoSQL databases were still in their infancy when Wikipedia was originally developed.
Re:How we made editing Wikipedia twice as fast by tracker1 on Monday January 05, 2015 @07:29PM (#8842234)
I understand that... but would have assumed they would have changed over time. Plenty of platforms have migrated backends to handle much larger load (twitter, facebook, etc, etc).
Re:How we made editing Wikipedia twice as fast by gpvos on Sunday January 11, 2015 @11:44AM (#8870386)
Wikimedia's resources are over two orders of magnitude smaller than those of the other top-10 web sites. It is only fairly recently that they have more than a handful paid developers. And they have a huge amount of data they would have to convert. In fact, I think they would have been up to it, but there simply were more pressing concerns.