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
5
votes
1 answer

MySQL: How to backup and restore using different schema name using xtrabackup

I very often need to create a backup of a database and import it using a different schema name. These schema's are pretty large (3-5GB) and mysqldump is a pain. xtrabackup seems promising but I cannot find how to import a backup using a different…
John
  • 51
  • 2
4
votes
2 answers

Can I run Percona xtrabackup on my desktop?

I have successfull running xtracbackup on the db server, but I really want to run the backup on the other machine (not the machine that have the MySQL running). I try to run the xtrabackup tool on my desktop given the host/port options but getting…
nvcnvn
  • 257
  • 1
  • 2
  • 7
4
votes
2 answers

APT: Public Key is missing? How to fix?

I updated my sources.list with deb http://repo.percona.com/apt squeeze main deb-src http://repo.percona.com/apt squeeze main And called gpg --keyserver subkeys.pgp.net --recv-keys 1C4CBDCDCD2EFD2A The Result was, that it seemed to import…
manamix
  • 43
  • 1
  • 3
3
votes
1 answer

MariaDB, Galera, xtrabackup - do I need the binary log?

We are using a MariaDB Galera Cluster with 3 nodes. For the state transfer we are using xtrabackup. We have some problems with the binary logs - they got too big and crashed the server. We can remove them manually with the purge binary logs…
bernhardrusch
  • 175
  • 1
  • 9
2
votes
1 answer

Galera Cluster starting backup can't find innobackupex in the path

I am trying to get a Galera cluster running. I have the first node up and ready for connections. My second node, however, when trying to run wsrep_sst_xtrabackup gets the error "Can't find innobackupex in the path". As soon as I start the mysql…
nwalke
  • 643
  • 2
  • 12
  • 31
2
votes
1 answer

XtraBackup for SST with Xtradb cluster

I'm looking for some instructions/manual to set Percona Xtradb cluster with Xtrabackup for SST. Is there any configuration file where I need to provide login details for Xtrabackup script? Thanks
HTF
  • 3,050
  • 14
  • 49
  • 78
2
votes
0 answers

MySQL Enterprise Backup GUI (or a live backup alternative)

I am looking into MySQL Enterprise backup solution. I am interested in a non-blocking mysql backup (live and incremental). MySQL Enterprise provides this solution (we have the subscription already). But from what I see it's only a console…
geoaxis
  • 451
  • 1
  • 6
  • 17
2
votes
2 answers

How to create a SQL dump from the MySQL database files

I am using Percona's xtrabackup to take backup of my online databases. Is there a way to convert the backup database files into a SQL dump similar to a backup created using mysqldump ?
Supratik
  • 2,104
  • 10
  • 49
  • 66
1
vote
0 answers

What is the alternative for innodb_track_changed_pages in Debian 10/MariaDB 10.3

So we have been using Debian 9 with MariaDB 10.1. For faster backups (total DB size across three DBs is > 1TB) we have enabled innodb_track_changed_pages. However, that feature has gone away on MariaDB 10.3 because they changed (back) from XtraDB to…
Stefan Seidel
  • 732
  • 1
  • 7
  • 20
1
vote
1 answer

Backing up a single database with mariabackup?

I've been working on redoing our database backup routines, and have looked into mariabackup as mysqldump doesn't cut it anymore given the size of our schemas. We have multiple schemas that need to be backed up - they all vary in size, and they also…
KevinP
  • 11
  • 1
  • 3
1
vote
3 answers

How to speed up final stage of xtrabackup with lots of tables?

I have a MySQL 5.5 database with thousands of tables and heavy write workload. I need to use xtrabackup to take online backup (create a slave from production server with minimum downtime), but the problem is that final stage of backup (when it…
Deinlandel
  • 121
  • 6
1
vote
1 answer

MariaDB Galera replication under Vagrant

I'm provisioning a Galera MySQL cluster under Vagrant using a multi machine VagrantFile. I don't believe the issue lies with Vagrant Vagrant Version VagrantFile Vagrant.configure(2) do |config| config.vm.box = "ubuntu/trusty64" …
georgealton
  • 136
  • 6
1
vote
1 answer

MariaDB Galera SST Fails

I am running a 3 node MariaDB 10 Galera Cluster on CentOS 6. I have use this set-up before without issue else where but now when adding a 3rd node the SST fails with this error in the logs: 150212 18:03:02 [Warning] WSREP: 1.0 (server1.example.com):…
kemra102
  • 211
  • 4
  • 12
1
vote
1 answer

installing XtraBackup with libmysqlclient.so.18

Current situation I'd like to install XtraBackup on my VPS (Centos 5) where my main database is running. During the rpm install it told me that it misses a dependency called perl(DBD::mysql). When I try to yum install that dependency, it tells me…
Martin
  • 177
  • 2
  • 10
1
vote
1 answer

Issue with percona-xtrabackup-2.0.0 hotbackup on MyIsam tables

I am trying to implement hot backup for MyIsam tables with "percona-xtrabackup-2.0.0" and getting the following error? As the all tables are MyIsam I doubt am I using the correct package ? Backup : ./innobackupex --user="root" --password=***…
arn
  • 91
  • 2
  • 7
1
2