Questions tagged [xtrabackup]

XtraBackup : Percona's Open Source Backup Utility

Filter by
Sorted by
Tagged with
1
vote
1answer
198 views

Replicating into a Percona XtraDB Cluster

We have a 2 node (plus an arbiter) Percona XtraDB cluster. It is used for data indexing/archiving. It has it's own database called archive but it is also the replication slave for a database called ...
1
vote
0answers
311 views

Innobackupex restore steps from 1 incremental and multiple incremental steps

My current backup plan is: Full -> Incremental1 based on full -> incremental2 based on incremental1 -> incremental3 based on incremental2... Please validate if this steps is correct during emergency ...
1
vote
1answer
819 views

Unable to take backup of mysql database using Xtrabackup

I am trying to take mysql backup without any downtime but unable to take the backup using Xtrabackup . Actual Database is almost about 40+ GB in size. I am trying to first satisfy myself. Hence, I ...
0
votes
1answer
698 views

How password can be prompted in percona xtrabackup

How password can be prompted while using percona xtrabackup.--ask-pass option is not working with xtrabackup. Thanks in advance.
0
votes
1answer
560 views

Percona Xtrabackup (Partial + incremental)

we have been trying restore Percona (Partial + Incremental) mysql backup, but failing. The process followed is as below: For Backup # Step I: Take Partial-Full Backup innobackupex --user=root -...
0
votes
1answer
375 views

XtraBackup Restore Full Backup OK but I can't initialize mysqld

I'm using XtraBackup mode Streaming and Compressing Backups to perform my backup on a MariaDB 10.19: $ innobackupex --user=$db_user --password=$db_pass --compact --stream=tar ./ --no-timestamp | gzip ...
0
votes
1answer
46 views

Tools for working with xtrabackup files?

I have database backups in xtrabackup format. I would like to load them into hive without restoring to a mysql instance and use sqoop to then do the transfer. If there are libraries to work with the ...
0
votes
2answers
141 views

at the moment mysqldump (22 minutes exec time, 5 GB Dump), when to use xtrabackup?

We use the Puppet code for deploying MariaDB. Those are the backup options. mysql::backup::mysqldump: Implements mysqldump backups. mysql::backup::mysqlbackup: Implements backups with Oracle MySQL ...
0
votes
1answer
1k views

Mariadb Galera Cluster using Xtradb backup is not working

I am trying out the first test of MariaDB Galera cluster setup without success. This is the error in the log innobackupex: Created backup directory /tmp tar: -: Cannot write: Broken pipe tar: Error ...
0
votes
0answers
20 views

Error importing MySQL/Percon server tablespace for individual tables

I am using Percona-Server 8.0.x and I am following percona xtraback documentation. https://www.percona.com/doc/percona-xtrabackup/8.0/xtrabackup_bin/restoring_individual_tables.html I am exporting ...
0
votes
0answers
7 views

How to correctly have binary logs stored…Mysql/Maria

So I'm taking a full backup at 12AM each day. At 2,4,6,8,10etc etc I'm taking incrementals. Using Mariadb and maraibackup... At each point I want to flush and purge the logs so I don't have to ...
0
votes
0answers
12 views

Restoring an individual table with Xtrabackup to the same server

I have a 3 node Mariadb Galera cluster running. Each node is running Mariadb 10.2.15 (mysql Ver 15.1 Distrib 10.2.15-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2) with Xtrabackup version ...
0
votes
0answers
20 views

Does mysqlfrm work with partitioned tables?

I have inherited a large number of backups (MySQL 5.5) created with innobackupex as partial backups. In order to restore one of them, I have to do it table by table; as part of this process, I need to ...
0
votes
0answers
52 views

how to restore partial-backup created using xtrabackup

I had to take a backup of a single database in my MySQL server of size 2.4 TB. I used percona xtrabackup as mysqldump was taking forever. I used below command for it: xtrabackup --backup -u user -p ...
0
votes
1answer
83 views

Make Xtrabackup ignore myisam tables & backup only innoDB tables?

I'm using mysql 5.7 (or rather percona 5.7) Is it possible to backup only the innodb tables (easily, not to specify each table one by one because I have a lot of tables) with xtrabackup? and not take ...
0
votes
0answers
140 views

MySQL InnoDb crash when importing tablespace from remote machine

InnoDB crashes when importing ibd file from remote machine. Source version is MySQL-5.6.40, Destination version is MySQL-5.6.40. Database was backed up was backed Percona Xtrabackup with xbstream ...
0
votes
1answer
186 views

Percona Xtrabackup fails to backup InnoDB table with fulltext index

I'm trying to make a backup of a large InnoDB table with a fulltext index using Percona Xtrabackup (2.4.12). I have innodb_file_per_table set. To create the backup, I'm running: innobackupex --...
0
votes
1answer
144 views

ERROR: please confirm the keyfile is match and keyring plugin is loaded

I want to create a copy of my Production DB to a new instance. There is a innobackupex running on the prod every night looks like this: innobackupex --user=username --password=password --keyring-...
0
votes
2answers
259 views

Is it possible to backup and restore InnoDB tables on Oracle's MySQL 5.7.19 Server with Percona Xtrabackup?

I have the next configuration: OS: Ubuntu 16.04.2 x86_64 MySQL Server: Ver 5.7.19-0ubuntu0.16.04.1 for Linux on x86_64 ((Ubuntu)) installed from Ubuntu's repos Percona Tools: innobackupex version 2....
0
votes
1answer
741 views

Which version of xtrabackup to use with MySQL 5.5?

I've just installed a copy of Percona xtrabackup onto my Debian (jessie) server, but when I run it it says that it is: innobackupex version 2.3.5 based on MySQL server 5.6.24 Linux (x86_64) (revision ...
0
votes
1answer
253 views

Does Percona Xtrabackup support RedHat release 4

I downloaded Percona's Xtrabackup rpm file for RedHAT. I attempted to install but hit into an error. The error seems to point to missing dependencies and libraries. I have no issue with RedHat 6 OS. I ...
-1
votes
1answer
1k views

mysql xtrabackup missing binary logs

It seems xtrabackup is not backing up binary logs, although it creates xtrabackup_binlog* with apparently correct information inside. Should the binary logs be copied manually beforehand or is this a ...