> Also, what are you going to rsync? MySQLs data dir? Ok, that will do in
case you store tables in MyISAM tablespace, but will not work in case of
InnoDB. Also, rsyncing MyISAMi tables 'on the fly' in not officially
supported method by MySQL.Net, and thus it might lead to unpredictable
consequences like loosing part of users, corrupted tables on slave
server, etc. I think that it's wiser to use officially supported methods
of MySQL database replications instead of simple rsync.
The MyISAM files (vpopmail used MyISAM) are so small and written to so
infrequently that rsync will work fine. The files in question are only
changed when you do something to a user, alias or a domain, such as add
or delete. The tables are merely used for lookups the rest of the time
and as such stay static.
I would not recommend rsync as a day-to-day backup strategy for your
normal dynamic database, but given how static these tables tend to be,
it should be fine.
W
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
