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 ?
MariaDB – How to Backup Live Database
mariadb-5.5
Related Question
- MariaDB – Handling Special Characters
- MySQLDump – Why Generated File is Larger Than Data Directory
- MariaDB 5.5 – Customize Password Rules
- MySQL – How to Force mysqldump to Include All Data in MariaDB
- Mysql – delete over 90 million records, do I remove or maintain the transaction’s SQLWARNING
- Mariadb – Deleting Duplicates – mariaDB
Best Answer
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?