How to backup 250GB MariaDB database daily in Master-Slave scenario at table level
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.