On Tue, Feb 22, 2011 at 3:05 AM, john s. <firesk...@gmx.de> wrote: > > Hello all, > > I would like to Stop and Start RT in order to make an Backup Process. > > > Should i Kill or Stop the RT Process ? Whats the difference and what does > it make more sense? > > And which processes are belongs to RT? > > I'm not a MySQL expert by any means, but isn't it possible to get a quiescent backup of MySQL without stopping/starting any services?
It's my understanding that one can issue a "read lock" as part of the mysqldump command. If this is the case, wouldn't it be less disruptive to users since the web and email services would not be shutdown in order to perform a backup. I have also read that this "read lock" works particularly well when using it to backup a replica, since this would require zero down time. ~ Tom