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?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 10 days, processed 248,268,346 queries (280/sec. avg)
---------------------------------------------------------------------
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
