…. Fast Recovery Recovery time is as fast as putting data back and standard MySQL crash recovery, and it can be reduced even… you can assume in case of recovery from the backup you will need to restore slaves as well and skip binary logs… log position. Be careful however – cloning slave from the slave also clones inconsistences in data which slave could have accomulated – especially if…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…Data_length: 698,351,616 bytes on disk The problem is that after restoring table from mysqldump, the query that scans data… | +—————————+ 1 row in set (2 min 8.92 sec) mysql> SHOW STATUS LIKE ‘Innodb_scan_pages%’; +——————————+——-+ | Variable_name | Value…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
… too high. But if you later restore enforcement, MySQL does not immediately scan all your data to verify that you haven’t broken…_* columns are non-null, it’s a foreign key. mysql> SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_NAME IS….sql | mysql -N | mysql -E *************************** 1. row *************************** test.Bar.ID: 42 DIY RI We can get information about foreign key constraints from the…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…restore proper response time, so it wasn’t load. It was probably crossing a tipping point in the data…varying from 50 microseconds to half a second, *real* queries that actually touch real tables and fetch data from… — and that’s where improvements to the MySQL source code are necessary. But in many …
Post: Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!
September 19, 2011 By 1 Comment
… able to offer such a wide variety of talks from so many MySQL experts. Come see Devananda van der Veen a Percona… understanding of the MySQL binary log format or the slave’s two-phase replication architecture, safely restoring replication while maintaining data integrity can be a daunting task. This talk will show you how to interpret SHOW SLAVE STATUS, how to read MySQL…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
…else’s backup solution for your MySQL data? Do you care a lot about your data? Are you sure you’… set up new MySQL replication slaves? How? Does the system verify that the backup is restorable, e.g. … for MySQL, or more so for MySQL than for other types of backups. Where is this post coming from? Well…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… spotted by converting tables to Innodb on restored backup. Full text search indexes, GIS, multi-… for Innodb. First Depending on MySQL version they may be somewhere from suboptimal to absolutely disastrous, …still will be much more secure than storing data in MyISAM. The 3 most important values …
Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !
December 18, 2012 By 3 Comments
…then become a loop : for each production server restoring the dump on the node that will … assumption is that there are no conflicts in data between the different masters. Which is the case… asynchronous replication of MySQL), it can spread in the cluster all statements received from the master if log…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… back with a separate ALTER TABLE after restoring the data from a dump would actually make the restore slower; mysqldump –innodb-optimize-keys ignores… index as the clustered one. References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in Percona Server…
Post: What Are Full, Incremental, and Differential Backups?
January 23, 2012 By 9 Comments
…explanatory. It makes a copy of all of your MySQL data. A differential backup, on the other hand, simply … lot of data that does not change from one backup to the next. Not copying this data into your … the way that you would restore a backup. Suppose that you need to restore your database on Friday. …
