Oracle Expands Open-Source High-Availability with MySQL Database Fabric

Tuesday May 27th 2014 by Sean Michael Kerner

MySQL Fabric is a new open-source tool included in MySQL Utilities 1.4

Oracle is aiming to make it easier for open source users of its MySQL database to scale.

Oracle announced today the new MySQL Fabric technology as an open source tool that is available in the MySQL Utilities 1.4 release.

"If you want to build a high-availability MySQL database, you typically have to set up replication, manage the failover and write some scripts to manage the failover," Tomas Ulin, vice president of MySQL Engineering, explained to Database Journal. "MySQL Fabric hides most of that and will manage the high availability for you."

Ulin said the MySQL Fabric connector has knowledge about the systems that are deployed in an organization and provides an 'out-of-the-box' high availability solution for MySQL database users.

Oracle has a number of other MySQL technologies in the market, including MySQL Cluster, that provide varying degrees of high-availability.

"MySQL Cluster has different options for high availability, including synchronous replication," Ulin said. "For disaster recovery, you typically have asynchronous replication with another data center."

Ulin noted that even with MySQL Cluster or even just a MySQL master/slave setup, database administrators still need to figure out how to address individual servers.

"MySQL Fabric does that for you," Ulin said. "We've built capabilities into the connectors to actually get information on which servers are active."

At this point, MySQL Fabric is a command line interface, that is Python based and available in open-source. Currently the system doesn't directly interface with the Memcached caching layer, though Ulin said that is something that could land on a future roadmap.

MySQL Fabric is available as part of the MySQL Utilities 1.4 release, which provides utilities for managing and cloning MySQL databases.

"Fabric is another utility in the utility toolbox that we have already," Ulin said.

Sean Michael Kerner is a senior editor at DatabaseJournal and InternetNews.com. Follow him on Twitter @TechJournalist

Mobile Site | Full Site