使用mysqlreplicate快速搭建MySQL主从

Part1:安装mysql-utilities

[root@HE1 ~]# tar xvf mysql-utilities-1.5.4.tar.gz

[root@HE1 ~]# cd mysql-utilities-1.5.4

[root@HE1 mysql-utilities-1.5.4]# Python setup.py build

[root@HE1 mysql-utilities-1.5.4]# python setup.py install

如何安装MySQL可参考

MySQL5.6生产库自动化安装部署 

Linux下MySQL5.7安装部署详细教程

Part2:基本使用方式

[root@HE1 ~]# mysqlreplicate --help

MySQL Utilities mysqlreplicate version 1.5.4

License type: GPLv2

Usage: mysqlreplicate --master=root@localhost:3306 --slave=root@localhost:3310 --rpl-user=rpl:passwd

mysqlreplicate - establish replication with a master

Options:

--version            show program's version number and exit

--help                display a help message and exit

--license            display program's license and exit

--master=MASTER      connection information for master server in the form:

<user>[:<password>]@<host>[:<port>][:<socket>] or

<login-path>[:<port>][:<socket>] or <config-

path>[<[group]>].

--slave=SLAVE        connection information for slave server in the form:

<user>[:<password>]@<host>[:<port>][:<socket>] or

<login-path>[:<port>][:<socket>] or <config-

path>[<[group]>].

--rpl-user=RPL_USER  the user and password for the replication user

requirement, in the form: <user>[:<password>] or

<login-path>. E.g. rpl:passwd

-p, --pedantic        fail if storage engines differ among master and slave.

--test-db=TEST_DB    database name to use in testing replication setup

(optional)

--master-log-file=MASTER_LOG_FILE

use this master log file to initiate the slave.

--master-log-pos=MASTER_LOG_POS

use this position in the master log file to initiate

the slave.

-b, --start-from-beginning

start replication from the first event recorded in the

binary logging of the master. Not valid with --master-

log-file or --master-log-pos.

--ssl-ca=SSL_CA      The path to a file that contains a list of trusted SSL

CAs.

--ssl-cert=SSL_CERT  The name of the SSL certificate file to use for

establishing a secure connection.

--ssl-key=SSL_KEY    The name of the SSL key file to use for establishing a

secure connection.

--ssl=SSL            Specifies if the server connection requires use of

SSL. If an encrypted connection cannot be established,

the connection attempt fails. By default 0 (SSL not

required).

-v, --verbose        control how much information is displayed. e.g., -v =

verbose, -vv = more verbose, -vvv = debug

-q, --quiet          turn off all messages for quiet execution.

Part3:主库准备

主库创建复制用户 

[root@HE3 ~]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 23329

Server version: 5.7.16-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> grant replication client,replication slave on *.* to 'mysync'@'%' identified by 'MANAGER';

Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)

Part4:一键配置

从库进行配置主从执行如下命令

[root@HE1 ~]# mysqlreplicate --master=sys_admin:MANAGER@192.168.1.250:3306 --slave=sys_admin:MANAGER@192.168.1.248:3306 --rpl-user=mysync:MANAGER -b

WARNING: Using a password on the command line interface can be insecure.

# master on 192.168.1.250: ... connected.

# slave on 192.168.1.248: ... connected.

# Checking for binary logging on master...

# Setting up replication...

# ...done.

检查

Part1:mysqlrplcheck检查

[root@HE1 ~]# mysqlrplcheck --master=sys_admin:MANAGER@192.168.1.250:3306 --slave=sys_admin:MANAGER@192.168.1.248:3306 -s

WARNING: Using a password on the command line interface can be insecure.

# master on 192.168.1.250: ... connected.

# slave on 192.168.1.248: ... connected.

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/a6bdf5fa269d0af6b64aaf1c5c2bb8d1.html