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

New Enhancements!

This release represents a stable release of the product. Along
with several defect patches, we also include the following
enhancements.

Improved support for MySQL 5.7 early releases
Improved output for mysqldbcompare
Improved SSL support

The MySQL Utilities Team is pleased to announce a new alpha
release of MySQL Utilities. This release includes a number of
improvements for useability, stability, and a few enhancements. A
complete list of all improvements can be found in our release
notes.

New Enhancements!

This release represents a stable release of the product. Along
with several defect patches, we also include the following
enhancements.

Improved support for MySQL 5.7 early releases
Improved output for mysqldbcompare
Improved SSL support

We are very happy to introduce a new MySQL utility named
"mysqlslavetrx", which allows users to easily skip
multiple transactions on multiple servers in a single step. This
utility is one of three new utilities included in MySQL Utilities
release-1.6.1 Alpha. The other utilities are
"mysqlbinlogpurge" and "mysqlbinlogrotate", which
can be used to purge and rotate binary logs.

The mysqlslavetrx utility allows you to skip multiple
transactions on several slaves. More precisely, it injects empty
transactions for the specified Global Transaction Identifier
(GTID) set and list of target slaves. Skipping transactions can
be …

We are very happy to introduce a new MySQL utility named
“mysqlslavetrx“, which allows users to easily
skip multiple transactions on multiple servers in a single step.
This utility is one of three new utilities included in MySQL
Utilities release-1.6.1 Alpha. The other utilities are
“mysqlbinlogpurge” and
“mysqlbinlogrotate“, which can be used to purge
and rotate binary logs.

The mysqlslavetrx utility allows you to skip multiple
transactions on several slaves. More precisely, it injects empty
transactions for the specified Global Transaction Identifier …

We are very happy to introduce a new MySQL utility named
'mysqlbinlogmove', which is used to relocate binary log files.
This utility is one of two new utilities included in MySQL
Utilities release-1.6.0 Alpha. The other utility is
'mysqlgrants', which is used to display the privileges (grants)
of database objects.

Note: I use "binary log" to refer to both "kinds" of binary log
files (binlog and relay log files) in general, and use "binlog"
to refer specifically to those that are not "relay log"
files.

The mysqlbinlogmove utility allows you to move binary log files
to a new location taking care of correctly updating …

We are very happy to introduce a new MySQL utility named
“mysqlbinlogmove“, which is used to relocate
binary log files. This utility is one of two new utilities
included in MySQL Utilities release-1.6.0 Alpha. The other
utility is “mysqlgrants“, which is used to
display the privileges (grants) of database objects.

Note: I use “binary log” to refer to both “kinds” of binary log
files (binlog and relay log files) in general, and use “binlog”
to refer specifically to those that are not “relay log” files.

The mysqlbinlogmove utility allows you to move binary log files
to a new location taking …

We are happy to announce mysqlgrants, a new
utility that allows users to display the privileges of grantees
over database objects. Together with
mysqlbinlogmove, these are the new utilities
included in MySQL Utilities release-1.6.0 Alpha.

Mysqlgrants allows you to know which users have access to a
specific object or list of objects. Furthermore, it can also show
the list of privileges that each user has over said object(s). In
short, mysqlgrants simplifies the task of monitoring grants in
MySQL helping you ensure users do not have more permissions than
necessary, thus keeping data more secure.

In the previous post of this series we saw how you
could use mysqlrpladmin to perform manual
failover/switchover when GTID replication is enabled in MySQL
5.6. Now we will review mysqlfailover (version 1.4.3),
another tool from the MySQL Utilities that can be used for
automatic failover.

MySQL Utilities are a set of tools provided by
Oracle to perform many kinds of administrative tasks. When
GTID-replication is enabled, 2 tools can be used for slave
promotion: mysqlrpladmin and mysqlfailover. We will review
mysqlrpladmin (version 1.4.3) in this post.

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.