没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
master1
ip:192.168.100.140
host:hanxin
slave1_1
ip:192.168.100.142
host:pengyue
slave1_2
ip:192.168.100.143
host:yingbu
master1
ip:192.168.100.141
host:xiaohe
slave2_1
ip:192.168.100.144
host:kuaitong
slave2_2
ip:192.168.100.145
host:zhonglimei
mysql版本:5.5.32
[root@hanxin ~]# vim /usr/my.cnf
[client]
port = 1869
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 1869
socket = /var/lib/mysql/mysql.sock
ip:192.168.100.140
host:hanxin
slave1_1
ip:192.168.100.142
host:pengyue
slave1_2
ip:192.168.100.143
host:yingbu
master1
ip:192.168.100.141
host:xiaohe
slave2_1
ip:192.168.100.144
host:kuaitong
slave2_2
ip:192.168.100.145
host:zhonglimei
mysql版本:5.5.32
[root@hanxin ~]# vim /usr/my.cnf
[client]
port = 1869
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 1869
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
log-bin=mysql-bin
binlog_format=mixed
binlog-do-db=php_db
binlog-ignore-db=mysql
log-slave-updates
replicate-do-db=php_db
replicate-ignore-db=mysql
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
log-bin=mysql-bin
binlog_format=mixed
binlog-do-db=php_db
binlog-ignore-db=mysql
log-slave-updates
replicate-do-db=php_db
replicate-ignore-db=mysql
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
剩余13页未读,继续阅读
资源评论
cailegbgong
- 粉丝: 0
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功