Re: duplicating a replicated slave environment

2007-05-09 Thread Baron Schwartz
Hi Hank, (CCing the list again so others can see...) Hank wrote: Thanks for your reply. Two things -- I start/stop the sql-thread once daily as a backup strategy. This slave has no application readers or writers. If anything should go wrong with the master, I have one full day to either co

Re: duplicating a replicated slave environment

2007-05-08 Thread Baron Schwartz
Hi, Hank wrote: Hello All, I have a 4.1.14 mysql database master and slave set up. For this slave #1, I have the IO thread running constantly, and the SQL thread running once a day to update all pending updates from the master (then I shut it off). So for most of the day, this database is sta

duplicating a replicated slave environment

2007-05-08 Thread Hank
Hello All, I have a 4.1.14 mysql database master and slave set up. For this slave #1, I have the IO thread running constantly, and the SQL thread running once a day to update all pending updates from the master (then I shut it off). So for most of the day, this database is static (except for th