Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [xtrabackup]

68 questions
34
votes
3 answers

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. Currently it does not appear that Amazon…
Peter Stephens
  • 443
  • 1
  • 4
  • 6
8
votes
1 answer

Is Percona xtrabackup the right choice for my 500GB MySQL backup?

I have a MySQL db with 500GB, consisting mainly of Innodb tables, and one big (200GB) MyISAM table. My current backup strategy is copying the db files to an external harddrive. This causes a downtime of ~4hrs. My Needs: Low cost. Recovery time…
Noam
  • 889
  • 2
  • 11
  • 24
5
votes
2 answers

Which hot backup tools for MySQL InnoDB database : Percona XtraBackup, Zmanda Recovery Manager Enterprise or Community or…?

I manage a PHP/MySQL website : max 500 simultaneous users / average of 4000 per hour in update/read 1 MySQL Community Server (5.1) - (Xeon / 16 Go RAM) InnoDB Storage engine on 100 tables for 1.4 Go of data Actually, every 30mn a cronjob make a…
Grey Goda
  • 51
  • 1
  • 2
5
votes
1 answer

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.db It succeeds creating the hot backup. Now I want…
user1623521
  • 159
  • 1
  • 6
5
votes
2 answers

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 brought up on an existing master without the need to…
oucil
  • 506
  • 2
  • 6
  • 18
4
votes
1 answer

Backing up a 400-500 GB database on MySQL/Amazon RDS?

We have an Amazon RDS small instance for a MySQL datawarehousing database. Database size will be around 400-500 GB very shortly. What is the best way to backup our database? Can it be done efficiently with automatic backups and DB snapshots…
user2063699
  • 41
  • 1
4
votes
1 answer

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 this is the best place. I have this command,…
Thantanenorn
  • 41
  • 1
4
votes
2 answers

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 using innodb tables so it will be good to restore…
Haohmaru
  • 145
  • 7
3
votes
1 answer

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 achieved it using the mysql_import but it takes 3 ~…
sf_tristanb
  • 175
  • 5
3
votes
1 answer

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 environment on Jelastic). The binary backup was done…
WooDzu
  • 145
  • 2
  • 8
3
votes
2 answers

Can I use a Percona Xtrabackup backup to restore a single table?

I've been playing around with the Xtrabackup tool for a month now, and I got to admit : it is really powerful ! I'm still testing it to backup database servers between 5 and 150 GB and the backup/restoration time are impressive. So I'm trying to…
Tony
  • 141
  • 1
  • 6
3
votes
2 answers

Percona Xtrabackup on Suse EL 10 -- Failing

I have evaluated Percona Xtrabackup successfully and it works like a charm on my several CentOS / RHEL servers! Hats off to the team! But my problem starts when I tried to install this on one of my client's Suse EL 10 server. I believe Xtrabackup is…
Asim Ahmed
  • 31
  • 1
3
votes
1 answer

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 information in the Log(posting One day Log…
Gopinath Karangula
  • 843
  • 2
  • 10
  • 18
3
votes
1 answer

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 is log sequence number ? How it is used in…
Josefine
  • 2,158
  • 3
  • 28
  • 55
3
votes
1 answer

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 the same setup (aside from a slight version…
matthewrk
  • 81
  • 5
1
2 3 4 5