Hi Tim,
On Mon, Jun 22, 2009 at 4:41 PM, Little,
Timothytlit...@thomaspublishing.com wrote:
We have a 20 gig db (that includes the MYIs and MYDs and FRMs).
We are wondering how long LVM snapshots take.. in that how long might
the DB be read-locked? Do we have to read-lock it and flush
We have a 20 gig db (that includes the MYIs and MYDs and FRMs).
We are wondering how long LVM snapshots take.. in that how long might
the DB be read-locked? Do we have to read-lock it and flush tables?
Are we talking half a second, ten-seconds, 20 minutes?
Currently, when we copy the raw files
Hi Tim,
We use LVM snapshots all the time. They are essentially
instantaneous with our 90GB innodb database files.
A command to generate the snapshot could be:
sudo /usr/sbin/lvcreate --snapshot --name mysqlsqlbackup --size 15G /
dev/system/data01
Please let me know if you have any
What we do to start is the following:
) open 2 windows to the server running the mysql instance
) in one window,
) run the mysql cli and issue command 'flush tables with read lock'
) stop the slave, if this is a running slave
) run either show master status or show slave status,
Little, Timothy wrote:
We have a 20 gig db (that includes the MYIs and MYDs and FRMs).
We are wondering how long LVM snapshots take.. in that how long might
the DB be read-locked? Do we have to read-lock it and flush tables?
Take a look at mylvmbackup which takes care of flushing tables,