Re: Master MySQL server rdist db to public MySQL servers
Thanks. A cron job that runs mysqladmin that flushes the tables every 15 mins or so is now in place. A flush-only user has been created to do this. I wonder if any negative impact for other databases could be expected at any point. -- Mark P. Hennessy [EMAIL PROTECTED] On Sat, 7 Sep 2002, Jeremy Zawodny wrote: Date: Sat, 7 Sep 2002 11:20:27 -0700 From: Jeremy Zawodny [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Mark Hennessy [EMAIL PROTECTED] Cc: Jeremy Tinley [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Master MySQL server rdist db to public MySQL servers On Fri, Sep 06, 2002 at 04:25:42PM -0400, Mark Hennessy wrote: 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. FLUSH TABLES WITH READ LOCK may do what you need. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 32 days, processed 657,485,780 queries (234/sec. avg) - 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
Re: Master MySQL server rdist db to public MySQL servers
On Fri, Sep 06, 2002 at 04:25:42PM -0400, Mark Hennessy wrote: 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. FLUSH TABLES WITH READ LOCK may do what you need. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 32 days, processed 657,485,780 queries (234/sec. avg) - 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
Re: Master MySQL server rdist db to public MySQL servers
On Fri, Sep 06, 2002 at 04:29:24PM -0400, Mark Hennessy wrote: I don't want to use replication as IIRC it would require that the sending MySQL server be listening externally. Why not setup an SSH tunnel, since you're planning to use SSH anyway. Then you can use MySQL's native replication. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 32 days, processed 657,492,130 queries (234/sec. avg) - 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
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
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
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
RE: Master MySQL server rdist db to public MySQL servers
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
Re: Master MySQL server rdist db to public MySQL servers
Well, you can't overwrite the data files while the server is running. Mark Hennessy wrote: 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