June 19, 2013

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… following aspects: Initial setup Setup of other nodes with SST (Xtrabackup SST) Integration of chef with PXC Finally, integration of HAProxy… SSTs with node1 (based on gcomm://node1 of node2) through Xtrabackup SST (state snapshot transfer). Node3 subsequently joins the cluster with… a node has been down for a while and IST (incremental state transfer) is not feasible. It also helps when node…

Post: Percona XtraBackup 2.1.3 for MySQL available for download

… time XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We recommend support for…

Post: Percona XtraBackup 2.0.7 for MySQL available for download

…/restore a slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL 5… in the incremental backup directory. Bug fixed #856400. Percona XtraBackup would leave stale xtrabackup_tmp* files in the datadir after applying incremental backups. Bug…

Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download

… in the incremental backup directory. Bug fixed #856400. Percona XtraBackup would leave stale xtrabackup_tmp* files in the datadir after applying incremental backups. Bug fixed #1079135. If there are thousands of tables and slow IO then XtraBackup can spend a…

Post: Announcing Percona XtraBackup 2.1.1 GA

… completely removed in Percona XtraBackup 2.1. Percona XtraBackup can use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs… it was scanned by XtraBackup on startup and before XtraBackup attempted to copy it. Bug fixed #1079700. Orphaned xtrabackup_pid file left inside…

Post: Percona XtraBackup 2.1.0 for MySQL beta now available

… and bug fixes in Percona XtraBackup for MySQL 2.0.6, plus the following: New Features: Percona XtraBackup has implemented basic support… buffer pool dump files). Percona XtraBackup can use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs Fixed: Fixed…

Post: xtrabackup-0.5, bugfixes, incremental backup introduction

… copy changed pages you can do: xtrabackupincremental_lsn=1319:813219999 –backup –target-dir=/data/backup/increment_day1 and only changed pages (ones…. More about incremental you can read on our draft page http://www.percona.com/docs/wiki/percona-xtrabackup:spec:incremental You can download…

Post: Just how useful are binary logs for incremental backups?

… that it also limits the effectiveness of using it for incremental backup.  Let me make up some numbers for the… the solutions? If you are using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs.Â…

Post: Percona XtraBackup 1.6

… Tkachenko) Added option –incremental-lsn to innobackupex. If specified, this option is passed directly to the xtrabackup script and –incremental-basedir is ignored. (Vadim Tkachenko) Added option –incremental-dir to innobackupex. This option is passed directly to the xtrabackup

Post: Announcing Percona XtraBackup 2.0.0 GA

… table). Percona XtraBackup now supports streaming incremental backups. In previous versions streaming backups were performed by the innobackupex script but incremental backups were done by the xtrabackup binary…