MySQL--------基于binlog实现闪回最佳实战
mysql> show variables like 'version';+---------------+------------+
| Variable_name | Value |
+---------------+------------+
| version | 5.6.36-log |
+---------------+------------+
1 row in set (0.03 sec)
mysql> show variables like 'datadir';
+---------------+--------------------+
| Variable_name | Value |
+---------------+--------------------+
| datadir | /data/mysql_data6/ |
+---------------+--------------------+
1 row in set (0.00 sec)
mysql> show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin | ON |
+---------------+-------+
1 row in set (0.00 sec)
mysql> show variables like 'binlog_format';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| binlog_format | ROW |
+---------------+-------+
1 row in set (0.00 sec)
mysql> show variables like 'binlog_row_image';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| binlog_row_image | FULL|
+------------------+-------+
1 row in set (0.00 sec)
页:
[1]