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...
Jeremy On Wed, Aug 20, 2008 at 8:51 AM, Mats Kindahl <[EMAIL PROTECTED]> wrote: > Hi all! > > I have added a stub for a specification of a very simple statement-based > replication implementation on the Drizzle wiki under > > http://drizzle.wikia.com/wiki/Simple_Replication > > In there, we have a sample specification of the binary log messages that > are needed to support the implementation. The intention is to have > something small and simple up and running in a relatively short time. To > do this, we are specifying the message format in Protobuf, but to handle > the message transport, a separate module will be used to handle > "framing" of the messages for transport to the slave. > > The goals are: > > * Simple replication implementation > * Separate module > * Supporting slave fail-over to other master (something that MySQL > Replication does not support well currently) > * Moderate message integrity checking using simple CRC-32 checksum > (mainly aimed to ensure that the correct size of messages are read). > * Support for adding digest/hash for more extensive integrity checks > > Some open issues are: > * Timestamps are currently down to nanosecond precision, but I question > if this is needed. It requires 8 bytes, which is almost half of the > header, so if we can reduce this for the common scenarios and maybe > have a timestamp where it is necessary, I think that would be a good > thing. > * Do we need to support encryption/compression of the individual events? > * There is no support for LOAD DATA INFILE yet. We could use a similar > technique as is used in MySQL Replication, but there might be > alternatives. > > Other ideas are welcome! > > Just my few cents, > Mats Kindahl > -- > Mats Kindahl > Lead Software Developer > Replication Team > MySQL AB, www.mysql.com > > _______________________________________________ > Mailing list: > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
