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

mysql5.6主从环境安装配置步骤详解

来源:www.zhiqinet.com|时间:2014-10-17 14:48:56

主从配置是现在服务器集群中一个重要的数据处理方式了,下文来介绍在mysql5.6中快速配置安装mysql5.6的主从配置了,希望能帮助到各位.

服务器配置:

10.1.1.231 master server

10.1.1.234 slave server

服务器系统为:centos5.6

软件包:

  1. MySQL-client-5.6.13-1.linux_glibc2.5.x86_64.rpm
  2. MySQL-devel-5.6.13-1.linux_glibc2.5.x86_64.rpm
  3. MySQL-server-5.6.13-1.linux_glibc2.5.x86_64.rpm
  4. MySQL-shared-5.6.13-1.linux_glibc2.5.x86_64.rpm
  5. MySQL-shared-compat-5.6.13-1.linux_glibc2.5.x86_64.rpm
  6. MySQL-test-5.6.13-1.linux_glibc2.5.x86_64.rpm

一、安装mysql

  1. yum-yinstalllibaiolibaio-develperl-Time-HiRescurlcurl-develzlib-developenssl-develperlcpioexpat-develgettext-develperl-ExtUtils-MakeMakerperl-DBD-MySQL 
  2. rpm-ivhMySQL-test-5.6.13-1.linux_glibc2.5.x86_64.rpmrpm-ivhMySQL-shared-5.6.13-1.linux_glibc2.5.x86_64.rpm
  3. rpm-ivhMySQL-shared-compat-5.6.13-1.linux_glibc2.5.x86_64.rpmrpm-ivhMySQL-server-5.6.13-1.linux_glibc2.5.x86_64.rpm
  4. rpm-ivhMySQL-devel-5.6.13-1.linux_glibc2.5.x86_64.rpmrpm-ivhMySQL-client-5.6.13-1.linux_glibc2.5.x86_64.rpm

二、修改master和slave配置,部分参数要根据实际情况来调整,主库/etc/my.cnf配置:

  1. [client]port=3306
  2. socket=/state/partition1/mysql/mysql.sockdefault-character-set=utf8
  3. [mysqld]server-id=1025
  4. log-bin=mysql-master-binbinlog_format=mixed
  5. expire_logs_days=15max_connections=1000
  6. innodb_flush_log_at_trx_commit=1sync_binlog=1
  7. binlog-do-db=denovo_ngbinlog-ignore-db=mysql,test,information_schema
  8. innodb_buffer_pool_size=46673Mskip-name-resolve
  9. datadir=/state/partition1/mysql/dataport=3306
  10. socket=/state/partition1/mysql/mysql.sockkey_buffer_size=16M
  11. max_allowed_packet=16Mjoin_buffer_size=512M
  12. sort_buffer_size=256Mread_rnd_buffer_size=128M
  13. innodb_buffer_pool_size=40960Msql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

从库/etc/my.cnf配置:

  1. [client]port=3306
  2. socket=/state/partition1/mysql/mysql.sock[mysqld]
  3. server-id=1052datadir=/state/partition1/mysql/data
  4. port=3306socket=/state/partition1/mysql/mysql.sock
  5. user=mysqllog-bin=mysql-slave-bin
  6. max_binlog_size=1000Mbinlog_format=mixed
  7. expire_logs_days=7innodb_flush_log_at_trx_commit=1
  8. sync_binlog=1read_only=1
  9. binlog-do-db=denovo_ngbinlog-ignore-db=mysql,test,information_schema
  10. innodb_buffer_pool_size=36673Mskip-name-resolve
  11. max_connections=1000max_user_connections=490
  12. max_connect_errors=2key_buffer_size=16M
  13. max_allowed_packet=16Mjoin_buffer_size=512M
  14. sort_buffer_size=256Mread_rnd_buffer_size=128M
  15. innodb_buffer_pool_size=40960M--phpfensi.comsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

三、进行主从库账号授权:

主库:grant replication slave on *.* to 'jpsync'@'10.1.1.234' identified by 'jppasswd';

flush privileges;

show master status; #查看主库信息

从库:

  1. stopslave;changemastertomaster_host='10.1.1.231',master_port=3306,master_user='jpsync',master_password='jppasswd',master_log_file='mysql-master-bin.000003',master_log_pos=408;
  2. startslave;showslavestatusG;

如果出现:

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

表明mysql主从库成功.

栏目最新

相关文章

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

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