Hi! Yesterday, I created a filtered replicator plugin based on the default replicator that Jay developed. It is a simple filtered replicator that can currently filter events based on a schema or table name. A user can specify a list of tables or schemas to filter replication events by. If an event is on a schema or table that is to be filtered, then the event will not be passed on to an applier by the replicator.
Right now, this replicator has 3 system variables: * filtered_replicator_enable - whether the replicator is enabled or not * filtered_replicator_filteredschemas - comma separated list of schemas to filter events on * filtered_replicator_filteredtables - comma separated list of tables to filter events on Now, the development of this plugin is not the hard part for me any more. I have no practical experience of replication with MySQL so I'm unsure of what kinds of things people would like with regards to replication filters. What I need input on is configuration options users might want for a filtered replicator. Some ideas I'm pondering are (especially whether they are needed or a good idea): * filter different SQL statements (i.e. select, update, delete...) * filter SQL statements based on values contained within the statement * support for filters with regular expressions Does anyone have any input on any of the above? What way would people like to filter replication events? Anything else someone would like to see? -Padraig _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
