MySQL的replication热备配置过程

MySQL的replication热备配置过程

(2013-03-16 22:55:37)

http://blog.youkuaiyun.com/lapiggy  (MySQL性能及主备跳服务设置文档)

http://blog.sina.com.cn/s/articlelist_1755341331_1_1.html  (DRBD(集群)配置过程)

操作系统：中标Linux

Mysql版本：mysql-server.i386 0:5.0.45-7.el5

（注：安装mysql是用的yum命令）

Mysql1端 IP 192.168.2.122

Mysql2端   IP 192.168.2.123

数据库：test

1.Mysql1设置:

1.1 设置Mysql Replication

1.增加一用于数据库同步的用户root

mysql>GRANT REPLICATION SLAVE,REPLICATIONCLIENT,RELOAD,SUPER ON *.* TO 'root'@'192.168.2.123' IDENTIFIED BY'password';

(授与从192.168.2.123主机上登录用户root数据复制权限)

2.使权限生效，这步可不做，因为过会要重启mysql

mysql>flush privileges;

3.退出mysql命令行界面

mysql> exit

4.停止mysql服务

service mysqld stop

5.更改Mysql配置文件/etc/my.cnf

打开mysql配置文件

vi /etc/my.cnf

在配置文件中添加以下内容

[mysqld]

#master

log-bin

server-id=1

binlog-do-db= vtigercrm510

 

#slave

master-host = 192.168.2.120

master-user = root

master-password = password

master-port = 3306

master-connect-retry = 10

replicate-do-db = test

6.启动Mysql

service mysqld start

2.Mysql2设置:

 

1.更改Mysql配置文件/etc/my.cnf

打开Mysql的配置文件

vi /etc/my.cnf

在配置文件中添加以下内容

 

[mysqld]

#master

log-bin

server-id=2

binlog-do-db= vtigercrm510

 

#slave

master-host = 192.168.2.118

master-user = root

master-password = password

master-port = 3306

master-connect-retry = 10

replicate-do-db = vtigercrm510

 

2.重新启动Mysql服务

service mysqld   restart

3.Mysql1设置:

 

1.分别在mysql1和mysql2上启动slave

mysql> START SLAVE;

2.查看slave状态：

mysql> show slave status\G;

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

如果都是yes，代表已经在同步

 

3.查看mster状态

mysql> Show master status;

Mysql设置完毕