Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [xtrabackup]

66 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
9
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
  • 979
  • 2
  • 12
  • 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

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
  • 51
  • 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
  • 7
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
  • 7
  • 19
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
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
  • 1
  • 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
  • 6
3
votes
2 answers

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 servers with innobackupexec (since i only use…
x86fantini
  • 131
  • 1
  • 3
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

xtrabackup backup grants?

I'm using MySQL 5.5 + Opensuse 12.3 . After face an issue with mysqldump (appear be a bug with OpenSuse Mysql distribution) I have looking for others backup solution. I found the xtrabackup from percona which is very nice solution . I tested it with…
ceinmart
  • 383
  • 1
  • 4
  • 20
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
  • 933
  • 2
  • 10
  • 21
1
2 3 4 5