http://www.perlmonks.org?node_id=59778


in reply to Re: Perl/mySQL question
in thread Perl/mySQL question

Since the above mentioned link is the way that mysql provides for such a thing, I would recommend setting up one-way replication like this. However, if there is something magical about the database needing to be updated at a set interval, you could always use mysqldump on the secure host, then rebuild the web host from the dump without needing to close either host down.