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
