<br><div class="gmail_quote">On Tue, Feb 22, 2011 at 3:05 AM, john s. <span dir="ltr"><<a href="mailto:fireskyer@gmx.de">fireskyer@gmx.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
Hello all,<br>
<br>
I would like to Stop and Start RT in order to make an Backup Process.<br>
<br>
<br>
Should i Kill or Stop the RT Process ? Whats the difference and what does<br>
it make more sense?<br>
<br>
And which processes are belongs to RT?<br>
<br></blockquote><div><br>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?<br><br>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.<br>
<br>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. <br><br>~ Tom<br></div></div>