On Saturday 12 January 2002 20:53, Jeremy Zawodny wrote: > On Fri, Jan 11, 2002 at 08:08:51AM -0800, Kyle Hayes wrote: > > We write our own replication system using our own checkpointing and > > code. We start with the update logs (we're not happy about the > > future removal of the update logs because of this). I've looked > > through the MySQL source to see if I can figure out enough of the > > format of the binary log to see if I can make some Perl code that > > will parse it. It is really easy to use the update log since all > > SQL end with a semicolon as the last character on a line. Since > > Perl tends to be line-oriented, it is easy to find this. > > [snip] > > Several questions: > > (1) Do you use transactions at all, or is this MyISAM only? > > (2) Have you considered publishing the code? > > (3) Do I understand correctly, that you have your own primary keys > which have nothing to do with MySQL's unique IDs?
1) MyISAM only (we started on some of this when 3.23 was knee-high to a bullfrog :-) 2) Yes, but we probably won't. The code has a large number of assumptions about our set up. I don't know that management would be too thrilled with it. The system I'm working on now (to replace the old one) is much cleaner, but would still need a work to remove any Quicknet IP from it. I don't have time to do the clean up, but in general I'd like to give it back to the community. 3) We have sets of IDs for each row that are unique per server. They are made with something like a sequence table using LAST_INSERT_ID tricks. These are the IDs that tie everything together. The auto increment fields are for bulk record keeping and things like purging old data efficiently. Honestly, it is not that much code. I wrote the whole thing in about a week full time. I'll check with management to see if I can release it. Best, Kyle --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
