# replication filtering

**URL:** <https://forums.percona.com/t/replication-filtering/1416>\
**Category:** Other MySQL® Questions\
**Created:** [May 27, 2010, 8:49am UTC](https://forums.percona.com/t/replication-filtering/1416 "2010-05-27T08:49:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![yogesh77](https://avatars.discourse-cdn.com/v4/letter/y/f08c70/32.png) [@yogesh77](https://forums.percona.com/u/yogesh77)\
**Post date:** [May 27, 2010, 8:49am UTC](https://forums.percona.com/t/replication-filtering/1416/1 "2010-05-27T08:49:01Z")

</div>

Hi,

I want to setup a slave replication to filter a table only for insert statement i.e. only insert statement should be replicated to the slave, no delete and update.  
Is there any way to accomplish this?  
after searching a lot i didnt find any thing specific, someone suggesting to to write lua script to filter relay log on slave for insert statement.

Please suggest.

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [May 27, 2010, 3:25pm UTC](https://forums.percona.com/t/replication-filtering/1416/2 "2010-05-27T15:25:45Z")

</div>

It can’t be done natively with MySQL.