I have a database that needs to be accessable all the time, but i also need to back it up which i cant do if someone has it open. I had a though that i might write the data to a mysql database running initally on the same box and then migrate it onto a back up box.
Is this possible? or indeed advisable?