… bring up the new mysqld, which finds a crashed innodb, recovers this, and then it is being… donor machine. Every once in a while the recovery of the innodb in the target location fails, … experiencing this with many versions of MySQL. We are now using ‘service mysql stop‘ instead of FLUSH TABLES WITH…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… created for the main MySQL branch. The MySQL at Facebook branch …crash the master, restart it, then ensure the master and slave are in sync (once the test load is stopped…CRASHED (101) I also took pains to ensure that the randgen workload was having an effect on the test tables between crash/recovery…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… crash recovery when an LSN mismatch occurs and still end up with inconsistent data. Now, assuming I have the following logical volumes – mysql…/init.d/mysql stop Shutting down MySQL (Percona Server)….. [ OK ] [root@sb logs]# umount /mysql/data [root@sb logs]# lvconvert –merge /dev/sb/mysql-data…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… need to copy files. Fast Recovery Recovery time is as fast as putting data back and standard MySQL crash recovery, and it can be reduced… read-write snapshot is you can actually start MySQL Server on it and perform recovery, check tables or do whatever else you… modified process you can clone slaves from the slaves without stopping them – you just need to use SHOW SLAVE STATUS instead…
Comment: Returning to InnoDB scalability
August 7, 2006 By 42 Comments
…. However, it became a hit to the bug and MySQL stopped. It reports on the bug. ==================test environment================= OS=RedHatEL4 …29 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: …
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… Stopping log copying thread. xtrabackup: Transaction log of lsn (3 763355707) to (3 845737724) was copied. Now in /data/vadim/mysql/…shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Doing recovery: scanned up to log sequence…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… to do transactional log recovery is invisible until you get a crash, meaning if your production … from the database’s standpoint. And, nothing stops you from running two databases on two … automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
… Innodb stops (read: crashes) with dirty buffer pool pages, Innodb recovery must be done to rebuild the last consistent picture of the database. Recovery… about Innodb log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence number 9682004056 Log…
