MySQL Utilities Management Tool

1, Mysqlrplsync tools.

A tool used to check the data consistency of master-slave replication.

Mysqlrplsync --Master=Check:pass@192.168.152.157:3310 --slaves=check:pass@192.168.152.159:< Span class= "CRAYON-CN" >3311,check:pass@192.168.152.160:< Span class= "CRAYON-CN" >3312

< Span class= "Crayon-sy" > < Span class= "crayon-v" > 2, Mysqlfailover tool.

< Span class= "Crayon-sy" > < Span class= "crayon-v" >

< Span class= "Crayon-sy" > < Span class= "crayon-v" >mysqlfailover--master=failover:[email  protected] ' 192.168.1.100 ': 13306--discover-slaves-login=failover:123456

3. mysqlrpladmin tools.

A MySQL total management tool, also a replication management tool.

Functions are similar to Mysqlfailover, and are tools that provide replication status detection and high availability.

4, Mysqlslavetrx tools.

A tool used to skip replication errors.

Mysqlslavetrx --gtid-set=af6b22ee-7b0b-11e4-aa8d-606720440b68:7-9 --slaves=user:[email protected] : 3311,user:[email protected]:3312--dryrun

--gtid-set: The set of global transaction identifiers (Gtid) to skip.

--slaves: Connection information from the server. Lists multiple slave stations in a comma-separated list.

--dryrun: Executes the utility in dry run mode, showing the transactions skipped for each slave (GTID), but not effectively skipping them. This option can be used to verify that the correct transaction has been skipped.

--VERBOSE,-V: Set the amount of information to display. Use this option multiple times to increase the amount of information. For example, = -v verbose, -vv = more verbose, -vvv = Debug. Verbose mode.

5. mysqlbinlogpurge Tools.

Used to clear the binary log.

Clear all unused binary log files from the primary server, specifying the slave server to check:

Mysqlbinlogpurge --master=root:[email protected]:3310 --slaves=root:[email protected]:3311,root:[ Email protected]:3312,root:[email protected]:3313 -vv

Clear all unused binary log files before a specific binary log file:

< Span class= "token punctuation" >mysqlbinlogpurge --master=root:[ Email protected]:3310 --slaves=root:[email protected]:3311,root:[email protected]:3312,root:[email  protected]:3313 --binlog =mysql-bin.000027 -v

 

MySQL Utilities Management Tool