The technical details of Wikipedia’s migration from MySQL to MariaDB:
As a read-heavy site, Wikipedia aggressively uses edge caching.
Approximately 90% of pageviews are served entirely from the edge while at
the application layer, we utilize both memcached and redis in addition to
MySQL. Despite that, the MySQL databases serving English Wikipedia alone
reach a daily peak of ~50k queries/second. Most are read queries served by
load-balanced slaves, depending on consistency requirements. 80% of the
English Wikipedia query load (up to 40k qps) are typically handled by just
two database servers at any given time. Our most common query type (40% of
all) has a median execution time of ~0.2ms and a 95th percentile time of
~50ms. To successfully use MariaDB in production, we need it to keep up with
the level of performance obtained from Facebook’s MySQL fork, and to behave
consistently as traffic patterns change.
As you can see in this post, the only “political” point made is hidden within true reasons:
Equally important, as supporters of the free culture movement, the Wikimedia
Foundation strongly prefers free software projects; that includes a
preference for projects without bifurcated code bases between differently
licensed free and enterprise editions. We welcome and support the MariaDB
Foundation as a not-for-profit steward of the free and open MySQL related
Slightly different to Wikipedia Migrates to MariaDB.
Original title and link: Wikipedia Adopts MariaDB ( ©myNoSQL)