← Back to team overview

maria-developers team mailing list archive

Re: WL40: Notes/questions


Hi Kristian, Alexi

The current replication filters are borked. I wouldn't put work into it, but rather leave them (they are used) and add something that works.

- the binlog options prevent things from getting logged locally, which is bad for point-in-time recovery. - the replicate options work on the slave end, so they still get transmitted which is a) slow and b) potential security issue.

What should happen is that a slave has a profile on the master with a certain filter.
So, create a set of named filters, and attach a filter to a slave.
If filters are enabled (any defined), refuse any slave that does not have a filter profile, to prevent security problems.

Filters could be in a mysql.replfilters table and read into a mem structure, makes it easy to manage.

Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at a fixed budget.

Follow our blog at http://openquery.com/blog/
OurDelta: enhanced builds for MySQL @ http://ourdelta.org

Follow ups