데이터베이스

Total 205
Today 0
profile_image
슈퍼아이피
18-06-25 17:55 0개 571회
MySQL
xtrabackup 테스트

 innobackupex --user=root --no-timestamp /root/full
4
 innobackupex --user=root --no-timestamp --incremental --incremental-basedir=/root/full /root/inc
6

 innobackupex --user=root --no-timestamp --incremental --incremental-basedir=/root/full /root/inc2
8

복원
innobackupex --apply-log --redo-only /root/full

innobackupex --apply-log --redo-only /root/full --incremental-dir= /root/inc

innobackupex --apply-log --redo-only /root/full --incremental-dir=/root/inc2

 service mariadb stop
 rm -rf /var/lib/mysql/*
 innobackupex --copy-back /root/full
 chown -R mysql:mysql /var/lib/mysql
service mariadb start



innobackupex --no-timestamp --user=root  /root/full
innobackupex --apply-log --redo-only /root/full
to_lsn=`grep to_lsn /root/full/xtrabackup_checkpoints | awk '{ print $3 }'`
innobackupex --user=root --incremental --incremental-lsn=$to_lsn --no-timestamp /root/inc
innobackupex --apply-log --redo-only --incremental-dir=/root/inc /root/full
rm -rf /root/inc/*
 

추천 0 비추천 0

댓글목록

등록된 댓글이 없습니다.