The MySQL Fabric team is pleased to announce that a new version is now available on Labs. This labs release includes our latest developments to give you a taste of what we have been working on. In particular, it includes the following new features and improvements:

• Multi-node Fabric support is now available! This means that multiple fabric nodes can be started and any node can be contacted to perform operations. This allows Fabric itself to be fault-tolerant (no single point of failure) and distribute request across multiple Fabric nodes. For more information, see: Increasing MySQL Fabric Resilience to Failures: Meet the Multi-Node Fabric 
• Improved security password management, allowing password to not be passed in plain text in the command line or configuration files. …

Overview

Redundancy is key to providing resilience to failures, and in Fabric 1.6.2 (now available on MySQL Labs), we have introduced the possibility to start multiple MySQL Fabric instances that are kept consistent through a replicated state machine.

The state machine replication guarantees that all machines (i.e.…

The MySQL Fabric team is pleased to announce that a new version is now available on Labs. This labs release includes our latest developments to give you a taste of what we have been working on. In particular, it includes the following new features and improvements:

• Multi-node Fabric support is now available!

…

Last week we released MySQL Router into our Labs and we need to provide a few extra details on how to actually use it.

Requirements

• A modern OS which comes with a compiler supporting C++11. For example, Ubuntu 14.04 and later, Oracle Linux 7, OS X 10.10.

…

The MySQL team are busily working on improving ways to use MySQL in scalable highly available systems. As most of you are already aware, the MySQL Group Replication project is progressing at full speed. Indeed, we just got preview release 0.5 out, while Fabric 1.5.6 was just released and work is ongoing for the Fabric 1.6 release.…

The MySQL Fabric team is pleased to announce that a new (GA) release is now available. This release includes several improvements in terms of stability and usability (bug fixes and feature enhancements). In a nutshell:

• Two new types of users for backup and restore are now available allowing a better managements of the required privileges for each user type.

…

The MySQL Fabric team is pleased to announce that a new (GA) release is now available. This release includes several improvements in terms of stability and usability (bug fixes and feature enhancements). In a nutshell:

• Two new types of users for backup and restore are now available allowing a better managements of the required privileges for each user type. More information: http://dev.mysql.com/doc/mysql-utilities/1.5/en/fabric-create-user.html 
• An example script for pacemaker was added to the source packages to help provide an HA solution using a single Fabric node. More information: http://dev.mysql.com/doc/mysql-utilities/1.5/en/fabric-pacemaker.html
• The Connector/Python minimum …

The MySQL Utilities Team is pleased to announce the latest general availability (GA) release of MySQL Utilities. This release includes a number of improvements for usability, stability, and a few enhancements. A complete list of all improvements can be found in our release notes.…

MySQL Fabric is a great tool for managing a farm of MySQL servers. In the last two posts you can see how High Availability Fail over and Sharding work. When things are working right, the group lookup_servers will look something like this:
server_uuid address status mode weight
------------------------------------ ----------- --------- ---------- ------
09d13be1-cdd0-11e4-8643-0800273b9c80 10.10.13.10 SECONDARY READ_ONLY 1.0
0f611996-cdd0-11e4-8643-0800273b9c80 10.10.13.20 SECONDARY READ_ONLY 1.0
11aae7e7-cdd0-11e4-8643-0800273b9c80 10.10.13.30 PRIMARY READ_WRITE 1.0

This is a three node farm with a PRIMARY for READ-WRITE operations and two …

Last time we set up a High Availability server farm with MySQL Fabric. Now it is time to set up sharding. I will be using the good old World database and sharding the City table on the ID field. There are 4,079 cities in this table and they will be split in two. So one shard, that we will call CityLow will have the records 2,000 and below and the other records at 2,001 and above will be called CityHigh. We also need a global group for setting up sharding that will be called CityGlobal.

Sadly, the first step is to remove the previous setup with mysqlfabric manage teardown. This will remove the fabric database from the Fabric controller. Fabric itself has to be stopped with mysqlfabric manage stop. The command mysqlfabric manage setup will set up a fresh, clean fabric database. And …