mysql数据库作业_MySQL数据库作业ab abb abc

AB

master ip 192.168.34.1

slave1 ip 192.168.34.2

[master:]

vim /etc/my.cnf

[mysqld]

server_id = 1

log-bin=binlog

log-bin-index=binlog.index

save&exit

service mysqld restart

mysql>grant replication slave on *.* to 'shenmeh'@'192.168.34.2' identified by '123';

mysql>flush privileges;

mysql>show master status;

binlog.000001  808

[slave1:]

mysql -h 192.168.34.1 -u shenmeh -p123

登录成功mysql>

exit

vim /etc/my.cnf

server_id = 2 (一定要大于master的ID)

relay_log = /var/lib/mysql/mysql-relay-bin

relay_log_index=/var/lib/mysql/mysql-relay-bin.index

save&exit

rm -fr /var/lib/mysql/*

service mysqld restart

[master:]

mysqldump -A -x > /tmp/full.sql

scp /tmp/full.sql shenmeh@192.168.34.2:/tmp/

[slave1:]

mysql < /tmp/full.sql

mysql> change master to master_host='192.168.34.1', master_port=3306, master_user='shenmeh', master_password='123',master_log_file='binlog.000001',master_log_pos=808;

mysql> start slave;

mysql> show slave status \G

ABB

在AB的基础上

master ip 192.168.34.1

slave1 ip 192.168.34.2

slave2 ip 192.168.34.3

[master:]

mysql>grant replication slave on *.* to 'shenmeh'@'192.168.34.3' identified by '123';

mysql>flush privileges;

[slave2:]

mysql -h 192.168.34.1 -u shenmeh -p123

登录成功mysql>

exit

vim /etc/my.cnf

server_id = 3

relay_log = /var/lib/mysql/mysql-relay-bin

relay_log_index=/var/lib/mysql/mysql-relay-bin.index

save&exit

rm -fr /var/lib/mysql/*

[master:]

mysqldump -A -x > /tmp/full.sql

scp /tmp/full.sql shenmeh@192.168.34.3:/tmp/

[slave2:]

mysql < /tmp/full.sql

service mysqld restart

mysql> change master to master_host='192.168.34.1', master_port=3306, master_user='shenmeh', master_password='123',master_log_file='binlog.000001',master_log_pos=808;

mysql> start slave;

mysql> show slave status \G

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

ABC

slave3 ip 192.168.34.4

[slave2:]

vim /etc/my.cnf

添加

sync_binlog=1 (这行详情见http://blog.sina.com.cn/s/blog_4d8a2c970100f531.html)

log-bin=binlog

log-bin-index=binlog.index

save&exit

mysql>grant replication slave on *.* to 'shenmeh'@'192.168.34.4' identified by '123';

mysql>flush privileges;

mysql>show master status;

binlog.000002  235

[slave3:]

mysql -h 192.168.34.2 -u shenmeh -p123

登录成功mysql>

exit

vim /etc/my.cnf

server_id = 4

relay_log = /var/lib/mysql/mysql-relay-bin

relay_log_index=/var/lib/mysql/mysql-relay-bin.index

save&exit

service mysqld restart

rm -fr /var/lib/mysql/*

[slave2:]

mysqldump -A -x > /tmp/full.sql

scp /tmp/full.sql shenmeh@192.168.34.4:/tmp/

service mysqld restart

[slave3:]

mysql < /tmp/full.sql

mysql> change master to master_host='192.168.34.2', master_port=3306, master_user='shenmeh', master_password='123',master_log_file='binlog.000002',master_log_pos=235;

mysql> start slave;

mysql> show slave status \G