All Questions
Tagged with percona-tools backup
14 questions
0
votes
0
answers
26
views
Percona xtrabackup and percona toolkit for aarch64 Graviton Amazon Linux 2 machines
In my organisation, it was decided to move all the MySQL infrastructure (Amazon EC2 machines) to Graviton (aarch64) servers from AMD (x86_64).
All are MySQL Community Servers.
I need percona-...
- 226
0
votes
0
answers
55
views
Percona XtraBackup questions about full and incremental backups
I had a few questions on the Percona forum, and I'm unsure if I was being clear in my questions or not, however I'm curious how full and incremental backups work with XtraBackup.
When doing ...
- 1
1
vote
1
answer
253
views
Incremental encrypted per database backup and Partial restore policy for MySQL 5.7 in replication setup
I will run a replication cluster using MySQL 5.7 and I would like to set up for each database a backup policy that has a full once per day + incremental every N hours with data encrypted (based on the ...
0
votes
1
answer
757
views
Downgrade MySQL 8.0.20 to 8.0.19 on Ubuntu for using XtraBackup
With MySQL 8.0.20 currently installed on Ubuntu, I am unable to use Percona XtraBackup 2.3.7 due to breaking changes introduced in MySQL 8.0.20.
How can we downgrade MySQL 8.0.20 to 8.0.19 on Ubuntu, ...
- 143
0
votes
1
answer
572
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 --...
- 172
2
votes
1
answer
2k
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 \
...
- 121
1
vote
2
answers
243
views
MYSQL DATABASE BACKUP
Currently my backup strategy invloves :-
1)I have one master server and two slaves (Data approximately 700 GBs and tables are of mixed innodb and myisam).
2)I take weekly and monthly backup from ...
- 47
5
votes
1
answer
5k
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....
- 159
2
votes
1
answer
2k
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: ...
- 23
4
votes
2
answers
3k
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 ...
- 145
1
vote
1
answer
1k
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 ...
- 35
2
votes
1
answer
3k
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 ...
- 35
2
votes
3
answers
2k
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 ...
- 23
5
votes
2
answers
6k
views
Which hot backup tools for MySQL InnoDB database : Percona XtraBackup, Zmanda Recovery Manager Enterprise or Community or…? [closed]
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 ...
- 51