maria-developers team mailing list archive

[Arjen Lentz <arjen@xxxxxxxxxxxxx>]

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.

Current
 - 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.


Cheers,
Arjen.
--
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