1

I want to take a dump from a live mariadb database, but I need during the backup process to stop any kind of insert or update so as my backup to be the latest data image from my database.

Is this possible and how ?

3

1 Answer 1

0

For a live System use database replication, where your main database is master and the second is a child. and there is also percona.com/software/mysql-database/percona-xtrabackup

Additional information for example for examlpe lockinfg the databse see

Safest way to perform mysqldump on a live system with active reads and writes?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.