… only Innodb tables and do not need to synchronize binary log position with backup you can skip this step. 2) While holding connection…/backup 6) Copy data to backup. Normally you can skip slow query logs and error log while taking backup. You also can skip most of binary logs… the backup you will need to restore slaves as well and skip binary logs in your backup process. 7) Unmount filesystem umount /mnt/backup 8…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… for MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6 Amazon S3 monitoring for all the above Philosophy on backups It is… and binary backups. They each have their use cases and add redundancy to your backups. If there is an issue with your backup, it… be used. With mysqlbinlog 5.6, you can now pull binary logs in real time to another server using “mysqlbinlog … –read-from…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… couple of percents per day. The solution MySQL offers – using binary log works in theory but it is not overly useful in… will take over 24 hours to cover month worth of binary logs… and quite typically you would have much higher update traffic… update the backup and store the rollback changes or if dealing with read-only compressed backup create the roll-forward recovery log, which…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
…-time recovery? How does the system guarantee consistency with the binary log, InnoDB logs, and replication? Can you use the system to set… good thing. In reality, a proprietary, secret backup black-box is unacceptable. MySQL backups are complex and difficult to get right. It… list as a way to evaluate your backup provider’s suitability for enterprise-ready backup uses. If you can’t answer these…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… backup impact on server performance may well be). We also assume backup is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup) as this is only… compressed file size. Though in this example we used MySQL binary log file which often contains plenty of similar events, which could…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay log is corrupted… can’t use classical method of recovery from backup – because you would need relay logs to roll forward, and they are corrupted…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… binary logs (for example point in time recovery from backup) replication capacity of 1 will mean you can reply 1 hour worth of binary logs… the spare server with backups restored on it and apply binary log to it. If 1 hour worth of binary logs applies for 10 minutes… slower then they are warmed up. Measuring times for each binary log separately should give you these numbers. The less intrusive process…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… a standby MySQL server or at least synchronously replicated master binary logs. If you can’t loose any single transaction you’ve… environments it may take many days to catchup from weekly backups by binary logs so make sure to time it properly. In the… as shortcut) – for example you may have master or relay binary log corruption. Master or Slave running out of space, Slave crashing…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… binary logs. There are multiple ways to get the “snapshot” – shutting down MySQL Server and copying data, using LVM, Using Innodb Hot Backup… binary log position. There are two sources of information for binary log position SHOW MASTER STATUS – this shows position as master writes its own binary and is helpful when you for example take backup…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… all transaction logged in the binary log gtid_purged: it contains a representation of the set of all transactions deleted from the binary log So now, the process is the following: take a backup from the master and store… data from binary log: ‘The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing…
