GreatDB 备份方式

GreatDB 逻辑备份与恢复

GreatDB 逻辑备份流程

通过 general_log 观察备份流程

[root@greatdb1 ~]# greatsql -ugreatdb -pgreatdb -h192.168.0.81 -P3306
-- general_log 默认是关闭的
GreatDB Cluster[(none)]> show variables like 'general%';
+------------------+-------------------------------+
| Variable_name    | Value                         |
+------------------+-------------------------------+
| general_log      | OFF                           |
| general_log_file | /greatdb/logs/general3306.log |
+------------------+-------------------------------+
2 rows in set (0.01 sec)
-- 清空log日志文件
GreatDB Cluster[(none)]> system > /greatdb/logs/general3306.log
-- 开启 general_log
GreatDB Cluster[(none)]> set global general_log=ON;
Query OK, 0 rows affected (0.00 sec)
-- 执行备份任务，后面有介绍各种备份场景
-- 关闭 general_log
GreatDB Cluster[(none)]> set global general_log=OFF;
Query OK, 0 rows affected (0.00 sec)
				
	
	

		
相关文章