uhhhhhh.....NO! That's what databases are for, to "remember" things. They do that by writing data to disk and reading it back to you when you ask for it. What exactly do you think you will be losing by stopping and restarting the server daemon ("service" to you MS-types). What data do you think only exists in the RAM of the machine and hasn't been written to disk?
Shawn Green Database Administrator Unimin Corporation - Spruce Pine Tedy Aulia <[EMAIL PROTECTED]> wrote on 11/17/2005 12:53:25 AM: > Hi Gleb, > > I understand that the replication shouldn't break, but restarting master > means losing the updates made to the master database, which we can't > afford to do that. > > > TA > > > > >Hello. > > > >Why are you afraid of shutting down the server for a while? > >Is it so critical? If yes, send more detailed description of your > >situation. Replication shouldn't break. From: > > http://dev.mysql.com/doc/refman/5.0/en/replication-features.html > > > >"It is safe to shut down a master server and restart it later." > > > > > >Tedy Aulia wrote: > > > > > >>Hi Gleb, > >> > >>Thanks for your reply. > >> > >>I am using MySQL 3.23.33. > >> > >>The ones that I will need to add in my.cnf are the syncronisation > >>parameters as follow: > >> > >>binlog-do-db=XYZ > >>replicate-do-db=XYZ > >>replicate-ignore-table=XYZ.table1 > >>replicate-ignore-table=XYZ.table2 > >>replicate-ignore-table=XYZ.table3 > >> > >> > >>Database XYZ was in synch for the past 12 months, I have found database > >>is not in synch anymore as the parameters I mentioned above are missing > >>in my.cnf. I want to put back those parameters but I can't afford to > >>restart the server as MySQL server is also used by other database which > >>is currently in synch and runs happily. > >> > >> > >> > >> > >>Cheers, > >>TA > >> > >> > >>Hello. > >> > >>You can change some variables without restarting the server. See: > >> http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html > >> > >>Tedy Aulia wrote: > >> > >> > >> > >>>Hi All, > >>> > >>>I will need to change my.cnf in master machine, but I can't afford to > >>>restart MySQL server as the server has been used for heavy traffic > >>>databases. > >>>Can anyone tell me how to do it? > >>> > >>> > >>>Cheers, > >>> > >>>*Tedy Aulia* > >>> > >>> > >>> > >>> > >> > >>