How to backup 250GB MariaDB database daily in Master-Slave scenario at table level

You are viewing an old version of this question. View the current version here.

We have setup MariaDB master-slave in our production environment. We want to backup all the databases on slave server daily on table level. The database size is more than 250GB. we gone through the link provided by Mariadb knowledge base. https://mariadb.com/kb/en/library/backup-and-restore-overview/

As we want to take backup at table level for all the databases, we not considering to user Percona XtraBackup.

Kindly help us on this how we can make consistency between master-slave and do the table level backup for all the database at slave server.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.