… replication is that the db copy is “hot” — there’s always a functioning database running against the copy. You can run queries, CHECK… “snapshotting” a hot innodb db works. You just let the copy run crash recovery and voila you have a consistent backup copy of your…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…000016 | | creating table | 0.168283 | | After create | 0.000061 | | copy to tmp table | 0.165808 | | rename result table … is that, if you have some really hot tables, for example in web applications its …11) not null auto_increment primary key) ENGINE=InnoDB; Query OK, 0 rows affected (0.09 sec) …
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… being confused about the fact you can copy MyISAM tables on file basics but not Innodb ? By the fact you can have… these groups as people who make their Hot Rods and people who drive Honda Civic. Hot Rods are cool and allow you…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… record. This means that if you have “hot database areas (single records that are modified very…have any specific recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments…like to show that the full data is copied when you SST again. Q: Thanx Peter, …
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
…you), then there really is no way to get a “hot” consistent dump. You can issue flush tables with read …up for flush time + snap time. If you’re pure innodb, I generally trust its recovery engine so you can …w/o the read lock. This is a crash consistent copy and you’ll have to go through a recovery …
Post: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 18, 2010 By 15 Comments
…with FusionIO 320GB MLC card, so I will copy results from FusionIO 320GB MLC benchmarks. For benchmarks…requires sequential writes (e.g. like I put InnoDB transactional logs on rotation based drives instead of… is important point that with SSD you may “hot“remove and insert cards, while for FusionIO, …
Post: An argument for not using mysqldump
November 8, 2010 By 26 Comments
…, xtrabackup, innodb hot backup), it is very easy to model how much longer recovery time will take: Backup is 80G Copy is at…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… get the “snapshot” – shutting down MySQL Server and copying data, using LVM, Using Innodb Hot Backup Tool, Using another Slave, using backup image…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup) as this is only way practical… is less space requirement if you’re keeping the local copy as well as less network bandwidth requirements in case you…
