搭建MySQL高可用架构MHA
#cloud3 为master,cloud2为slave1,cloud3为slave2#yum 安装mysql
yum –y install mysql
#设置/etc/my.cnf
port = 3306
socket = /var/lib/mysql/mysql.sock
port = 3306
socket = /var/lib/mysql/mysql.sock
datadir = /data
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
skip-federated
log-bin=mysql-bin
server-id = 1 #master>
quick
max_allowed_packet = 16M
no-auto-rehash
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
interactive-timeout
#建立测试库dbtest
create database dbtest;
#建立测试表tb1
use dbtest;
CREATE TABLE `tb1` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(32) default NULL,
PRIMARY KEY(`id`)
);
#设置的复制权限帐号
GRANT REPLICATION SLAVE,REPLICATION CLIENT ON *.* TO 'rep'@'%'>
FLUSH PRIVILEGES;
#建立主从复制关系
reset master;
show master status;
change master to
master_host='192.168.100.14',
master_port=3306,
master_user='rep',
master_password='rep123',
master_log_file='mysql-bin.000001',
master_log_pos=98;
slave start;
show slave status\G;
show full processlists;
#在master插入数据查看binlog是否同步
insert into tb1(name) values ('123');
#建立mha使用的帐号并设置权限
grant all on *.* to mhauser@'cloud1'>
grant all on *.* to mhauser@'cloud2'>
grant all on *.* to mhauser@'cloud3'>
FLUSH PRIVILEGES;
页:
[1]