Shulou(Shulou.com)06/01 Report--

Let's learn how to configure the document under Mysql5.7 master-slave replication. I believe everyone will benefit a lot after reading it. The text is fine but not much. I hope Mysql5.7 master-slave replication how to configure the document. This short content is what you want.

The installation data is mysql5.7 community version yum installation, official website has download address

wget https://repo.mysql.com//mysql57-community-release-el7-10.noarch.rpm

Notes: Firewall, Command quotes.

Primary Cloud Virtual Machine

[root@localhost opt]# egrep -v "^$|#" /etc/my.cnf red part is added

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

symbolic-links=0

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

server-id=1

log-bin=mysql-bin

Login database

systemctl start mysqld.service

grep 'temporary password' /var/log/mysqld.log #View temporary password

mysql -uroot -p

Change root password

set global validate_password_policy=0; #Cancel complex password settings

alter user 'root'@'localhost' identified by '123';

Start creating users

GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.1.% ' IDENTIFIED BY 'admin123456';

View master logs

mysql>quit

mysql>SHOW MASTER STATUS;

+------------------+----------+--------------+------------------+-------------------+

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |

+------------------+----------+--------------+------------------+-------------------+

| mysql-bin.000001 | 154 | | | |

+------------------+----------+--------------+------------------+-------------------+

1 row in set (0.00 sec)

from the configuration

[root@localhost ~]# egrep -v "^$|#" /etc/my.cnf

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

symbolic-links=0

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

server-id=2

Login Database Version 5.7

CHANGE MASTER TO

MASTER_HOST='192.168.1.200',

MASTER_PORT=3306,

MASTER_USER='repl',

MASTER_PASSWORD='admin123456',

MASTER_LOG_FILE='mysql-bin. 000001', master configuration log

MASTER_LOG_POS=154; Master Configuration Log

start

start slave;

stop slave;

Check if the connection is successful. The red part must be yes.

mysql> show slave status \G

*************************** 1. row ***************************

Slave_IO_State: Waiting for master to send event

Master_Host: 192.168.1.200

Master_User: repl

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.000001

Read_Master_Log_Pos: 316

Relay_Log_File: localhost-relay-bin.000002

Relay_Log_Pos: 482

Relay_Master_Log_File: mysql-bin.000001

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno: 0

Last_Error:

Skip_Counter: 0

Exec_Master_Log_Pos: 316

Relay_Log_Space: 693

Until_Condition: None

Until_Log_File:

Until_Log_Pos: 0

Master_SSL_Allowed: No

Master_SSL_CA_File:

Master_SSL_CA_Path:

Master_SSL_Cert:

Master_SSL_Cipher:

Master_SSL_Key:

Seconds_Behind_Master: 0

Master_SSL_Verify_Server_Cert: No

Last_IO_Errno: 0

Last_IO_Error:

Last_SQL_Errno: 0

Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id: 200

Master_UUID: 706337e4-1ebb-11e7-a606-000c2987fd49

Master_Info_File: /var/lib/mysql/master.info

SQL_Delay: 0

SQL_Remaining_Delay: NULL

Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates

Master_Retry_Count: 86400

Master_Bind:

Last_IO_Error_Timestamp:

Last_SQL_Error_Timestamp:

Master_SSL_Crl:

Master_SSL_Crlpath:

Retrieved_Gtid_Set:

Executed_Gtid_Set:

Auto_Position: 0

Replicate_Rewrite_DB:

Channel_Name:

Master_TLS_Version:

1 row in set (0.00 sec)

After reading Mysql 5.7 master-slave copy how to configure the document this article, many readers will definitely want to know more related content, if you need more industry information, you can pay attention to our industry information column.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.