Quickly Set Up MySQL Master‑Slave Replication with mysqlreplicate

MySQL Utilities is a toolbox of handy MySQL tools. One of the most useful commands is mysqlreplicate, which can configure a master‑slave replication environment with a single command.

Usage

mysqlreplicate \
  --master=root:[email protected]:3306 \
  --slave=root:[email protected]:3306 \
  --rpl-user=replutil:111111

--master specifies the master server connection, --slave specifies the slave server, and --rpl-user provides the replication user that must already exist on the master.

First, create the replication user on the master, for example:

grant ALL PRIVILEGES on *.* to replutil@"192.168.31.101" identified by "111111";

Note: the slave IP must be explicit; do not use ‘%’.

Only two steps are needed: (1) create the replication user on the master, and (2) run the mysqlreplicate command. The setup completes in a few seconds.

MySQL Utilities includes many other tools, such as mysqldiskusage to view database space usage:

mysqldiskusage --server=root:111111@localhost

Another useful command is mysqlindexcheck to detect redundant indexes:

mysqlindexcheck --server=root@localhost employees

Installation

Download and extract MySQL Utilities, then run:

python ./setup.py build
python ./setup.py install

After installation, the utility commands are ready to use.

Download and Documentation

Download: http://dev.mysql.com/downloads/utilities/1.5.html

Documentation: http://dev.mysql.com/doc/mysql-utilities/1.6/en/utils-overview.html