您好,登錄后才能下訂單哦!
如果在生產環(huán)境中可能有一個主服務器,也是讀寫服務器,并可能會有多個從服務器,但這個主服務器會隨之從服務器的增加而變的性能下降,所以最好主服務器只有一個從,其它的從服務器再從這人從服務器進行復制,減少主服務器的壓力,這樣中間服務器專做復制從而最小化影響主服務器的性能
[root@centos7 ~]#yum install mariadb-server
[root@centos7 ~]#mkdir /data/{mysql,logs}
[root@centos7 ~]#chown mysql:mysql /data/{mysql,logs}
[root@master ~]#vi /etc/my.cnf
[mysqld]
log-bin=/data/logs/bin
datadir=/data/mysql
server-id=17
[root@master ~]#systemctl start mariadb
[root@master ~]#mysql < hellodb_innodb.sql
MariaDB [(none)]> grant replication slave on *.* to repluser@'192.168.205.%' identified by 'centos';
[root@master ~]#mysqldump -A --single-transaction --master-data=1 > /data/all.sql
[root@master ~]#scp /data/all.sql 192.168.205.27:/data
[root@middle ~]#vi /etc/my.cnf
[mysqld]
datadir=/data/mysql
log-bin=/data/logs/bin
server-id=27
read-only
log_slave_updates
[root@middle ~]#vi /data/all.sql
CHANGE MASTER TO
MASTER_HOST='192.168.205.17',
MASTER_USER='repluser',
MASTER_PASSWORD='centos',
MASTER_PORT=3306,
MariaDB [(none)]> source /data/all.sql
MariaDB [(none)]> start slave;
MariaDB [(none)]> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.205.17
Master_User: repluser
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: bin.000003
Read_Master_Log_Pos: 7973
Relay_Log_File: mariadb-relay-bin.000004
Relay_Log_Pos: 604
Relay_Master_Log_File: bin.000003
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
[root@middle ~]#mysqldump -A --single-transaction --master-data=1 > /data/middle.sql
[root@middle ~]#scp /data/middle.sql 192.168.205.37:/data
[root@slave ~]#vi /etc/my.cnf
[mysqld]
datadir=/data/mysql
server-id=37
read_only
[root@slave ~]#vi /data/middle.sql
CHANGE MASTER TO
MASTER_HOST='192.168.205.27',
MASTER_USER='repluser',
MASTER_PASSWORD='centos',
MASTER_PORT=3306,
[root@slave ~]#mysql < /data/middle.sql
[root@slave ~]#systemctl start mariadb
MariaDB [(none)]> start salve;
MariaDB [(none)]> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.205.27
Master_User: repluser
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: bin.000005
Read_Master_Log_Pos: 326
Relay_Log_File: mariadb-relay-bin.000003
Relay_Log_Pos: 604
Relay_Master_Log_File: bin.000005
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
MariaDB [(none)]> create database zhaoli;
Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db1 |
| db2 |
| hellodb |
| mysql |
| performance_schema |
| test |
| zhaoli |
+--------------------+
8 rows in set (0.00 sec)
免責聲明:本站發(fā)布的內容(圖片、視頻和文字)以原創(chuàng)、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關證據(jù),一經查實,將立刻刪除涉嫌侵權內容。