Questions tagged [xtrabackup]

XtraBackup : Percona's Open Source Backup Utility

Filter by
Sorted by
Tagged with
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
11 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 ...
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 ...
0
votes
0answers
9 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
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
vote
2answers
3k views

ib_logfile0 and ib_logfile1 got deleted

After restoring from a percona-xtrabackup without a preparation step, ib_logfile0 and ib_logfile1 were not present in the restore data. Therefor during startup the following message is observed: ...
1
vote
2answers
825 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
1answer
525 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
1answer
225 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
1answer
183 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 --...
1
vote
1answer
291 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 ...
0
votes
1answer
130 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
0answers
35 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
68 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 ...
2
votes
1answer
267 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
0answers
122 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
725 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
555 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 -...
2
votes
0answers
441 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 ...
2
votes
3answers
1k views

xtrabackup prepare - after dump or before restore?

i have doubts about xtrabackup --apply-log. is there any difference when use it? should it be done right after dump or before restore (even few months later)? seems stupid, but maybe i missing ...
1
vote
1answer
575 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
572 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
948 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 ...
2
votes
1answer
959 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: ...
1
vote
1answer
962 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
2answers
625 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 ...
2
votes
1answer
719 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 ...
1
vote
1answer
508 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 \ ...
31
votes
3answers
41k views

What is the recommended way to backup a MySQL/Amazon RDS database to S3?

I have two purposes for this: To have an offsite backup in case of a region wide problem with Amazon Web Services. To copy production data from a production billing account to a beta billing account. ...
2
votes
2answers
4k views

Best option to back up mysql innodb partition

We have a number of tables which we plan to partition based on months. The issue now before we can drop those partition we would like to perform backup. One option we found is this link http://www....
3
votes
1answer
601 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
601 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
258 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....
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:/...
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 ...
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
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 ...
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
1answer
357 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....
3
votes
1answer
682 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 ...
0
votes
1answer
684 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
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
600 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
138 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 ...
3
votes
1answer
343 views

innobackupex is failing while exporting backup

I am using perl script which is working fine in one of my other box which used to take individual schema backups & finally take all schema together using percona innobackupex. I have following ...
1
vote
1answer
4k views

Is it safe to use mysqldump to backup and restore a master-master cluster

Not sure if the specifics matter but just to get it out of the way I am talking about a Galera cluster on XtraDB (MariaDB). I have a master-master setup and am interested in backing up and restoring ...
4
votes
2answers
894 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
363 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 ...