GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

replication filtering

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • replication filtering

    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.

  • #2
    It can't be done natively with MySQL.

    Comment

    Working...
    X