Hi all, I like the storage engine change list idea too, so that¹s +1 from me.
Here¹s another question for the team: would it be possible for the replication plug-in to turn around and store what it gets in a table? This would give you transactional storage of data in some transport-ready form for an external daemon that then grabs it from the table. If this is possible would it be transactional, in other words how could it be coupled with the existing transaction so you would get correct recovery? I ask this because it always struck me that MySQL replication used a less-than-optimal approach of storing things in binlog files when there was a nice database standing by. Cheers, Robert On 7/24/09 11:21 AM PDT, "Brian Aker" <[email protected]> wrote: > Hi! > > On Jul 24, 2009, at 1:56 AM, Paul McCullagh wrote: > >> We discussed this on Drizzle Day, and that was my recommendatio > > ++ > >> This would mean, after a transaction has committed, the replication >> system asks the engine for a "list of operations" that were >> performed by the transaction. > > To make this happen... you would need to skip the trigger for the > replication, not hard, and then have a separate thread convert the log > to protos and push it into the replication storage piece. > > Yes... native log would be faster (aka skip the system), but you would > lose out on having filtering/transportable/scriptable... for some I am > sure the speed would be great, but I suspect most would want > flexibility. > > The nice thing about this? It is entirely up to whomever writes the > plugins :) > > Cheers, > -Brian > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- Robert Hodges, CTO, Continuent, Inc. Email: [email protected] Mobile: +1-510-501-3728 Skype: hodgesrm _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
