Linux下Mysql主从复制

系统：CentOS6.4 32位

Mysql：5.5版本

selinux关闭 防火墙关闭

setenfore <span style="color: #800080;">0</span><span style="color: #000000;">
setvice iptables stop</span>

Master：42.51.153.157

Slave：42.51.155.219

2.就是要确定服务器上的Mysql

<span style="color: #0000ff;">yum</span> <span style="color: #0000ff;">install</span> mysql mysql-server -y

3.确认时间同步

[root@master ~]# <span style="color: #0000ff;">yum</span> <span style="color: #0000ff;">install</span> ntp -<span style="color: #000000;">y
[root@master </span>~]# <span style="color: #0000ff;">vi</span> /etc/<span style="color: #000000;">ntp.conf    #添加以下2行
server </span><span style="color: #800080;">127.127</span>.<span style="color: #800080;">1.0</span><span style="color: #000000;">
fudge </span><span style="color: #800080;">127.127</span>.<span style="color: #800080;">1.0</span> stratum <span style="color: #800080;">8</span>

[root@master ~]# /etc/init.d/ntpd restart   #重启ntpd服务

2)在节点服务器上进行时间同步

[root@slave1 ~]# /etc/init.d/<span style="color: #000000;">iptables stop
[root@slave1 </span>~<span style="color: #000000;">]# chkconfig iptables off
[root@slave1 </span>~]# <span style="color: #0000ff;">yum</span> <span style="color: #0000ff;">install</span> -<span style="color: #000000;">y ntpdate
[root@slave1 </span>~]# /usr/sbin/ntpdate <span style="color: #800080;">42.51</span>.<span style="color: #800080;">153.157</span>

四：配置Mysql 

1.首先修改Mysql主配置的配置文件（Master）

[root@master ~]# \<span style="color: #0000ff;">cp</span> /etc/my.cnf /etc/<span style="color: #000000;">my.cnf.old        ##修改之前备份
[root@master </span>~]# <span style="color: #0000ff;">vi</span> /etc/<span style="color: #000000;">my.cnf                        ##修改
server</span>-<span style="color: #0000ff;">id</span>       = <span style="color: #800080;">11</span>                                     <span style="color: #008000;">//</span><span style="color: #008000;">修改</span>
<span style="color: #000000;">
log</span>-bin=master-bin                                         <span style="color: #008000;">//</span><span style="color: #008000;">修改</span>
<span style="color: #000000;">
         log</span>-slave-updates=<span style="color: #0000ff;">true</span>                                  <span style="color: #008000;">//</span><span style="color: #008000;">增加</span>
<span style="color: #000000;">
[root@master </span>~]# /etc/init.d/<span style="color: #000000;">mysqld restart           ##重启Mysql
[root@master </span>~]# mysql -u root –ppassword                  <span style="color: #008000;">//</span><span style="color: #008000;">登录数据库，给从服务器授权</span>
mysql> grant replication slave on *.* to <span style="color: #800000;">‘</span><span style="color: #800000;">yanghongfei</span><span style="color: #800000;">‘</span>@<span style="color: #800000;">‘</span><span style="color: #800000;">42.51.155.219</span><span style="color: #800000;">‘</span> identified by <span style="color: #800000;">‘</span><span style="color: #800000;">123456</span><span style="color: #800000;">‘</span><span style="color: #000000;">;
mysql</span>><span style="color: #000000;"> flush privileges;
mysql</span>><span style="color: #000000;"> show master status;                 ##这个日志后面会用的到
</span>+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.<span style="color: #800080;">000005</span> |      <span style="color: #800080;">343</span> |              |                  |
+------------------+----------+--------------+------------------+
<span style="color: #800080;">1</span> row <span style="color: #0000ff;">in</span> set (<span style="color: #800080;">0.00</span> sec)

2.配置从服务器  （Slave）

[root@salve shell]# <span style="color: #0000ff;">vi</span> /etc/<span style="color: #000000;">my.cnf 
server</span>-<span style="color: #0000ff;">id</span>       = <span style="color: #800080;">33</span>                                                        <span style="color: #008000;">//</span><span style="color: #008000;">修改     此处ID只要比Master大就可以</span>
<span style="color: #000000;">
relay</span>-log=relay-log-bin                                                     <span style="color: #008000;">//</span><span style="color: #008000;">增加</span>
<span style="color: #000000;">
relay</span>-log-index=slave-relay-bin.index                          <span style="color: #008000;">//</span><span style="color: #008000;">增加</span>
<span style="color: #000000;">
修改完成之后重启mysql服务
登录Mysql，配置同步
[root@salve shell]# service mysqld restart
[root@slave1 </span>~]# mysql -<span style="color: #000000;">u root –ppassword
mysql</span>><span style="color: #000000;"> stop slave;                                          ##首先停止
mysql</span>>  change master to master_host=<span style="color: #800000;">‘</span><span style="color: #800000;">42.51.153.157</span><span style="color: #800000;">‘</span>,master_user=<span style="color: #800000;">‘</span><span style="color: #800000;">yanghongfei</span><span style="color: #800000;">‘</span>,master_password=<span style="color: #800000;">‘</span><span style="color: #800000;">123456</span><span style="color: #800000;">‘</span>,master_log_file=<span style="color: #800000;">‘</span><span style="color: #800000;">mysql-bin.000005</span><span style="color: #800000;">‘</span>,master_log_pos=<span style="color: #800080;">343</span><span style="color: #000000;">;
mysql</span>><span style="color: #000000;"> start slave;
mysql</span>> show slave status \G;

查看是否成功~

上面2处都为Yes的时候表示已经成功了~~

3. 测试主从是否复制成功，主服务器创建数据库看是不是被同步过去了

Master：

Slave：

下面我来装一个Discuz论坛 我们来测试下数据表会不会被同步进去，这里安装网站不再详细说了 我这面用的环境是lnmp   首先下载一个Discuz的包 网上有很多

[root@master ~]# <span style="color: #0000ff;">unzip</span> Discuz_7.2_FULL_SC_UTF8.<span style="color: #0000ff;">zip</span><span style="color: #000000;">      
[root@master </span>~]# <span style="color: #0000ff;">mv</span> upload/ /usr/share/nginx/html/<span style="color: #000000;">
[root@master </span>~]# cd /usr/share/nginx/html/<span style="color: #000000;">
[root@master html]# </span><span style="color: #0000ff;">mv</span> upload/<span style="color: #000000;"> Discuz
[root@master html]# </span><span style="color: #0000ff;">chmod</span> <span style="color: #800080;">777</span> -R ./Discuz/<span style="color: #000000;">
[root@master </span>~]# service nginx restart

Master：

Slave：

上面可以看出主从复制成功~~

Linux下Mysql主从复制

标签：