没有删除语句的MySQL复制 [英] MySQL replication without delete statments

问题描述

我一直在寻找一种方法来防止MySQL删除语句被从属服务器处理，我正在处理数据仓库项目，并且在将数据复制到从属服务器后，我想从生产服务器中删除数据.

I have been looking for a way to prevent MySQL delete statements from getting processed by the slave, I'm working on data warehousing project, and I would like to delete data from production server after having data replicated to slave.

完成此任务的最佳方法是什么?

what is the best way to get this done?

谢谢

推荐答案

有几种方法可以做到这一点.

There are several ways to do this.

1. 在执行删除之前，对主服务器上的相关会话运行SET SQL_LOG_BIN=0;.这样就不会将其写入二进制日志
2. 在从属服务器上执行BEFORE DELETE触发器以忽略删除.

1. Run SET SQL_LOG_BIN=0; for the relevant session on the master before executing your delete. That way it is not written to the binary log
2. Implement a BEFORE DELETE trigger on the slave to ignore the deletes.

对于我不想复制的语句，我倾向于使用方法#1.它需要SUPER权限.

I tend to use approach #1 for statements that I don't want to replicate. It requires SUPER privilege.

我还没有尝试过#2，但应该可以.

I have not tried #2, but it should be possible.

这篇关于没有删除语句的MySQL复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！