Arjen Lentz wrote: > Hi Jeremy, Mats > > On 22/08/2008, at 1:59 AM, Jeremy Zawodny wrote: >> Does it make sense to explicitly record the database(s) and/or >> table(s) involved in a statement. I don't know how common it is to >> filter replication based on one or both of those, but I tend to >> encounter it WAY more than I'd expect to... > > > It'd be great if a slave could give a master a ruleset for this, so it > doesn't have to drag across everything before filtering.
Yes, it makes sense that data is filtered in the "dump thread" and it also makes sense that the slave decides that (because different slaves can have different filtering conditions, so it is not possible to set a single set of rules on the master that will be correct. Just my few cents, Mats Kindahl > So, I like the idea of explicitly recording the dbs/tables involved in a > query (and not just the current default db), but more for the benefit of > the master being able to filter before sending it to an individual > slave, rather than having all the extra info go across the wire too. > > > Regards, > Arjen. -- Mats Kindahl Lead Software Developer Replication Team MySQL AB, www.mysql.com
begin:vcard fn:Mats Kindahl n:Kindahl;Mats org:Sun Microsystems adr;quoted-printable:;;Tegv=C3=A4gen 3;Storvreta;SE;74334;Sweden email;internet:[EMAIL PROTECTED] title:Lead Replication Software Developer x-mozilla-html:FALSE version:2.1 end:vcard
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
