|NO.Z.00095|——————————|^^ 部署 ^^|——|Linux&MySQL集群.V03|——|一主多从|

一、mysql一主多从：主服务器配置

### --- 部署规划；在原来基础之上部署

~~~		centos6.x server1：20.20.20.21           // 主
~~~		centos6.x server2：20.20.20.22           // 从
~~~		centos6.x server3：20.20.20.23           // 从

### --- 环境准备：
~~~		centos6.x server1: 为主
~~~		把centos6.x server1 的从停掉

mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)

### --- 配置从服务器centos6.x server23

[root@server23 ~]# yum install -y mysql-server mysql
[root@server23 ~]# vim /etc/my.cnf 
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-bin=mysql-bin
server-id=23
#replicate-do-db=test
binlog-ignore-db=mysql
###binlog-ignore-db=information_schema
###auto-increment-increment=2
###auto-increment-offset=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

### --- 授权23为从服务器

[root@server23 ~]# service mysqld start

### --- 在21主服务器上授权

mysql> grant replication slave on *.* to slave@'20.20.20.23' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> show master status;
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000004 |      338 |              | mysql            |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

### --- 从服务器23接收授权

mysql> change master to master_user='slave',master_password='123456',master_host='20.20.20.21',master_log_file='mysql-bin.000004',master_log_pos=338;
Query OK, 0 rows affected (0.07 sec)

二、验证测试

### --- 在主服务器上创建a1数据库

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)

mysql> create database a111 ;
Query OK, 1 row affected (0.00 sec)

### --- 第一个22从服务器查看是否创建a111数据库

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| a111               |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.00 sec)

### --- 第二个23从服务器查看是否创建a111数据库

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| a111               |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.00 sec)

---

 

 

 

 

 

 

 

 

 

---

Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of life.It sinks, and I am ready to depart

                                                                                                                                                   ——W.S.Landor

---