Questions tagged [xtrabackup]

XtraBackup : Percona's Open Source Backup Software

Filter by
Sorted by
Tagged with
1
vote
0answers
41 views

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

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 ...
0
votes
1answer
83 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
2k 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
4answers
514 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
2k 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
465 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
146 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
444 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
263 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
986 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
1k 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
380 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
580 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
376 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
306 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
493 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
9k 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
759 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 ?