Oracle weaves Fabric for MySQL clustering
MySQL Fabric offers high availibility and the ability to scale out across multiple servers
IDG News Service - Oracle has released a framework that allows multiple copies of the MySQL database to work in tandem, making it easier for organizations to easily run live backup databases and scale MySQL across multiple servers.
"The Fabric manages a farm of MySQL servers," said Tomas Ulin, Oracle vice president of MySQL engineering.
The open-source MySQL Fabric is part of the MySQL Utilities 1.4.3 package, released Tuesday.
MySQL is increasingly being used for high-traffic Web applications that many people now see as mission critical, which led Oracle to add MySQL Fabric to the package. "We're expecting the Web should always work, and this has implications of the back end," Ulin said.
In particular, the rise of NoSQL databases such as MongoDB and add-on MySQL products from companies such as Percona have heated up the competition in the Web database space, Ulin said. Work on MySQL Fabric came about, in part, to keep MySQL abreast of these developments.
MySQL Fabric can help solve two pressing problems within the enterprise: increasing the reliability of the database service, which Oracle calls high availability, and scaling a database beyond a single server, to improve performance of the database server.
For high availability, the user can elect to have one or more database servers act as a replicated backup to the main server. When the master database goes down, MySQL Fabric detects the outage and reroutes requests to the designated replicated database server, or servers. The application does not see the switch over.
MySQL Fabric can also stage the sharding of databases so they can be spread out across multiple database servers, a process Oracle calls scaling out. Sharding a database involves separating database tables into multiple parts, while keeping track of the data in all of these individual sections.
By sharding MySQL databases, an organization can manage databases that have grown too large for a single server to handle, either in terms of the amount of data being stored or the frequency in which such data is accessed. With MySQL Fabric, administrators can select the tables shard and specify the columns to be used as sharding keys.
Administrators can also move a shard from one server to another, which can be handy when the data grows beyond original hardware projections.
"All the way up to the connector, MySQL fabric will understand which shard the data is on, and make sure the queries actually get routed to the correct MySQL Server that has the shard you want to access," Ulin said.
Prior to the release of MySQL Fabric, administrators who needed these capabilities had to write the code by hand or buy third-party software to handle the aspects necessary to create a cluster of interlocking MySQL servers, Ulin said. MySQL Fabric offers a toolbox to make that job a lot easier.
- Federated Data Checks In Follow Westwood Vacations' journey from a downward slump of losing revenue quarter over quarter to a record-breaking year in just over 18 months.
- Aberdeen Group: Marketing Analytics for Manufacturing: Forging Customer Insights There are no recalls for poor marketing. Manufacturers need to get their customer intelligence and messaging right the first time. Learn how.
- Troubleshooting Common Issues in VoIP Learn more about Voice over Internet Protocol (VoIP), including common VoIP metrics used, best practices in VoIP management and tips and tricks for...
- IDG Research Survey: Are you Paying Too Much for Your NMS? Feel like you're paying too much for network monitoring? You're not alone. This survey brief summarizes findings from research recently fielded by IDG...
- Leveraging Flash Storage to Accelerate Oracle Real Application Clusters Join this webinar to understand the latest solid-state storage trends, the specific applications driving solid-state storage deployments and the benefits of deploying the...
- Tips to Simplify Database Administration and Development Make your job easier while getting the most from the leading productivity tool for database professionals. Learn tips from Dell Software's Oracle® ACE,... All Databases White Papers | Webcasts
Our new bimonthly Internet of Things newsletter helps you keep pace with the rapidly evolving technologies, trends and developments related to the IoT. Subscribe now and stay up to date!