Linux centos5.6版本下mysql5.6主从环境安装配置
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Linux centos5.6版本下mysql5.6主从环境安装配置,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3184字,纯文字阅读大概需要5分钟。
内容图文
![Linux centos5.6版本下mysql5.6主从环境安装配置](/upload/InfoBanner/zyjiaocheng/448/5daaa00dc78b401cab606d84a0593d28.jpg)
服务器配置,具体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.rpm MySQL-devel-5.6.13-1.linux_glibc2.5.x86_64.rpm MySQL-server-5.6.13-1.linux_glibc2.5.x86_64.rpm MySQL-shared-5.6.13-1.linux_glibc2.5.x86_64.rpm MySQL-shared-compat-5.6.13-1.linux_glibc2.5.x86_64.rpm MySQL-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-MySQL rpm -ivh MySQL-test-5.6.13-1.linux_glibc2.5.x86_64.rpm rpm -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 = 3306 socket = /state/partition1/mysql/mysql.sock default-character-set=utf8 [mysqld] server-id=1025 log-bin=mysql-master-bin binlog_format = mixed expire_logs_days=15 max_connections=1000 innodb_flush_log_at_trx_commit=1 sync_binlog=1 binlog-do-db=denovo_ng binlog-ignore-db=mysql,test,information_schema innodb_buffer_pool_size = 46673M skip-name-resolve datadir = /state/partition1/mysql/data port = 3306 socket = /state/partition1/mysql/mysql.sock key_buffer_size=16M max_allowed_packet=16M join_buffer_size = 512M sort_buffer_size = 256M read_rnd_buffer_size = 128M innodb_buffer_pool_size = 40960M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
从库/etc/my.cnf配置,具体代码如下
[client] port = 3306 socket = /state/partition1/mysql/mysql.sock [mysqld] server-id=1052 datadir = /state/partition1/mysql/data port = 3306 socket = /state/partition1/mysql/mysql.sock user=mysql log-bin=mysql-slave-bin max_binlog_size=1000M binlog_format = mixed expire_logs_days=7 innodb_flush_log_at_trx_commit=1 sync_binlog=1 read_only=1 binlog-do-db=denovo_ng binlog-ignore-db=mysql,test,information_schema innodb_buffer_pool_size = 36673M skip-name-resolve max_connections=1000 max_user_connections=490 max_connect_errors=2 key_buffer_size=16M max_allowed_packet=16M join_buffer_size = 512M sort_buffer_size = 256M read_rnd_buffer_size = 128M innodb_buffer_pool_size = 40960M sql_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: Yes Slave_SQL_Running: Yes
表明mysql主从库成功。
Linux centos5.6版本下mysql5.6主从环境安装配置
标签:
本文系统来源:http://my.oschina.net/freelife/blog/420074
内容总结
以上是互联网集市为您收集整理的Linux centos5.6版本下mysql5.6主从环境安装配置全部内容,希望文章能够帮你解决Linux centos5.6版本下mysql5.6主从环境安装配置所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。