MySQL Fabric Enables Automatic Failover and Data Sharding for Web and Cloud Applications

Bookmark and Share

Oracle has announced the general availability of MySQL Fabric, an open source framework to manage farms of MySQL servers. Available for download, the integrated and extensible system delivers both high availability - via failure detection and failover - and scalability through automated data sharding for MySQL applications. 

Automatic Failure Detection and Failover

MySQL Fabric enables automatic failure detection and failover when used with MySQL Replication for high availability, including monitoring of the master database so that if the server fails, MySQL Fabric selects one of the slave databases and promotes it to be the new master;  and automatic routing of transactions to the current master and load-balancing of queries across slave databases.

Data Sharding

In addition, automated data sharding and re-sharding make it easier for development and operations, or DevOps, teams to manage the process. This enables users to allow tables to be sharded for scale-out of both reads and writes; select which tables should be sharded and specify the columns to be used as sharding keys, including whether to use a HASH or RANGE based mapping; as well as move existing shards to new servers or split them into multiple shards.

"Many of the world’s largest websites and cloud-based applications rely on MySQL replication and sharding to deliver high availability and scalability,” said Tomas Ulin, vice president, MySQL Engineering, Oracle. “MySQL Fabric makes high availability with automatic failure detection and failover, as well as automated data sharding, accessible to all. With this integrated and open source framework, Oracle makes it easier to safely scale out MySQL applications, either on premises or in the cloud.”

More information is available about MySQL Fabric.

MySQL Fabric is part of the MySQL Utilities 1.4.3 package that can be downloaded here