Backup MySQL database remotely

MySQL & MariaDB Percona XtraBackup
1

Hi,

Currently, we have 3 windows server with MySQL servers and planning to use XtraBackup to run the incremental database backup.

Would like to setup this kind of scenario;

  1. Install linux in HyperV.
  2. Install Extrabackup in Linux.
  3. Run Extrabackup and configure incremental backup database remotely from 3 windows server.
  4. And put the database backup file in network drive.

Anyone already did this?

2

The XtraBackup is designed to work only from the same host where the mysqld process is running, and unfortunately it cannot be a Windows machine. So, either migrate the database host to Linux or use other tools, like mydumper for instance.