Shulou(Shulou.com)05/31 Report--

Editor to share with you how to use Xtrabackup remote backup Mysql, I hope you will learn something after reading this article, let's discuss it together!

The remote backup of Xtrabackup is to send the backup to standard output and then to the remote server.

First, configure the SSH key locally in the database and pass it to the remote backup destination, eliminating the need to enter a password each time.

Ssh-keygenssh-copy-id-I root@mysql2

Run locally in the database

Innobackupex-defaults-file=/etc/my.cnf-user root-password mysql1-stream=tar. / | ssh "cat root@mysql2-> / backup/mysql1.tar"

Backup will occupy the bandwidth of the network port, which will affect the normal access. Therefore, it is best to use other network ports for remote backup.

After reading this article, I believe you have a certain understanding of "how to use Xtrabackup remote backup Mysql". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.