… run away select can effectively cause downtime if you use backup solution which does FLUSH TABLES WITH READ LOCK which is… 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…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… now supports streaming incremental backups. In previous versions streaming backups were performed by the innobackupex script but incremental backups were done by the… the backup, the LRU dump is now included as well. Support for compiling and running Percona XtraBackup against debug versions of InnoDB…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 25, 2012 By 20 Comments
… files, like frm file. 2. copy data files other than InnoDB. 3. get the binlog file and binlog postion information. And… operations in the progress of hot backup, frm files are consistent. 2. we only use InnoDB as our engine, no other engines… file and binlog postion information from xtrabackup_binlog_pos_innodb file since InnoDB will wirte these information in its commit log. Am…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
Many people use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most cases…` char(255) NOT NULL, `i` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs… you get some empty tables in your mysqldump –single-transaction backups you will know the potential cause for it. What are…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… have created a backup of my mysql database using the innobackupex-1.5.1 command. I have the innodb_file_per_table directive set in the my.cnf configuration file. I have the backup folder which contains… to view/access ONLY MYISAM table – but none of the InnoDB tables. Is there something which I am missing? Do I…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… table # xtrabackup_55 –backup –innodb-file-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export –innodb-file-per-table… the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… the bug or user error. I think the innodb data from the backup where Innodb fails to recover should be passed to your support provider for investigation. It might be related to Innodb itself…
Comment: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
With xtrabackup, it only has to lock tables that aren’t InnoDB, it has the ability to take backups of InnoDB tables *without* taking locks and without any overhead of block device or filesystem snapshots.
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… bad setting server read only…. When we speak about Innodb tables and backup with Xtrabackup or LVM we do not really need… flushed and read only so they can be copied and Innodb tables can be written to but we do not want…
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…) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really…
