A
A
AJ2017-02-22 01:43:11
MySQL
AJ, 2017-02-22 01:43:11

How to keep original DATA DIRECTORY of table in Percona xtrabackup?

Good afternoon. Such situation. MySQL 5.6.34 There is a database, some tables in the default dir, some on the SSD. There is a replica. The replica falls, binlogs mercilessly lag behind storage limits. You need to deploy from xtrabackup backup. We copy the dump to the replica, deploy it, run the bin logs, and it becomes clear that the DATA DIRECTORY masters are not taken into account. The problem is that I need the tables to be taken into account and rolled onto exactly the disks on which they were on the master when deploying the backup.
The question is how to achieve such a result?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question