… TABLES WITH READ LOCK and fail backup or kill long running SELECT queries to let backup to proceed, but resolving server gridlock one way or another. If you’re just using Innodb tables and… data from the slave with –safe-slave-backup option, as preventing writes to the slave can be done by simply pausing replication.
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… Galera replication information while performing a backup when given the –galera-info option to innobackupex. XtraBackup now supports compressed backups. These backups …backup, the LRU dump is now included as well. Support for compiling and running Percona XtraBackup against debug versions of InnoDB…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… copy? Does the backup system understand that you cannot back up InnoDB by simply copying its files? Does the backup use FLUSH TABLES…, InnoDB logs, and replication? Can you use the system to set up new MySQL replication slaves? How? Does the system verify that the backup is restorable, e.g. does it run InnoDB recovery before…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… only helpful for replication needs but also if you ever need to do roll forward recovery while recovering from backup. There are… replicated tables) to set up replication becomes more tricky because you need to perform mapping between master positions which you get with backup… altering tables. If you have Innodb tables you’re normally OK because you can use –skip-innodb on the filtering slave and…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… this later. Free No extra commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to have… you’re using only Innodb tables and do not need to synchronize binary log position with backup you can skip this step…”, master_log_pos=401934686; 12) Run SLAVE START to restart replication. With slightly modified process you can clone slaves from the…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…with replication lag (and performance in general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb_…RAID controller doing RAID validation, some centrally kicked of SAN backup, intensive activity on the other tenants sharing physical hardware …
Post: Making replication a bit more reliable
March 4, 2009 By 14 Comments
… MySQL replication makes restoring slave a bit tricky (if possible at all). The main problem is that InnoDB transaction state and replication state are not synchronized. If we speak about backup and you can execute SHOW… state of replication in InnoDB transactional log file, in this case we will be able to see what position in replication the last…
Post: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
… dirty and Alexey had series of sleepless nights digging into Innodb page and row structure. When few more companies followed, so… their data, and we helped to implement proper backup strategy for some. Sometimes backups stop working in others they are never setup… least replicated. Alexey also has a task to write more details about Innodb data recovery process and release code for our innodb recovery…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… only Innodb tables – Innodb when Innodb does crash recovery it would print position in master log files up to which replication was done: InnoDB: In a MySQL replication… cases – for example when you’re taking LVM snapshot (for backup or to clone slave from the master) and can’t…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… envinronment works great for MyISAM but does not work with Innodb. Backup tools like “mysqlhotcopy” does not work etc. Note Performance also… as a backup may well work for MyISAM but will start taking way too much time to do restore for Innodb. On… balanced or replication of mixed table types which is quite complicated. I prefer to pick one storage engine (typically Innodb) and when…
