The process of msyql master-slave backup
This article mainly explains the "msyql master-slave backup process", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "msyql master-slave backup process"!
Installation environment:
Rhel6.5:server1 master
Rhel6.5:server2 slave
Install the database:
[root@server1 mysql] # yum install-y mysql-community-client-5.7.17-1.el6.x86_64.rpm mysql-community-common-5.7.17-1.el6.x86_64.rpm mysql-community-libs-5.7.17-1.el6.x86_64.rpm mysql-community-libs-compat-5.7.17-1.el6.x86_64.rpm mysql-community-server-5.7.17-1.el6.x86_64.rpm
[root@server1 ~] # vim / etc/my.cnf
Server-id = n assign a unique ID number to the server
[root@server1 ~] # / etc/init.d/mysqld start
Initialize MySQL database: [OK]
Installing validate password plugin: [OK]
Starting mysqld: [OK]
[root@server1 ~] # cd / var/lib/mysql
[root@server1 mysql] # cd / var/lib/mysql
[root@server1 mysql] # ls
Auto.cnf ibdata1 mysql-bin.000002 performance_schema
Ca-key.pem ib_logfile0 mysql-bin.000003 private_key.pem
Ca.pem ib_logfile1 mysql-bin.index public_key.pem
Client-cert.pem ibtmp1 mysqld_safe.pid server-cert.pem
Client-key.pem mysql mysql.sock server-key.pem
Ib_bufferpool mysql-bin.000001 mysql.sock.lock sys
[root@server1 mysql] # cat mysql-bin.000001
5.7.17-log [8
* * 4 / 4 / [root@server1 mysql] # ll mysql-bin.000001
-rw-r- 1 mysql mysql 177.28 14:40 mysql-bin.000001
Modify slave configuration file
Server-id = n assign a unique ID number to the server
[root@server1 mysql] # grep password / var/log/mysqld.log
View password
[root@server1 ~] # mysql_secure_installation
Initialization
Server2 ditto
Authorization on server1:
Mysql > grant replication slave on. To cara@'172.25.35.2' identified by 'Caonimei@478'
Query OK, 0 rows affected, 1 warning (0.02 sec)
Mysql > flush privileges; refresh
Query OK, 0 rows affected (0.02 sec)
After master authorization, slave can log in remotely
[root@server2] # mysql-ucara-p-h 172.25.35.1
Mysql > show databases
+-+
| | Database |
+-+
| | information_schema |
+-+
1 row in set (0.00 sec)
View the following on master:
Mysql > show master status
+-+
| | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | |
+-+
| | mysql-bin.000004 | 843 |
+-+
1 row in set (0.00 sec)
Establish a connection between slave and master to synchronize:
Mysql > change master to master_host='172.25.35.1',master_user='cara',master_password='Caonimei@478',master_log_file='mysql-bin.000004',master_log_pos=843
View the following on slave:
Mysql > show databases
->
+-+
| | Database |
+-+
| | information_schema |
| | mysql |
| | performance_schema |
| | sys |
+-+
Mysql > change master to master_host='172.25.35.1',master_user='cara',master_password='Caonimei@478',master_log_file='mysql-bin.000004',master_log_pos=843
[root@server2 mysql] # cd / var/lib/mysql
[root@server2 mysql] # cat master.info
25mysql-bin.000004
eight hundred and forty three
172.25.35.1
Cara
Caonimei@478
