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 ?

Christoforos
  • 149
  • 1
  • 9
  • use database replication, where your main database is master and the second is a child. and there is also https://www.percona.com/software/mysql-database/percona-xtrabackup – nbk Jan 09 '21 at 22:48
  • @nbk I don't see how these two options will stop insert and updates during backup. – Christoforos Jan 10 '21 at 05:14
  • Oh sorry,then you need to loock the database https://dba.stackexchange.com/questions/19532/safest-way-to-perform-mysqldump-on-a-live-system-with-active-reads-and-writes – nbk Jan 10 '21 at 09:45

1 Answers1

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?

nbk
  • 8,191
  • 5
  • 13
  • 27