Questions tagged [xtrabackup]
XtraBackup : Percona's Open Source Backup Software
29
questions
0
votes
0
answers
13
views
xtrabackup - copying my.cnf file from source to replica when there are different linux distros on source and replica
https://docs.percona.com/percona-xtrabackup/innovation-release/set-up-replication.html#3-configure-the-sources-mysql-server
4. Configure the Replica’s MySQL server
Copy the my.cnf file from the Source ...
- 113
0
votes
0
answers
55
views
Installing XtraBackup on Centos 6
I’m trying to install XtraBackup on centos 6 using this guid but i get these errors:
Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (C6.10-base)
Requires: libmysqlclient.so.16()(64bit)
Error: ...
- 99
0
votes
1
answer
445
views
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 ...
1
vote
0
answers
120
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 ...
- 732
0
votes
0
answers
844
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 ...
- 165
0
votes
2
answers
453
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 ...
- 6,041
0
votes
1
answer
7k
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 (...
- 594
0
votes
4
answers
2k
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 ...
- 775
2
votes
1
answer
5k
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 ...
- 21
1
vote
3
answers
1k
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 ...
- 121
-1
votes
1
answer
538
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 ...
- 109
0
votes
0
answers
738
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-...
- 31
1
vote
1
answer
420
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|
...
- 136
0
votes
0
answers
1k
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), ...
- 1,243
0
votes
1
answer
2k
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 ...
- 2,172
0
votes
1
answer
505
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 ...
- 598
4
votes
2
answers
1k
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 ...
- 257
1
vote
1
answer
3k
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:...
- 211
-1
votes
1
answer
711
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 ...
- 99
3
votes
1
answer
5k
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 ...
- 175
1
vote
1
answer
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 ...
- 177
2
votes
1
answer
411
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 ...
- 643
0
votes
4
answers
3k
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 ...
- 91
1
vote
1
answer
524
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 :...
- 91
2
votes
1
answer
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
- 3,198
4
votes
2
answers
10k
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
...
- 43
5
votes
1
answer
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 ...
- 51
2
votes
0
answers
777
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). ...
- 511
2
votes
2
answers
3k
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 ?
- 2,174