Re: How to quiece an mysql before taking snapshot?
Posted by:
Richard
Date: November 28, 2007 09:11AM
flush tables with read lock;
flush logs;
unlock tables;
All above are the exact SQL statements you will use. It locks all the tables on the server, flushes the logs, at this poit you should now take your snapshot, then the last statement unlocks all your tables.
Here is the first hit I found on Google for using LVM. It is not exactly what you want but it will get you started.
http://blog.dbadojo.com/2007/09/mysql-backups-using-lvm-snapshots.html
Subject
Views
Written By
Posted
6157
November 27, 2007 04:28AM
1906
November 27, 2007 08:58AM
1918
November 27, 2007 11:52PM
1827
November 28, 2007 04:37AM
Re: How to quiece an mysql before taking snapshot?
3600
November 28, 2007 09:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.