MySQL使用LVM快照实现备份

[root@localhost ~]# lvs
 LV    VG   Attr    LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert                         
 mydatalv mydata -wi-ao---- 1.00g  
[root@localhost ~]# df -h
文件系统           容量 已用 可用 已用% 挂载点
/dev/mapper/mydata-mydatalv 976M 2.6M 907M  1% /data

[root@ns1 ~]# vim /etc/my.cnf
  [mysqld]
  log_bin=/var/lib/mysql/mysql-bin
  datadir=/data/mysql
[root@localhost ~]# service mariadb restart
[root@localhost ~]# ls /data/mysql
aria_log.00000001 ibdata1   ib_logfile1 mysql-bin.000001 mysql-bin.000003 performance_schema
aria_log_control  ib_logfile0 mysql    mysql-bin.000002 mysql-bin.index  test

[root@localhost ~]# mysql -e 'flush tables with read lock;' 锁表
[root@localhost ~]# mysql -e 'flush logs;'     对日志进行滚动，
[root@localhost ~]# mysql -e 'show master status;' > /root/back.$(date +%F+%T)
[root@localhost ~]# ls
back.2016-07-13+10:14:29

[root@localhost ~]# mkdir /myback
[root@localhost ~]# mount -r /dev/mydata/mysqlback /mnt
[root@localhost ~]# cp -a /mnt/mysql /myback

[root@localhost ~]# mysql
  MariaDB [hellodb]> use hellodb;
  MariaDB [hellodb]> insert into classes (class,numofstu) values ('xxoo',39);
[root@localhost ~]# rm -rf /data/*

[root@localhost ~]# vim /etc/my.cnf
  [mysqld]
  log_bin=/data/mysql/mysql-bin
  datadir=/data/mysql

[root@localhost ~]# cp -a /myback/* /data/
[root@localhost ~]# service mariadb restart

[root@localhost ~]# cat back.2016-07-13+10\:14\:29 
File  Position  Binlog_Do_DB  Binlog_Ignore_DB
mysql-bin.000014    245

[root@localhost ~]# mysqlbinlog --start-position=245 /var/lib/mysql/mysql-bin.000014 > binlog.sql
[root@localhost ~]# mysql < /root/binlog.sql

[root@localhost ~]# mysql
  MariaDB [(none)]> use hellodb;
  MariaDB [hellodb]> select * from classes;
  +---------+----------------+----------+
  | ClassID | Class     | NumOfStu |
  +---------+----------------+----------+
  |    1 | Shaolin Pai  |    10 |
  |    2 | Emei Pai    |    7 |
  |    3 | QingCheng Pai |    11 |
  |    4 | Wudang Pai   |    12 |
  |    5 | Riyue Shenjiao |    31 |
  |    6 | Lianshan Pai  |    27 |
  |    7 | Ming Jiao   |    27 |
  |    8 | Xiaoyao Pai  |    15 |
  |    9 | xxoo      |    39 |
  +---------+----------------+----------+
  9 rows in set (0.00 sec)