xtrabackup备份方式搭建一个mysql slave
来源:互联网 发布:淘宝正确产品推广方法 编辑:程序博客网 时间:2024/06/05 02:08
[root@db-2-43 ~]# cd /usr/src/
[root@db-2-43 src]# wget http://www.percona.com/redir/downloads/XtraBackup/LATEST/binary/Linux/x86_64/percona-xtrabackup-2.1.5-680-Linux-x86_64.tar.gz
[root@db-2-43 src]# tar zxvf percona-xtrabackup-2.1.5-680-Linux-x86_64.tar.gz
[root@db-2-43 src]# cp percona-xtrabackup-2.1.5-Linux-x86_64/bin/* /data/mysql/bin/
[root@db-2-43 DBD-mysql-4.023]# yum -y install perl-DBD-MySQL.x86_64
# wget http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBI-1.628.tar.gz
# tar zxvf DBI-1.628.tar.gz
# cd DBI-1.628
# perl Makefile.PL
# make && make install
# wget http://search.cpan.org/CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.023.tar.gz
# tar zxvf DBD-mysql-4.023.tar.gz
# cd DBD-mysql-4.023
# perl Makefile.PL --libs="-L/data/mysql/lib -lmysqlclient -lz -lrt -lcrypt -lnsl -lm" --cflags=" -I/data/mysql/include/"
# make && make install
[root@db-2-43 data]# innobackupex --user=root --password= root --port=3306 --defaults-file=/etc/my.cnf --slave-info --socket=/data/mysql/data/mysql.sock --no-timestamp /data/backup/pis_slave
# innobackupex --apply-log /data/backup/pis_slave/
mysqld_safe --user=mysql --ledir=/data/mysql/bin/ &
[root@db-3-5 pis_slave]# cat xtrabackup_slave_info
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.012434', MASTER_LOG_POS=525181886
14:30:53 (none)>CHANGE MASTER TO
-> MASTER_HOST='10.0.2.44',
-> MASTER_USER='repl',
-> MASTER_PASSWORD='repl',
-> MASTER_PORT=3306,
-> MASTER_LOG_FILE='mysql-bin.012434',
-> MASTER_LOG_POS=525181886,
-> MASTER_CONNECT_RETRY=10;
14:33:00 (none)> start slave;
http://segmentfault.com/a/1190000002575399
- xtrabackup备份方式搭建一个mysql slave
- 用Percona XtraBackup 搭建 Mysql replication slave
- 使用Percona XtraBackup备份工具创建MySQL Slave
- mysql xtrabackup增量备份
- XtraBackup备份MySQL
- MySQL备份之Xtrabackup
- xtrabackup备份mysql数据库
- mysql备份之xtrabackup
- xtrabackup增量备份mysql
- mysql xtrabackup备份恢复
- mysql备份之Xtrabackup
- MySQL XtraBackup备份脚本
- xtraBackup 备份mysql
- MySQL备份恢复--Xtrabackup
- 利用xtrabackup 搭建主从备份
- Mysql Master/Slave备份
- Mysql的备份工具xtrabackup
- MySQL备份恢复之XtraBackup
- as3工具类,开源包等
- ASP.NET MVC三个重要的描述对象四:ParameterDescriptor
- 符号数表示—原码 反码 补码
- Objective-C学习笔记(二十三)——面向对象之封装
- oracle sql积累
- xtrabackup备份方式搭建一个mysql slave
- Linux学习笔记
- Handler用法
- python中shutil模块
- 项目和工具地址
- 日期转换成json以后会变成一串数字,如何把数字转换为日期
- hibernate一级缓存和二级缓存
- 以ValueProvider为核心的值提供系统1: NameValueCollectionValueProvider
- 使用$_SESSION(变量名) 的方法