mysql meb安装,用meb搭建MySQL Master/Slave

使用meb企业备份工具，自动实现记录二进制相关信息

此种备份方法需要安装一个软件 meb ，软件默认安装在 /opt 目录下，安装过程略

备份前在 my.cnf 中增加如下参数 (show variables like 'innodb%' )

innodb_data_home_dir = /data/MySQL                        #指定 datadir路径

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = /data/mysql              #指定日志路径，一般同datadir路径相同

innodb_log_files_in_group = 2

innodb_log_file_size = 5242880

log-bin = mysql

步骤：

一、建立帐号

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

mysql> flush privileges;

二、使用meb去备份Master的数据

# mkdir /backup

# cd /opt/mysql/meb-3.5/

# ./bin/innobackup --user=root --password=123 --ibbackup=/opt/mysql/meb-3.5/bin/ibbackup --socket=/data/mysqld.sock /etc/my.cnf /backup  --slave-info

.....

ibbackup: A copied database page was modified at 44233.

ibbackup: Scanned log up to lsn 46136.    #####记录这里的lsn

ibbackup: Was able to parse the log up to lsn 46136.

innobackup: Backup created in directory '/backup/2011-05-19_15-21-21'

innobackup: MySQL binlog position: filename 'mysqld-binlog.000003', position 1662  #####记录这里的position

110519 15:21:55  innobackup: innobackup completed OK!