… it replication capacity of 3. When used with context of applying 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 within 1 hour. I will call “replication… up or when restoring from backup, the loaded replication capacity matters during normal operation. So we defined what replication capacity is. There is…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
…, and replication? Can you use the system to set up new MySQL replication slaves? How? Does the system verify that the backup is… 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: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… only helpful for replication needs but also if you ever need to do roll forward recovery while recovering from backup. There are… recommend using these. There are also replicate-do-table, replicate-ignore-table, replicate-wild-do-table and replicate-wild-ignore-table options which act… replicated tables) to set up replication becomes more tricky because you need to perform mapping between master positions which you get with backup…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… cache content. Replication Traffic Changes Changing in the replication traffic (what updates are being replicated) are frequent cause of concern. Remember replication runs as… which just a bit different workload and when backup taken at the wrong time may be responsible for unexpected MySQL replication lag.
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… major components: Percona XtraBackup for MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6 Amazon S3 monitoring for all the… blog post. Mydumper for logical backups Strong Points: Very fast for logical backups – compared to mysqldump Consistent backups between myisam and innodb tables… schema to a point in time Restoring data while automatically replicating out to all slaves mysqlbinlog 5.6 Last year Percona…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… to Integrate Do you want to compress backup ? Backup it to tape, FTP or any network backup software – it is easy as you… simply closing connection. 5) Mount backup Filesystem: mount /dev/Main/dbbackup /mnt/backup 6) Copy data to backup. Normally you can skip slow…”, master_log_pos=401934686; 12) Run SLAVE START to restart replication. With slightly modified process you can clone slaves from the…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… test of backup + restore: Populate server Take a validation snapshot (mysqldump) Take the backup (via innobackupex) Clean datadir Restore from backup Take restored… create a slave from the backup, replicating from the backed up server. After the initial setup, we ensure replication is set up ok… and the server, enhancing / expanding replication tests by creating heavy randgen loads against the master during backup and slave setup, and other…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
… from the server if it gets too delayed with replication (or if replication breaks) so you do not have to do it… broken replication safe way becomes very easy. Besides simple “cloning” of the nodes you can use same tool to create a backup with number of methods supported including compressed backup or incremental backups with rdiff. Finally we have…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… to take a backup from the master and restore it on the slave to set up a new replication server. master > show…-7059-11e2-9a24-08002762b8af:1-2 | +—————+——————————————+ Now we take a backup with mysqldump from the master: # mysqldump –all-databases –single-transaction…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…]). As we are in multi-master replication, the other master should also replicate events : Closer look: Infinite Replication Loop flow: If you have master-master with slaves or if you want to backup one… for server-id 2 gets replicated over and over… How can you create loops ? You restore a backup from another machine and…
