Well, this doesn't look like an entirely Perl related problem, and I have a non-entirely-Perl-related answer. :-)
If your tables are not timestamped, an alternative solution could be reached through log-update files.
In your my.cnf, you can have the following: 
[mysqld]
log-update
log-long-format

[download]
It will produce a log with a copy of all the commands issued to the server. The long-format business means that before each query there is a comment with information about user, IP, date and time of the query.
This log is a SQL script that you can present to MySQL and replicate all the changes made since the start of the log. (Whith the exception of LOAD DATA queries: for these ones you would need the original input files as well).
Here, finally, enters Perl, which you can use to parse this log and send the lines you want to the second server.
It would help if you saved the log on a regular basis (it grows really BIG!).
The resulting format of the log-file is something like 
# Time: 011206  9:47:01
# User@Host: john[john] @  [10.10.10.112]
INSERT INTO official_holidays (OHDate,OHName) VALUES ( "2000/01/01" , 
+"New Years Day");

[download]
Parsing this format in Perl is not straightforward but not extremely difficult either.
For example, to get all the records after a given date and time, you could use: 
#!/usr/bin/perl -w
use strict;

my $start_copy = 0;
while (<>) {
        next if /^\s+$/;
        if ((!$start_copy) 
          and (/^# Time: (\d+)\s+(\d+):(\d\d):(\d\d)/)) {
                my $date = $1;
                my $hour = $2;
                # check if date and time are what you need
                if ((substr($1,4,2) eq "06") and ($hour gt "09")) {
                        $start_copy = 1;
                }
        }
        print if $start_copy;
}

[download]
The regex should be fortified a bit, but I am sure you got the idea.

One more thing: within your applications, you can decide not to update the logs temporarily, by setting the SQL_LOG_OFF variable to "1". More on that in the manual.
Cheers
gmax

In reply to Re: mirroring mySQL database by gmax
in thread mirroring mySQL database by filmo

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.