5 votes

APT: Public Key is missing? How to fix?

The key is also directly available from the Percona website. Import it as following: wget -O - http://www.percona.com/redir/downloads/RPM-GPG-KEY-percona | gpg --import gpg --armor --export ...
user avatar
  • 101
4 votes
Accepted

Can I run Percona xtrabackup on my desktop?

No, you can't run it on another machine, as it reads the data files directly, not via the mysql server process. However, you can mount disk space of another machine on the database host and use this ...
user avatar
  • 96.4k
3 votes
Accepted

MariaDB, Galera, xtrabackup - do I need the binary log?

Galera Cluster by itself does NOT need binary logging enabled. The question is more what happens when you run a bad Query (for example UPDATE employee SET salary = 0 ; WHERE id = 42;). For this ...
user avatar
  • 61
2 votes

Fastest way to move Innodb database from one server to another

For anyone wondering, Copying the entire mysql data root (in my case) /var/lib/mysql AFTER shutting down mysqld worked perfectly to migrate data to another system. Otherwise if you need replication ...
user avatar
1 vote

How to recover Galera cluster node

Solved. The crashed node was configured to use a different SST method to the donor node. It previously used Percona xtrabackup and through accident or stupidity the configs were out of date.
user avatar
  • 544
1 vote

How to speed up final stage of xtrabackup with lots of tables?

Use the --rsync parameter. Surprisingly, it IS available on xtrabackup, despite it not appearing anywhere on the Percona XtraBackup 2.4 Documentation as of this writting. The documentation that is ...
user avatar
1 vote
Accepted

How to speed up final stage of xtrabackup with lots of tables?

Answering for posterity. Innobackupex with --rsync did the trick. It reduced lock time to seconds.
user avatar
1 vote

How to speed up final stage of xtrabackup with lots of tables?

There is a --no-lock option, however you can only use it if you don't have writable non-InnoDB tables and if you don't care about binlog position. If you can't use --no-lock I would suggest to setup ...
user avatar
1 vote
Accepted

Port setting not used in my.cnf

Well as soon as I moved the file from /etc/my.cnf to /root/.my.cnf it started working.
user avatar
1 vote

Why does XtraBackup tell me my MySQL database is corrupt?

This may be caused by a few different things. You are running an old xtrabackup version which has a bug that may flag for corruption in the data files when there is none, update to the newest ...
user avatar
  • 165
1 vote
Accepted

XtraBackup restore gives duplicates on slaving?

You have to tell the slave what was the last GTID executed on the master when backup was taken. NewSlave > SET GLOBAL gtid_purged="XXXX"; NewSlave > CHANGE MASTER TO MASTER_HOST="10....
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible