5 ms·
Which database system Wikipedia is currently using?
by JackWebbHeller 14y ago
Which database system Wikipedia is currently using?
- AdamGibbins 14y agoMySQL
- tommorris 14y agoWell, MySQL plus a text store. MediaWiki, the open source software that Wikipedia uses, now officially supports MariaDB.
- neilk 14y agoWe're also using OpenStack Swift for media storage these days.
- mh- 14y agoI couldn't see a way to aggregate it in the ganglia linked.. could you share how many mysql (maria) queries per second you guys are averaging?
- neilk 14y agoI should clarify: I used to work there but I sometimes still say "we". I'm not a ganglia wizard - maybe this comes close? Although it's just all selects. I think. http://ganglia.wikimedia.org/latest/graph_all_periods.php?title=mysql_com_select+across+all+db*&vl=stmts&x=&n=&hreg%5B%5D=db&mreg%5B%5D=mysql_com_select>ype=stack&glegend=show&aggregate=1 http://ganglia.wikimedia.org/latest/graph_all_periods.php?ti... You might try asking on wikitech-l, the same mailing list that the original post comes from.
- whalesalad 14y agoI use MariaDB on my Mac for most things that require MySQL. It's a drop in replacement for most things. Is there a special edge case with media wiki they had to solve or is it now just formally announced as being supported?
- tommorris 14y agoSo, it's pretty much a drop-in replacement. But as with everything, time m ust be spent testing and so on before rolling it out to production. I believe a transition to MariaDB has been planned for a while now.
- malinens 14y agoI remember I had problems with insert statements when previously with mysql inserts without default values worked but MariaDB was strict in this case and these inserts failed...
- plasma 14y agoMariaDB is a fork of MySQL by Monty (original MySQL author)