摘要:
xtrabackup 失败! mysqldump 报错: ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty. 在dump导出时,添加--se 阅读全文
摘要:
mysql> USE test; Database changed mysql> SHOW VARIABLES LIKE 'innodb_file_per_table'; + + + |Variable_name | Value | + + + |innodb_file_per_table | ON 阅读全文
摘要:
Mysql (需5.6以上版本)延迟复制配置,通过设置Slave上的MASTER TO MASTER_DELAY参数实现: CHANGE MASTER TO MASTER_DELAY = N; N为多少秒,该语句设置从数据库延时N秒后,再与主数据库进行数据同步复制 具体操作: 登陆到Slave数据库 阅读全文