Linux centos5.6版本下mysql5.6主从环境安装配置方法

这篇文章主要讲解了"Linux centos5.6版本下mysql5.6主从环境安装配置方法"，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习"Linux centos5.6版本下mysql5.6主从环境安装配置方法"吧！

服务器配置，具体iP，主从库如下

主库 IP：192.168.1.189 master server从库 IP：192.168.1.188 slave server

服务器系统为:centos5.6，下载安装软件包具体包括如下

MySQL-client-5.6.13-1.linux_glibc2.5.x86_64.rpmMySQL-devel-5.6.13-1.linux_glibc2.5.x86_64.rpmMySQL-server-5.6.13-1.linux_glibc2.5.x86_64.rpmMySQL-shared-5.6.13-1.linux_glibc2.5.x86_64.rpmMySQL-shared-compat-5.6.13-1.linux_glibc2.5.x86_64.rpmMySQL-test-5.6.13-1.linux_glibc2.5.x86_64.rpm

一、安装mysql，通过yum命令，安装所有所需rpm文件

yum -y install libaio libaio-devel perl-Time-HiRes curl curl-devel zlib-devel openssl-devel perl cpio expat-devel gettext-devel perl-ExtUtils-MakeMaker perl-DBD-MySQLrpm -ivh MySQL-test-5.6.13-1.linux_glibc2.5.x86_64.rpmrpm -ivh MySQL-shared-5.6.13-1.linux_glibc2.5.x86_64.rpm  rpm -ivh MySQL-shared-compat-5.6.13-1.linux_glibc2.5.x86_64.rpm rpm -ivh MySQL-server-5.6.13-1.linux_glibc2.5.x86_64.rpm rpm -ivh MySQL-devel-5.6.13-1.linux_glibc2.5.x86_64.rpm rpm -ivh MySQL-client-5.6.13-1.linux_glibc2.5.x86_64.rpm

二、修改master和slave配置，注意部分参数要根据实际情况来调整，具体步骤如下

主库/etc/my.cnf配置:

[client]port = 3306socket = /state/partition1/mysql/mysql.sockdefault-character-set=utf8[mysqld]server-id=1025log-bin=mysql-master-binbinlog_format = mixedexpire_logs_days=15max_connections=1000innodb_flush_log_at_trx_commit=1sync_binlog=1binlog-do-db=denovo_ngbinlog-ignore-db=mysql,test,information_schemainnodb_buffer_pool_size = 46673Mskip-name-resolvedatadir = /state/partition1/mysql/dataport = 3306socket = /state/partition1/mysql/mysql.sockkey_buffer_size=16Mmax_allowed_packet=16Mjoin_buffer_size = 512Msort_buffer_size = 256Mread_rnd_buffer_size = 128M innodb_buffer_pool_size = 40960Msql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

从库/etc/my.cnf配置，具体代码如下

[client]port = 3306socket = /state/partition1/mysql/mysql.sock[mysqld]server-id=1052datadir = /state/partition1/mysql/dataport = 3306socket = /state/partition1/mysql/mysql.sockuser=mysqllog-bin=mysql-slave-binmax_binlog_size=1000Mbinlog_format = mixedexpire_logs_days=7innodb_flush_log_at_trx_commit=1sync_binlog=1read_only=1binlog-do-db=denovo_ngbinlog-ignore-db=mysql,test,information_schemainnodb_buffer_pool_size = 36673Mskip-name-resolvemax_connections=1000max_user_connections=490max_connect_errors=2key_buffer_size=16Mmax_allowed_packet=16Mjoin_buffer_size = 512Msort_buffer_size = 256Mread_rnd_buffer_size = 128M innodb_buffer_pool_size = 40960Msql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

三、进行主从库账号授权操作：

主库

grant replication slave on *.* to 'jpsync'@'192.168.1.189' identified by 'jppasswd';flush privileges;show master status; #查看主库信息

从库

stop slave;change master to master_host='192.168.1.188',master_port=3306,master_user='jpsync',master_password='jppasswd', master_log_file='mysql-master-bin.000003',master_log_pos=408;  start slave；show slave status\G;

如果出现

Slave_IO_Running: YesSlave_SQL_Running: Yes

表明mysql主从库成功。

感谢各位的阅读，以上就是"Linux centos5.6版本下mysql5.6主从环境安装配置方法"的内容了，经过本文的学习后，相信大家对Linux centos5.6版本下mysql5.6主从环境安装配置方法这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是，小编将为大家推送更多相关知识点的文章，欢迎关注！