[Tfug] MySql and rsync

[Stephen Hooper]

On 4/18/07, TR <trexx at pobox.com> wrote:
>
> Yes  close byt it is an  rsync  command that is  doing the work.    When I
> first posted I did no have a lot of background on this.  But I know now that
> image files are sent to a working directory when a modified version of rsync
> sends the file to the mysql db.   It is based on the
> patches/ODBC-dblog.diff.  This adds logging to the rsync daemon.  This
> was further modified to do
> an  insert into the database. for our specific needs.   By counts the number
> staged to be send is greater then those showing up in the database.
>

Interesting...

You should probably be looking for an "rsync" expert then, as it
sounds to me that the problem is there:  especially as you seem to be
doing some "weird" things.

But, I guess that depends... when you say "by counts": how are you
getting those counts (from some kind of drop log, from looking at
files in the directory, from looking at rsync, or from looking at
transactions)?

Also, how is rsync being run?  Is it timed, or is it on some kind of
event trigger?

You could look for some kind of namespace collisions, which may happen
depending on what/when you are inserting into the table.

I would also check that the local mods to rsync are not miscounting,
and finally turn on logging on MySQL to see if it agrees with what you
think should be sent:

./bin/safe_mysqld --log="logfilepath" &

You would need some downtime for that though...

Not sure how else I can help (assuming this is helpful), until the
problem is more fleshed out...