MySQL Forums
Forum List  »  Announcements

MySQL Utilities 1.6.0 Alpha has been released
Posted by: Balasubramanian Kandasamy
Date: September 26, 2014 11:06AM

 

Dear MySQL users,

This is the Alpha release for Utilities 1.6. MySQL Utilities version 1.6.0
is compatible with MySQL Server versions 5.5 and greater. Python
v2.6 and v2.7 are supported.

In addition to server utilities, MySQL Utilities also contains MySQL
Fabric: a framework for managing a collection of MySQL servers. MySQL
Fabric is deployed as a separate service daemon that contains support
for high-availability and sharding. MySQL Utilities and Fabric require
Connector/Python 2.0.0 or higher.

The management framework maintains a database of the routing and state
information for the servers making up the system and provides an
easy-to-use command line interface for adding, removing and organizing
servers.

High-availability is provided by continuously monitoring the servers and
executing slave promotion when the master crashes and just as
importantly automatically updates the state and routing information that
gets messages to the right server.

MySQL Fabric comes with built-in support for sharding either using
ranges or consistent hashing and supports the sharding of multiple
tables to ensure that rows with matching sharding keys are stored in the
same shard. MySQL Fabric also contains support for global tables that
are duplicated on all shards as well as the ability to synchronize
schema updates across all of the servers.

To provide high performance and avoid latency, transactions are directly
routed by Fabric-aware connectors rather than routing via an external
proxy. The connectors dispatch transactions to the correct shard,
perform load-balancing, and handle read-write splitting. Currently there
exists Fabric-aware versions of Connector/Python, Connector/Java, and
Connector/PHP (through a Fabric-aware mysqlnd_ms plugin).

MySQL Utilities v1.6.0 alpha is available for download from

http://dev.mysql.com/downloads/tools/utilities/

A brief summary of changes is listed below. Please check the CHANGES.txt
file inside the distribution for a more complete list of changes.

Changes in MySQL Utilities 1.6.0 (2014-09-26, Alpha)

   Functionality Added or Changed

     * The mysqlprocgrep utility now displays the processes and
       connections killed during a --kill operation. The displayed rows
       come from the appropriate SHOW PROCESSLIST entries. (Bug
       #14163181)

     * The mysqlbinlogmove utility was added. It relocates binary log
       files, and moves files based on their sequence number or modified
       date.

     * The mysqlgrants utility was added. It displays grants per
       object, and produces reports by user, user with grants, and GRANT
       statement.

   Bugs Fixed

     * Health reports can now be generated for a list of slaves
       without a master specified. In this case, "No master specified"
       appears for connection status for each slave, instead of an
       error. (Bug #18543913)

Documentation
-------------
Online: http://dev.mysql.com/doc/index-utils-fabric.html

The source distribution includes the manual pages for each utility under
the docs/ folder.

Reporting Bugs
--------------
We welcome and appreciate your feedback and bug reports:
http://bugs.mysql.com/

Enjoy!

On Behalf of the MySQL/ORACLE RE Team


Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Utilities 1.6.0 Alpha has been released
2494
September 26, 2014 11:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.