Feeds

Google swaps out MySQL, moves to MariaDB

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

Gartner critical capabilities for enterprise endpoint backup

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.

Secure remote control for conventional and virtual desktops

More from The Register

next story
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Microsoft: Azure isn't ready for biz-critical apps … yet
Microsoft will move its own IT to the cloud to avoid $200m server bill
Oracle reveals 32-core, 10 BEEELLION-transistor SPARC M7
New chip scales to 1024 cores, 8192 threads 64 TB RAM, at speeds over 3.6GHz
US regulators OK sale of IBM's x86 server biz to Lenovo
Now all that remains is for gov't offices to ban the boxes
Flash could be CHEAPER than SAS DISK? Come off it, NetApp
Stats analysis reckons we'll hit that point in just three years
Object storage bods Exablox: RAID is dead, baby. RAID is dead
Bring your own disks to its object appliances
Nimble's latest mutants GORGE themselves on unlucky forerunners
Crossing Sandy Bridges without stopping for breath
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.
Top 10 endpoint backup mistakes
Avoid the ten endpoint backup mistakes to ensure that your critical corporate data is protected and end user productivity is improved.
Top 8 considerations to enable and simplify mobility
In this whitepaper learn how to successfully add mobile capabilities simply and cost effectively.
Rethinking backup and recovery in the modern data center
Combining intelligence, operational analytics, and automation to enable efficient, data-driven IT organizations using the HP ABR approach.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.