I'm looking for some instructions/manual to set Percona Xtradb cluster with Xtrabackup for SST. Is there any configuration file where I need to provide login details for Xtrabackup script?
Thanks
I'm looking for some instructions/manual to set Percona Xtradb cluster with Xtrabackup for SST. Is there any configuration file where I need to provide login details for Xtrabackup script?
Thanks
I updated my sources.list with
deb http://repo.percona.com/apt squeeze main
deb-src http://repo.percona.com/apt squeeze main
And called
gpg --keyserver subkeys.pgp.net --recv-keys 1C4CBDCDCD2EFD2A
The Result was, that it seemed to import something, so the key was found on this sever!?
Nevertheless now I get the error:
GPG error: http://repo.percona.com squeeze Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 1C4CBDCDCD2EFD2A
How can I disable/ignore the keychecking in apt in general?
What is the adviced way to fix the problem itself. Is there some way to search the key somewhere elese? How would I do that?
I very often need to create a backup of a database and import it using a different schema name. These schema's are pretty large (3-5GB) and mysqldump is a pain. xtrabackup seems promising but I cannot find how to import a backup using a different database name.
Any clues?
I am looking into MySQL Enterprise backup solution. I am interested in a non-blocking mysql backup (live and incremental).
MySQL Enterprise provides this solution (we have the subscription already). But from what I see it's only a console application (and not the most user friendly one).
I am not interested in making wrapper scripts or GUI for MySQL Enterprise Backup. Can you recommend some thing which eases the operation of live backup.
I am using Percona's xtrabackup to take backup of my online databases. Is there a way to convert the backup database files into a SQL dump similar to a backup created using mysqldump ?