My application uses sql for performing operation. something like database-hendler->do(query). so there is only database-handler object.

i want to run multiple instence of my application so i want to maintain integrety of data. and i am looking for solution through sql for locking mechanism. so concurrent data access dont currept data.

my application is in perl and mysql.
I hope you have uderstand my requirement.
Please share your ideas with me.