当前位置:首页 > MySQL > MySQL基础

MySQL数据库在云主机上搭建主从配置

来源:www.zhiqinet.com|时间:2014-10-17 15:10:55

Mysql主从方案介绍mysql主从方案主要作用:读写分离,使数据库能支撑更大的并发了的同时也支付了数据安全性了,如果有数据丢失从服务器会是最新的备份数据了,这也是各大网站常用的一种数据实时备份的方法,下文来简单的介绍mysql主从配置吧。

1,已经事先购买了两台云主机

  1. 10.4.14.168 101.69.178.208[联通]Master
  2. 10.4.5.9 101.69.178.219[联通]Slave

2,分别安装MySQL,代码如下:

  1. #yuminstallmysql-server–enablerepo=remi
  2. #yuminstallmysql-devel

3,查看MySQL安装情况,代码如下:

  1. [root@10-4-14-168~]#rpm-qa|grepmysql*
  2. mysql-5.1.73-3.el6_5.x86_64mysql-libs-5.1.73-3.el6_5.x86_64
  3. mysql-server-5.1.73-3.el6_5.x86_64mysql-devel-5.1.73-3.el6_5.x86_64

4,启动MySQL,代码如下:

service mysqld start

5,登陆MySQL并且修改密码并且删除空用户,代码如下:

  1. mysql>UPDATEmysql.userSETpassword=PASSWORD('ge0513.mysql')->WHEREuser='root';
  2. QueryOK,3rowsaffected(0.00sec)Rowsmatched:3Changed:3Warnings:0
  3. mysql>SELECTuser,host,passwordFROMmysql.user;+------+-------------+-------------------------------------------+
  4. |user|host|password|+------+-------------+-------------------------------------------+
  5. |root|localhost|*7AE39BE5035D5C32361400FF7DEDD757AA76896A||root|10-4-14-168|*7AE39BE5035D5C32361400FF7DEDD757AA76896A|
  6. |root|127.0.0.1|*7AE39BE5035D5C32361400FF7DEDD757AA76896A|||localhost||
  7. ||10-4-14-168||+------+-------------+-------------------------------------------+
  8. 5rowsinset(0.00sec)mysql>DROPuser''@localhost;
  9. QueryOK,0rowsaffected(0.00sec)mysql>DROPuser''@'10-4-14-168';
  10. QueryOK,0rowsaffected(0.00sec)

6 需改配置文件,代码如下:

  1. bind-address=10.6.20.1port=3306
  2. character_set_server=utf8max_connect_errors=1000000
  3. max_connections=500datadir=/data/mysql
  4. log-error=/var/log/mysql/mysql-error.log-errorskip_name_resolve
  5. back_log=2000log-bin=/data/mysql
  6. binlog-format=MIXEDexpire_logs_days=2

7,主库上创建复制用户,代码如下:

GRANT REPLICATION SLAVE ON *.* TO gechong@10.4.14.168 IDENTIFIED BY 'gechong';

8,在主库上执行,代码如下:

  1. mysql>showmasterstatus;+---------------+----------+--------------+------------------+
  2. |File|Position|Binlog_Do_DB|Binlog_Ignore_DB|+---------------+----------+--------------+------------------+
  3. |binlog.000003|412|||+---------------+----------+--------------+------------------+
  4. 1rowinset(0.00sec)

9,在从库的配置文件中添加之后重启服务,代码如下:

  1. master-host=10.4.14.168master-user=gechong
  2. master-password=gechongbinlog-do-db=test

10,在从库上执行,代码如下:

  1. mysql>startslave;QueryOK,0rowsaffected,1warning(0.00sec)
  2. --phpfensi.com

11,尝试在主库上添加新表,看是否从库上也会出现.

栏目最新

相关文章

关于我们 - 广告合作 - 联系我们 - 免责声明 - 网站地图 - 投诉建议 - 在线投稿

严禁网站镜像,否则追究法律责任 CopyRight © 2014 智启教程 zhiqinet.com , All Rights Reserved.