Oracle has introduced MySQL Fabric, a system which makes the control and scaling of mySQL databases within business simpler.
The Redwood, California-based company said the open source framework, MySQL Fabric, delivers both high availability -- via failure detection and failover -- and scalability through automated data sharding, and has been introduced in order to meet the demands of today's cloud and Web applications.
Some of MySQL Fabric's features include:
- Monitoring of the master database; if the server fails, a slave database is selected and promoted to a new master;
- The automatic routing of transactions to the current master and load-balancing of queries across slave databases;
- Automated data sharding and re-sharding to make the lives of DevOp team easier.
- Users can 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, and move existing shards to new servers or split them into multiple shards.
- Extensions to PHP, Python, and Java connectors allow transactions and queries to be routed directly to the correct MySQL Server, eliminating extra latency caused when passing through a proxy.
"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."