The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [xtrabackup]

XtraBackup : Percona's Open Source Backup Utility

Filter by
Sorted by
Tagged with
0
votes
0answers
4 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
27 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
52 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 ...
1
vote
1answer
204 views

mariabackup of database running in docker

I have MariaDB running in a Docker container with the container's data directory /var/lib/mysql/ mapped to the host directory /mnt/data/. I want to run mariabackup from the host to create a physical ...
0
votes
0answers
103 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 ...
2
votes
1answer
239 views

Using mariabackup/xtrabackup vs block level snapshots

I am running a mariadb 10.1 instance with all innodb tables and a replication slave in a k8s cluster on Google Cloud's GKE. I have a scheduled mysqldump that runs every night. But for additional ...
0
votes
1answer
173 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
121 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-...
1
vote
1answer
541 views

What is a LSN (log sequence number)? How does xtrabackup Incremental Backup work?

I was surprised that xtrabackup supports incremental backups. xtrabackup copies the data files and understand the format of data files (can have a look inside)? What is a LSN for dummies? I found What ...
1
vote
2answers
541 views

Mysql backup of remote server in local machine using percona xtrabackup

I had asked this question in serverfault.Later, i came to know about this site. I have percona xtrabackup installed in my ubuntu client machine. My local machine IP address is 192.168.0.100. The ...
1
vote
1answer
907 views

Using xtrabackup-v2 as SST method in MariaDB Galera cluster

I have configured mariadb galera cluster as docker swarm service using official docker image: during cluster startup rsync (default SST method) works fine. Wanted to change it to xtrabackup or ...
1
vote
2answers
781 views

Restoring XtraBackup from MySQL 5.6 to MySQL 5.7

We are running MySQL 5.6 and taking backups using XtraBackup 2.4. We want to migrate to MySQL 5.7 using that same backup as we have datasets well over 600GB. Is it possible to do so and what are ...
2
votes
0answers
425 views

Full database backup using xtrabackup stream

I'm new to Percona XtraBackup. I've been trying to perform a full backup stream from my local ( test server around 600GB ) to remote server. I just have some questions and I need guides, and I think ...
1
vote
1answer
933 views

SST not starting on a new node on MariaDB Galera Cluster

I have two MariaDB servers I want to use to create a new MariaDB Galera Cluster: Server mysql1, with some data and configured as a donor Server mysql2, with no data and /var/lib/mysql empty, which I ...
1
vote
1answer
482 views

xb_stream_read_chunk(): wrong chunk magic at offset 0x0

I have taken a backup of mysql instance like this innobackupex \ --user=$MYUSER \ --password=$MYPASS \ --no-timestamp \ --parallel=$DUMP_THREADS \ --stream=xbstream \ --slave-info \ ...
3
votes
1answer
587 views

Percona xtrabackup transaction log corrupted

I am attempting to prepare and restore a full backup taken through xtrabackup via a scheduling script called surrogate. I have tarred and gzipped the backup, transferred to a local machine running ...
1
vote
1answer
582 views

Restoring Individual MyISAM Tables

I'm using Xtrabackup to perform a MySQL DB restore. I found some problems when I'm trying to restore individual tables: tables with InnoDB engine can be restored without any problem but I can't find ...
0
votes
2answers
254 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....
2
votes
1answer
516 views

Percona MySQL 5.7 | XtraBackup 2.4 - xb_load_tablespaces() failed witherror code 11

I am attempting to upgrade MySQL from 5.6 to 5.7 and everything seems to be working, but when I try to run xtrabackup I am now getting this error: InnoDB: Allocated tablespace ID 12 for percona/...
1
vote
2answers
600 views

MySQL restore only Incremental backups with innobackupex

I am migrating a product to AWS and we have 1.5TB of MySQL database. I want to migrate it to AWS with minimum downtime possible. I am planning to achieve following. Take one full backup with Percona ...
1
vote
1answer
288 views

IMPORT TABLESPACE is hanging in the 'System lock' state

We have a development database server with Percona-server 5.7.15-9 on it. It replicates two schemas from two different production servers using multi-source GTID replication. Lets call these schemas ...
1
vote
1answer
2k views

“No valid checkpoint found” when restoring xtrabackup

I have a cluster of MariaDB 10.1 servers, master/master with one node acting as arbitrator and incremental backups with xtrabackup. This is how I've pieced it together from the docs. Master01 does ...
0
votes
1answer
704 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
548 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
337 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 ...
4
votes
1answer
3k views

Percona: Backup preparation doesn't work (“cannot open ./xtrabackup_logfile”)

I've created a MySQL backup with PerconaXtrabackup tool via (thanks to this guide): innobackupex --user=backupmysqluser --password=xyz --compress --stream=xbstream ./ > /var/backups/db/firstBackup....
2
votes
1answer
709 views

MySql How to rollback my database to a certain point in time the fastest way?

I'm currently working in a testing database and we are not cleaning up after test because of our current configuration and we probably aren't changing that configuration soon, we are currently using a ...
3
votes
1answer
667 views

MySQL applying second incremental backup causes LSN in the ibdata files to be higher than LSN in the ib_logfiles

Using the backup procedure described below, it gives warnings. These warnings start to appear from the 2nd till 6th (last) incremental backup that is being applied to the base backup. How to solve ...
1
vote
1answer
196 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 ...
0
votes
1answer
668 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.
2
votes
1answer
929 views

Is there a non-blocking operation to back up MyISAM tables using Percona XtraBackup?

I've been reading through the website of Percona XtraBackup and it claims that: Percona XtraBackup can back up the following storage engines by briefly pausing writes at the end of the backup: ...
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 ...
5
votes
2answers
595 views

Is there a way to create a MySQL/Percona Slave without using a dump?

I haven't been able to find anything so I'm sure the answer is no, what are you, a noob? but I feel the need to ask anyway :) Is there a simple utility that would allow a new slave server to be ...
0
votes
2answers
136 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 ...
1
vote
1answer
1k views

How to recover performance_schema after restoring from partial innobackupex backup?

I am taking a partial backup from a Master server, which needs to be restored on a to-be slave server. I only need one of the databases, and the mysql database. I am following instructions on https:/...
4
votes
2answers
881 views

Is it possible to backup stored routines and functions with Innobackupex?

I am running a few restore tests on my Dev and I've noticed that the stored routines are not being restored with the innobackupx. Is that something achievable ? Am I doing something wrong ? I am only ...
1
vote
0answers
307 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 ...
2
votes
1answer
360 views

Innobackupex apply-log should be done before emergency restore or after each backup?

Basically Percona Innobackupex consist with three steps: 1. Backup 2. Apply log 3. Copy back restore during emergency My question: When should I do apply log? Is it after each backup or before ...
1
vote
1answer
106 views

Installed Percona-Toolkit, but no sign of xtrabackup

I've installed Percona-Toolkit on my Debian (Wheezy) test Server, using dpkg -i percona-toolkit.deb apt-get install --fix-missing -f dpkg -i percona-toolkit.deb However, there is no sign of ...
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 ...
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 ...
1
vote
1answer
195 views

Percona: Do I need apply-log switch for a weekly full backup and hourly incremental?

I am planning a script to work on our percona. Our strategy is to do full backup weekly but incremental backups every day/hour. I have read innobackupex manual and got confused further as to whether I ...
1
vote
2answers
56 views

is it possible to get innobackupex to print the filenames it's busy with?

I am getting crashes when trying to run innobackupex --apply-log. How can I find out what files it's processing at the time? I don't see a relevant option mentioned in the documentation.
3
votes
1answer
857 views

Can I use xtrabackup to import a database without altering others?

Context: Each time a demo branch is built, I want to download a copy of the prod database and setup it onto the demo server. This way under the MySQL I have X database corresponding to X demos. I ...
1
vote
1answer
440 views

Is there a difference between an xtrabackup taken with and without --safe-slave-backup?

Currently I'm studying Percona's xtrabackup. In the manual in the paragraph "Taking Backups in Replication Environments" it says that using the --safe-slave-backup option is always recommended and I ...
2
votes
1answer
2k views

Percona's xtrabackup --apply-log fails with “all log files must be created at the same time”

I'm trying to figure out why applying logs on my xtrabackup files isn't working. I created a VM running MySQL 5.5.24. Then I created the sakila test database and backed it up with the following ...
1
vote
1answer
10k views

MySQL my.cnf: innodb_log_file_size is missing

How to set innodb_log_file_size to MySQL database if there is no innodb_log_file_size in my.cnf configuration file? I'd like to backup via Percona Xtrabackup and the backup crashes at this point ...
2
votes
2answers
2k views

Is it necessary to run apply-log immediately after innobackupexec has run?

i have been trying to read other questions, but i did not find a answer to suit me. So excuse me if i ask something that has been already asked. I'm trying to organize my self and backup all my mysql ...
2
votes
2answers
4k 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 ...
2
votes
1answer
3k views

InnoDB: “Only one log file found” after binary import

My first one on DBA... After successful upgrading a master MySQL server 5.5 to 5.6.17 (CentOS 6 VPS serer), I done and moved my binary backups to a slave server (same version 5.6.17 but different ...