万里数据库GreatDB数据备份-2

远程备份

如果是远程备份，需要启动一个greatdb实例作为备份节点。

1、全量备份

(1)连接待备份的节点，执行如下命令：

greatdb> INSTALL PLUGIN clone SONAME 'mysql_clone.so';
Query OK, 0 rows affected (0.01 sec)
greatdb> INSTALL COMPONENT "file://component_mysqlbackup";
Query OK, 0 rows affected (0.01 sec)

(2)连接备份节点，执行如下命令：

greatdb> INSTALL PLUGIN clone SONAME 'mysql_clone.so';
Query OK, 0 rows affected (0.01 sec)
greatdb> SET GLOBAL clone_valid_donor_list = '127.0.0.1:3307';
Query OK, 0 rows affected (0.01 sec)
greatdb> CLONE INSTANCE FROM 'root'@'127.0.0.1':3307  identified by '' data directory='/var/data/clone1' enable page track;
Query OK, 0 rows affected (0.01 sec)

2、增量备份

(1)连接备份节点，执行如下命令：

greatdb> clone instance from 'root'@'127.0.0.1':3307  identified by '' data directory='/var/data/clone1_1' enable page track start_lsn=21083116;
Query OK, 0 rows affected (0.01 sec)