This week I had to deal with some unusual problems. But let me start with Percona's xtrabackup, software that I consider a key component of many current production MySQL setups and use regularly. Recently new minor versions of XtraBackup were released, check the details on, for example. It made a step towards support of MariaDB 10.2, but it's still a long way to go, see this pull request. My main problem with xtrabackup, though, is not with lack of support of MariaDB 10,2-specific features. Why should they care, after all.
The problem is that old well known bugs and problems are not resolved, those that may affect all MySQL versions, forks and environments. One very interesting feature, “Compact Backup,” is introduced in. You can run “compact backups” with the –compact option, which is very useful for those who have limited disk space to keep the database backup. Now let’s first understand how it works.
When we are using –compact option with Innobackupex, it will omit the secondary index pages. This will make the backups more compact and this way they will take less space on disk but the downside of this is, the backup prepare process will take longer time because those secondary index pages will be recreated while preparing the backup.
Building Xtrabackup For Mac Os
Here, we need to consider couple of things before implement. We wanted to optimize and test backups for one of our new large scale setup before we could finalize on the backup plan.
Our challenge was the data volume was almost 30x more than our normal volumes. Since this involved large volume of data we thought this might be a good candidate to test incremental backups. We wrote a wrapper script to save the states between full backups and incremental backups and did some tests with smaller data sets. It worked perfectly fine. The version of xtrabackup we were testing was 1.6.2.
The incremental backups were completing well within 30minutes. We set out to test what would happen if the amount of incremental diff was large. While doing this test, we started getting backup failures with the following error 20110726 225312. Log-110727 00:56:10 innobackupex: Starting to backup.frm,.MRG,.MYD,.MYI, 20110726 225312. Log-innobackupe x.
转载自： Percona XtraBackup is free and open source backup tool for MySQL. Percona distributes XtraBackup via package repositories for. Unfortunately there are no packages for Mac OS. In this post I will describe how to build XtraBackup for Mac OS. DependenciesTo build and use XtraBackup on Mac OS you need to install some additional packages. I will use to install the dependencies.
Building Xtrabackup For Mac Free
# port install cmake p5.16-dbd-mysql Building XtraBackup for Mac OSDownload the source code from # wget Untar the archive: # tar zxf percona-xtrabackup-2.2.10.tar.gz Build the binaries. # cd percona-xtrabackup-2.2.10 # cmake -DBUILDCONFIG=xtrabackuprelease && make XtraBackup comes with a perl script innobackupex that can be found instorage/innobase/xtrabackup/. The script is a wrapper around few binaries XtraBackup needs to work. They are built in storage/innobase/xtrabackup/src: xbcrypt, xbstream and xtrabackup.
Installing XtraBackup for Mac OSTo install XtraBackup use a Makefile: # make -C storage/innobase/xtrabackup/ install It will install XtraBackup in /usr/local/xtrabackup/. The binaries will be placed in/usr/local/xtrabackup/bin/ so make sure it’s in the $PATH. XtraBackup PackageFor your convenience we built and packaged XtraBackup for Mac OS. The package installs the binaries in /opt/local/bin which should be in your $PATH. I tested XtraBackup on OS X 10.10 Yosemite.
The post appeared first on.