Dear MySQL users,
MySQL Utilities version 1.4.4 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. 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 continually monitoring the servers and executing slave promotion when the master crashes. Just as importantly it automatically updates the state and routing information that gets messages to the right server. MySQL Fabric comes with built-in support for sharding using either 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.4.4 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.4.4 Bugs Fixed (2014-07-31) * The mysqlreplicate and mysqlrplms utilities would generate an exception when the optional --rpl-user was not passed in. (Bug #19178471) * The check for an errant transaction was not performed for mysqlrpladmin's switchover command, it only performed for the failover command. Both commands now check for errant transactions. The errant transaction check requires all servers in the topology to have GTID enabled, otherwise a warning is issued indicating that the check cannot be performed for the switchover command. (Bug #19076488, Bug #73110) * On OS X Mavericks, the testing suite (MUT) failed to kill mysqld processes as MUT could not identify the MySQL server ports. (Bug #18958536) * On Windows, the mysqlfabric utility searched for the fabric configuration file outside of the installation folder. The default configuration file location is C:\Program Files (x86)\MySQL\MySQL Utilities 1.4.4\etc\mysql\fabric.cfg. Additionally, the MySQL Utilities section in the Windows Start menu now contains a link to the fabric configuration file. (Bug #18904014) * In the mysqluc environment, pressing tab after typing a "q" would incorrectly suggest the term "qxit" instead of "quit". This now returns "quit", which is an alias for "exit". (Bug #18852960, Bug #72776) * On Linux, the backspace key was not functioning in the mysqluc environment, therefore the entered text could not be changed. (Bug #18852933, Bug #72777) * With fabric, the --daemonize parameter was not recognized when passed in with manage start. (Bug #18874603, Bug #72818) * With the --discover-slaves-login option, if there were connection or configuration problems with some of the slaves, then those slaves were skipped with only a generic error message being issued. This behavior did not change when also passing in --verbose. A simple warning about the connection/configuration problems is now generated during the discovery process, and it references including --verbose to see additional information. The --verbose option generates specific information for each slave, and includes their respective errors. (Bug #18815523, Bug #72706) * The minimum required Connector/Python version in the source code was defined as 1.0.9 instead of 1.2.1. (Bug #18777318, Bug #72664) * The Debian packages checked for a Connector/Python 1.0.9+ prerequisite instead of requiring Connector/Python 1.2.1+. (Bug #18838462) * Descriptive text for the --no-headers option was improved to clearly indicate which formats it supports. For example, it does not support the "vertical" format. (Bug #18790134, Bug #72659) * When running the mysqlserverinfo utility as root against an offline MySQL server, it failed to start a read-only instance of the server and emitted the fatal error "Please read "Security" section of the manual to find out how to run mysqld as root!". This occurred because the mysqld option "--user=root" was not passed in, which is mandatory when starting mysqld as root. The user_name that executes the utility is now detected and added as --user=user_name when starting the read-only MySQL server. Additionally, error checks were added that validate the --basedir and --datadir options to check for their existence and accessibility. (Bug #18790361, Bug #72658) * Failed MySQL server connection error messages now return the actual error returned from the failed connection, instead of a custom (and more generic) error. This new behavior is more standard with how other MySQL client applications behave. (Bug #18815545, Bug #72670) * The mysqluc utility would suddenly exit when a command was wrongly formatted, like when a closing quote was missing. This action now generates a warning instead of exiting from the console, which allows the command to be edited. (Bug #18730815, Bug #72569) * When cloning a user, the mysqluserclone utility did not check if the user of the destination server had the required privileges for a successful operation. (Bug #18768780, Bug #72655) * Error messages for the mysqluserclone utility were improved by making them more explicit in terms of what might be missing. (Bug #18730656, Bug #72572) * The mysqluserclone utility was throwing an unhandled exception when the --list option was used with incorrect login credentials. The error message is now emitted. (Bug #18768487, Bug #72656) * When passing in the --dump option to the mysqluserclone utility on a user with the hostname '%', the output (each grant) would be printed twice. (Bug #18730720, Bug #72570) * With fabric, sharding prune_shard operations would hang when performed on a very large number of records. (Bug #18669231, Bug #19177860, Bug #73238) * The default value was removed from the --rpl-user option for the mysqlreplicate and mysqlrplms utilities. Before, the default user/pass value was "rpl:rpl". (Bug #18603715) * A warning is now emitted whenever a password is entered into the command line. When testing, this warning can be disabled by setting self.mask_global to false. (Bug #18603598) * The mysqlfailover utility caused excessive CPU load when executed in the console without passing in --daemon. This high CPU usage was due to the process waiting for user input. (Bug #18379971, Bug #72002) Documentation ------------- Online:http://dev.mysql.com/doc/mysql-utilities/1.4/en/ 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, Santosh Pagare
