…backup. Since the backup is a essentially a ‘snapshot’ of the data at the time of the backup, upon restoration the backup…then you can keep the complete views transactionally consistent with each other, as long as you…this column. It is used to prevent wide innodb primary keys on the MV. mysql> select…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Comment: Impossible - possible, moving InnoDB tables between servers
March 20, 2010 By 9 Comments
… server to another without making an explicit duplicate (backup) copy of the InnoDB data files on the first server in the process… cluster of machines running XtraDB where we want to “stream” backups of databases from one node (A) to another (B) by… snapshot B can do steps 3-7 to get a consistent backup. I guess my question is: can XtraBackup be configured / easily…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… replication to work properly you need to have proper “snapshot” – consistent state of the database as it was on master and… Server and copying data, using LVM, Using Innodb Hot Backup Tool, Using another Slave, using backup image etc but in all the cases… “internal instructions” for cloning the slave or slave recovery from backup using this value. Infact Master_Log_File will work in…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…more times. The speed is very consistent, just a few tenths of a…for an infrequent scan, like a backup or report. In an OLTP …INNODB_BUFFER_POOL_READS | 191571 | | INNODB_DATA_PENDING_READS | 0 | | INNODB_DATA_READ | 3140882432 | | INNODB_DATA_READS | 191581 | | INNODB_PAGES_READ | 191570 | | INNODB…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…%) or found new Innodb bug (1%) Innodb recovery should be automatic and bring your database to consistent state. Depending on innodb_flush_lot_at… experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write about them some…
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
… it as a hybrid between MySQL Cluster and innodb_flush_log_at_trx_commit=2 mode. The … Things are again tuned to deal with Asynchronous Replication. Consistency is maintained but at expense of certain changes … are indeed in sync ? How to do Hot Backups with point in time recovery ? These and many …
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
… to compare results with different innodb_buffer_pool_size or innodb_flush_log_at_trx_commit but for innodb_thread_concurrency – you should… ? Both versions do their best with innodb_thread_concurrency=0 and 5.0 is slightly but consistently faster. Same as in my… least binary log to get point in time recovery from backup. Also Innodb log files of 2*650M are larger than practical…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
…great workaround if you’re using only Innodb tables – Innodb when Innodb does crash recovery it would print …LVM without pausing replication (so you can get consistent master position). It is all great but it…for example when you’re taking LVM snapshot (for backup or to clone slave from the master) …
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… for point-in-time recovery, too. Given a backup and the corresponding binary log position, you can…usually not much additional work. It’s ensuring consistency and durability that is expensive. Flushing it to…the InnoDB transaction log would work fine if a) all the data were in InnoDB, and b) InnoDB‘s…
Comment: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
Hmm, is it really safe to backup innodb tablespaces this way? I heard that its not in a consistent state if its still running while doing the backup?
