Feeds

Google swaps out MySQL, moves to MariaDB

'They're moving it all,' says MariaDB Foundation headman

Maximizing your infrastructure through virtualization

Updated Google is migrating its MySQL systems over to MariaDB, allowing the search company to get away from the Oracle-backed open source database.

The news came out at the Extremely Large Databases (XLDB) conference in Stanford, California on Wednesday, one month after El Reg reported that Google had assigned one of its engineers to the MariaDB Foundation. News of the swap was not an official announcement by Google, it came out during a presentation by Google senior systems engineer Jeremy Cole on the general state of the MySQL ecosystem.

It turns out that far from being a minor initiative to keep MariaDB alive, Google is actively patching and upgrading MariaDB 10.0 to be fit enough so that Google can migrate all of its thousand-plus MySQL instances onto the technology.

"Were running primarily on [MySQL] 5.1 which is a little outdated, and so we're moving to MariaDB 10.0 at the moment," Cole said in a presentation he gave on the general state of the MySQL ecosystem.

Google has been working with the MariaDB Foundation since the "beginning of the year" to help ease the migration, SkySQL chief executive Patrik Sallner, told The Register on Thursday. "They are moving many of their applications that have been previously working on MySQL off to MariaDB. We've also been collaborating with them to develop features in MariaDB to enable the migration. It's a great reference for us."

Cole said that the migration involves thousands of MySQL servers. We asked Google for more information, and the company sent us a statement which said: "Google's MySQL team is in the process of moving internal users of MySQL at Google from MySQL 5.1 to MariaDB 10.0. Google's MySQL team and the SkySQL MariaDB team are looking forward to working together to advance the reliability and feature set of MariaDB."

When we asked Sallner to quantify the scale of the migration he said, "They're moving it all. Everything they have. All of the MySQL servers are moving to MariaDB, as far as I understand."

By moving to MariaDB, Google can free itself of any dependence on technology dictated by Oracle – a company whose motivations are unclear, and whose track record for working with the wider technology community is dicey, to say the least. Oracle has controlled MySQL since its acquisition of Sun in 2010, and the key InnoDB storage engine since it got ahold of Innobase in 2005.

MariaDB is an open source database backed by Monty Widenius, who spearheaded the original development of MySQL. It is designed to replace Oracle-backed MySQL. Right now, Google has about five people working part-time on MariaDB bug fixes and patches, our sources tell us.

Google has been operating its own heavily modified version of MySQL since version 4.0, and the Chocolate Factory now runs on a custom MySQL 5.1 build, Cole said in his talk at XLDB. But now Google is moving to MariaDB 10.0. This version of MariaDB is roughly equivalent to MySQL 5.6, so a lot of Google's work has revolved around making sure that the changes that have occurred since 5.1 are well understood.

We asked Cole why Google would shift from MySQL to MariaDB, and what the key technical differences between the systems were. "From my perspective, they're more or less equivalent other than if you look at specific features and how they implement them," Cole said, speaking in a personal capacity and not on behalf of Google. "Ideologically there are lots of differences."

Google's widespread MariaDB push may be an attempt by the Chocolate Factory to shift developer allegiance from MySQL to MariaDB, and in doing so dilute Oracle's influence over the open source database ecosystem.

"I'd really love to see a single MySQL community, I think that's more or less impossible under Oracle, I don't know if that's possible under MariaDB," Cole said.

Though more attention has been paid to Google's flashier next-generation SQL systems such as Spanner and the back-to-the-future F1 database, Cole confirmed to El Reg that MySQL is running across "thousands of instances" at Google upon legions of flash-based servers. And it's on the move.

"It's been in different roles in different times," he said. "These days I think it's the best fit in very low-latency, multiple-geography applications, but ones where you don't necessarily need equal access for those geographies."

Google's MySQL also has the ability to "failover between multiple data centers and have read access in all data centers," he said.

This differs with Google's famed "Spanner" system, which allows for global access to data with strong consistency properties through the use of GPS-transceivers and atomic clocks to allow for writing globally without having to check locally.

"[Spanner is] able to provide more or less a global view of a dataset," Cole says. "They do failover much smaller. We're failing over an entire master, they're failing over one small shard of something that the customer didn't even know was sharding. The cost of operation is different."

Google is not alone in its shift to MariaDB: Red Hat is ditching MySQL for MariaDB in Red Hat Enterprise Linux 7.

Oracle had not responded to a request for comment at the time of writing. ®

Update

An earlier version of this story said that Patrik Sallner was leader of the MariaDB Foundation. This is not the case, though SkySQL is one of three corporate members of the Foundation, and is a specialist MariaDB company since its acquisition of Monty Widenius's company Mont Program AB earlier this year. The MariaDB Foundation's interim chief executive is Simon Phipps.

"We've known for some time that Google has been working in the community, we're delighted it's now public knowledge," Phipps tells us.

We have also clarified that Mr. Cole was speaking in a personal capacity and not on behalf of Google when discussing potential reasons for the shift.

The Power of One eBook: Top reasons to choose HP BladeSystem

More from The Register

next story
Sysadmin Day 2014: Quick, there's still time to get the beers in
He walked over the broken glass, killed the thugs... and er... reconnected the cables*
Auntie remains MYSTIFIED by that weekend BBC iPlayer and website outage
Still doing 'forensics' on the caching layer – Beeb digi wonk
SHOCK and AWS: The fall of Amazon's deflationary cloud
Just as Jeff Bezos did to books and CDs, Amazon's rivals are now doing to it
BlackBerry: Toss the server, mate... BES is in the CLOUD now
BlackBerry Enterprise Services takes aim at SMEs - but there's a catch
The triumph of VVOL: Everyone's jumping into bed with VMware
'Bandwagon'? Yes, we're on it and so what, say big dogs
Carbon tax repeal won't see data centre operators cut prices
Rackspace says electricity isn't a major cost, Equinix promises 'no levy'
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
Application security programs and practises
Follow a few strategies and your organization can gain the full benefits of open source and the cloud without compromising the security of your applications.
How modern custom applications can spur business growth
Learn how to create, deploy and manage custom applications without consuming or expanding the need for scarce, expensive IT resources.
Securing Web Applications Made Simple and Scalable
Learn how automated security testing can provide a simple and scalable way to protect your web applications.