I don't want to use replication as IIRC it would require that the sending MySQL server be listening externally.
-- Mark P. Hennessy [EMAIL PROTECTED] On Fri, 6 Sep 2002, Jeremy Tinley wrote: > Date: Fri, 6 Sep 2002 15:26:45 -0500 > From: Jeremy Tinley <[EMAIL PROTECTED]> > To: 'Mark Hennessy' <[EMAIL PROTECTED]> > Subject: RE: Master MySQL server rdist db to public MySQL servers > > Use replication then. It's the best way of ensuring you have the most > current data. > > -J > > -----Original Message----- > From: Mark Hennessy [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 06, 2002 3:26 PM > To: Jeremy Tinley > Cc: [EMAIL PROTECTED] > Subject: RE: Master MySQL server rdist db to public MySQL servers > > Is there any way to just force the MySQL server to reload from the table > data on disk? The recipient servers are read-only, and the sending > server > has a relatively infrequent rate of change, but just enough that it's > important > to make sure that things are flushed on the recipient servers every time > there's an update. > > -- > Mark P. Hennessy > [EMAIL PROTECTED] > > On Fri, 6 Sep 2002, Jeremy Tinley wrote: > > > Date: Fri, 6 Sep 2002 15:17:09 -0500 > > From: Jeremy Tinley <[EMAIL PROTECTED]> > > To: 'Mark Hennessy' <[EMAIL PROTECTED]> > > Subject: RE: Master MySQL server rdist db to public MySQL servers > > > > You can lock tables, copy the files off, then unlock tables. This is > > what mysqlhotcopy does. Run mysqlhotcopy with the --dryrun option and > > it will only print what it does without actually doing anything. > > > > You can see the method it uses to backup databases. Then tailor your > > own solution. For instance, I want to use this method to do live > > backups of my DB. FLUSH TABLES with READ LOCK, then tar to tape, then > > unlock tables. > > > > -J > > > > -----Original Message----- > > From: Mark Hennessy [mailto:[EMAIL PROTECTED]] > > Sent: Friday, September 06, 2002 3:05 PM > > To: Gerald Clark > > Cc: [EMAIL PROTECTED] > > Subject: Re: Master MySQL server rdist db to public MySQL servers > > > > Shutting down the servers is not an option unfortunately, is there any > > program to run that can force the files to be rechecked without > shutting > > down the entire server and restarting it? > > > > -- > > Mark P. Hennessy > > [EMAIL PROTECTED] > > > > On Fri, 6 Sep 2002, Gerald Clark wrote: > > > > > Date: Fri, 06 Sep 2002 15:15:30 -0500 > > > From: Gerald Clark <[EMAIL PROTECTED]> > > > To: Mark Hennessy <[EMAIL PROTECTED]> > > > Cc: [EMAIL PROTECTED] > > > Subject: Re: Master MySQL server rdist db to public MySQL servers > > > > > > Just shut down all the servers before copying the files. > > > > > > Check out live replication. > > > It may be a better solution. > > > > > > Mark Hennessy wrote: > > > > > > >I have a Master MySQL server which does not listen publicly, and it > > > >distributes a database to my publicly accessible MySQL servers via > > > >rdist/ssh every 15 mins or so by copying the table files. Is there > > any > > > >flushing that has to be done for the newly rdist'd files to be used > > by > > > >the public MySQL servers? > > > > > > > >-- > > > > Mark P. Hennessy > > [EMAIL PROTECTED] > > > > > > > > > > > > >--------------------------------------------------------------------- > > > >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 > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > 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 > > > > > > --------------------------------------------------------------------- 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