Table of Contents
This chapter presents an brief overview of each of the available utilities. The utilities are grouped into sections based on the type of administrative function that they perform.
These utilities are designed to perform operations on binary log files.
Relocate binary log files
Move files based on their sequence number or modified date
Purge binary logs
Rotate binary logs
These utilities are those designed to work at the database-level. They include utilities that can used to manage databases on one or more servers.
Compare databases on two servers or the same server
Compare definitions and data
Generate a difference report
Generate SQL transformation statements
Copy databases between servers
Clone databases on the same server
Supports rename
Export metadata and/or data from one or more databases
Formats: SQL, CSV, TAB, Grid, Vertical
Import metadata and data from one or more files
Reads all formats from mysqldbexport
Compare object definitions
Generate a difference report
These utilities are those designed to perform general operations such as reporting and searching.
Show disk usage for databases
Generate reports in SQL, CSV, TAB, Grid, Vertical
Reads .frm
files, optionally in
byte-by-byte diagnostic mode
Generates CREATE
statements from
table definition data
Displays grants per object.
Produce reports by user, user with grants, and
GRANT
statements.
Read indexes for one or more tables
Check for redundant and duplicate indexes
Generate reports in SQL, CSV, TAB, Grid, Vertical
Search metadata
Regexp, database search
Generate SQL statement for search query
Search process information
Generate SQL statement for search
Kill processes that match query
Clone a user account, to the same or different server
Show user grants
Command line client for running MySQL Utilities
Allows a persistent connection to a MySQL Server
Tab completion for utility names and options
Allows calling the commands with shorter names, such as using "serverinfo" instead of mysqlserverinfo
These utilities are those designed to support replication and high availability operations for MySQL servers.
Provides automatic failover on a replication topology
Uses Global Transaction Identifiers (GTID, MySQL Server 5.6.5+)
Setup replication
Start from beginning, current, specific binlog, pos
Provides round-robin multi-source replication (a slave server continually cycles through multiple masters in order to store a consolidated data set)
Uses Global Transaction Identifiers (GTID, MySQL Server 5.6.9+)
Administers the replication topology
Allows recovery of the master
Commands include elect, failover, gtid, health, start, stop, and switchover
Check replication configuration
Tests binary logging on master
Show slaves attached to master
Can search recursively
Show the replication topology as a graph or list
Check data consistency between servers in a replicated setup
Uses Global Transaction Identifiers (GTID)
Requires MySQL Server 5.6.14 and higher
Skip multiple transaction on slaves
Uses Global Transaction Identifiers (GTID)
These utilities are used to perform server-wide operations.
Start a new instance of a running server
Show server information
Can search for running servers on a host
Access online or offline servers
These utilities are designed to be used with a specific commercial extension. In this case, these utilities require the Audit Log Plugin.
Monitor the audit log
Copy, rotate, and configure the audit log
Search the audit log
Output results to different formats