Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [xtrabackup]

XtraBackup : Percona's Open Source Backup Software

Percona XtraBackup is the world's only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits:

  • Backups that complete quickly and reliably
  • Uninterrupted transaction processing during backups
  • Savings on disk space and network bandwidth
  • Automatic backup verification
  • Higher uptime due to faster restore time

XtraBackup essentially performs rsync-style copying of InnoDB data and transaction log files. After performs the copying several times, it performs an in-place InnoDB crash recovery to build reliable, usable, safe copies of InnoDB. There are also other options to do incremental backups, streaming backups, slave server creation, and more.

27 questions
0
votes
0 answers

Why does Mariabackup think my compressed table is corrupted?

I've got a MariaDB database (version 10.2) that I'm attempting to back up with Mariabackup (the official fork of Percona's XtraBackup). Both the DB server and the backup tool are installed from the MariaDB Ubuntu repository for 10.2. After moving…
Cassie Meharry
  • 165
  • 9
0
votes
2 answers

Fastest way to move Innodb database from one server to another

I understand I can use mysqldump or xtrabackup to move InnoDB from one db to another. Considering I am okay with server down time, are there better way to move InnoDB database? I have tried copying all "ib_*" files and seems does not work. Are there…
Ryan
  • 5,341
  • 21
  • 71
  • 87
0
votes
1 answer

How to recover Galera cluster node

I'm running a three node, multi-master Galera cluster under MariaDB. One of the nodes has crashed due to a hardware fault (node3) and for whatever reason this crashed one of the healthy nodes too (node2). So I'm left with one running node (node1)…
Tim
  • 554
  • 2
  • 9
  • 20
0
votes
4 answers

mysql (Perconadb) Galera/Xtrabackup cluster join fails with "Invalid Argument"

I have a MySQL Galera cluster, using Perconadb and Xtrabackup. The nodes can start stand-alone, or can join the cluster if only an IST is required. However, if an SST is required, then this runs to completion and then fails. The logs show that,…
Steve Shipway
  • 742
  • 5
  • 17
0
votes
0 answers

xtrabackup: too many open files (more than 1048576)

When using xtrabackup to backup a mysql database with lots of tables, the proces fails with Error 24: ‘Too many open files’. This is a FAQ on the Percona website:…
svdr
  • 31
  • 4
0
votes
0 answers

Need to do partial restore from a full xtrabackup

I'm using percona xtrabackup to do full DB backups on mariadb 10 and now i'm testing the restore. I want to restore just some databases (the important DBs) and ignore others (big archive DBs), simulation a total DB lost to check how much time i…
higuita
  • 1,093
  • 9
  • 13
0
votes
1 answer

Why does XtraBackup tell me my MySQL database is corrupt?

I am trying to backup data on a MySQL Galera node with XtraBackup. Unfortunatelly the tool tells me, that ibdata1 is corrupt. After double checking I indeed found some myisam tables I have importet by error. Droped those and replaced them by innodb…
merlin
  • 2,033
  • 11
  • 37
  • 72
0
votes
1 answer

XtraBackup restore gives duplicates on slaving?

We've recently upgraded a MySQL 5.0 master-master setup to Percona 5.6. Slaving went b0rken due to some failures on our side, but we thought we could simply fix it by using xtrabackup to create a backup from the running server and importing it to…
Tim Stoop
  • 578
  • 5
  • 19
0
votes
4 answers

Percona-xtrabackup hot backup issue with MyIsam Engine

We are running with the MyIsam Engine and Percona-xtrabackup is throwing the following error as the inndb engine is skipped [ my.cnf skip-innodb]. How could I resolve this issue with out enabling the inndb engine? percona-xtrabackup-2.0.0/bin:#…
arn
  • 91
  • 2
  • 7
0
votes
0 answers

how to take mysql xtrabackup to a remote server

I have a server running with mysql with huge db of 1 TB. Now, I want to take full backup through percona xtra backup, because incremental backup is easy with percona xtrabackup. Now,if I initiate taking backup in that server,storage is getting…
Ravi Teja RVN
  • 1
  • 2
-1
votes
1 answer

Port setting not used in my.cnf

I'm trying to store the credentials for the Percona XtraBackup tool in the /etc/my.cnf file as follows: [xtrabackup] target-dir=/backup user=root password=[password] host=[local ip] port=12345 When running: extrabackup --backup /backup I…
Michael Zukowski
  • 109
  • 6
-1
votes
1 answer

Restore InnoDB to different machine

I currently have backups that were taken with Percona XtraBackup of all my mySQL databases. My specific scenario is that I want to restore a month old InnoDB database snapshot to my local machine for testing but I can't seem to find instructions for…
user67435
  • 99
1
2