Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [xtrabackup]

XtraBackup : Percona's Open Source Backup Software

0
votes
1answer
19 views

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 ...
0
votes
1answer
330 views

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 (...
0
votes
0answers
26 views

File cannot be read - Configure MySQL Backups with Percona XtraBackup

I'm following this Digital Ocean guide on creating MySQL backups with Percona xtrabackup. My only difference in setup to the guide is that I'm using Ubuntu 18.04. I had incremental and full backups ...
0
votes
4answers
200 views

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 ...
1
vote
1answer
1k views

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 ...
1
vote
3answers
229 views

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 ...
-1
votes
1answer
92 views

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 ...
0
votes
0answers
319 views

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: https://www.percona.com/doc/percona-...
1
vote
1answer
214 views

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| ...
0
votes
0answers
851 views

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), ...
0
votes
1answer
696 views

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 ...
0
votes
1answer
360 views

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 ...
2
votes
2answers
470 views

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 ...
1
vote
1answer
2k views

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:...
0
votes
1answer
219 views

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 ...
3
votes
1answer
4k views

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 ...
1
vote
1answer
2k views

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 ...
2
votes
1answer
247 views

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 ...
0
votes
4answers
2k views

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 ...
1
vote
1answer
489 views

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 :...
1
vote
1answer
1k views

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
4
votes
2answers
8k views

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 ...
4
votes
1answer
2k views

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 ...
2
votes
0answers
732 views

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). ...
2
votes
2answers
2k views

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 ?