Re: mysql connection and bash script
As soon as the database connection ends, the lock is lost.
Have you tried using ShellSQL to keep the connection open?
I am working on issuing the MySql command
FLUSH TABLES WITH READ LOCK
before taking a snapshot of the LVM disk containing the database and then
UNLOCK TABLES
to unlock them again.
This minimises the time during which the tables are locked.
If anyone already has/knows of a script that does this then please post the script or a link here.
Thanks,
Julez
Subject
Written By
Posted
December 29, 2008 02:53PM
Re: mysql connection and bash script
March 20, 2009 06:51PM
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.