… is to have much easier failover than with file-based replication. We will see how to change…For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then… not been sent to the slaves (your last chance is to be able to recover data from the crashed …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
To recover a dropped or corrupt table with Percona Data Recovery Tool for InnoDB you need two things: media with … it is still zero. If you know how InnoDB uses `PREC` please let me know. mysql> select * from SYS_COLUMNS WHERE TABLE… the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to/SYS_FIELDS’ REPLACE INTO TABLE…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
… docs how to do it http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:start . The biggest challenge here is to find index_id for each table – http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:advanced_techniques#recovering_the_data…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… moving averages to TokuDB. So TokuDB shows about 2.8x better throughput, and on data size: InnoDB… selects by `id`. However it will interesting how both InnoDB and TokuDB performs if PK is…= 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables …
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… on how to recover a single tablespace using stock MySQL server. First, you must meet certain prerequisites to be able to restore …mysql/data/employees/ Import the new tablespace: mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries IMPORT TABLESPACE; mysql> set FOREIGN_KEY_CHECKS=1; mysql…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
…“Is it possible to recover the data?” The answer was yes since I was sure to at least be able to recover the data with the Innodb…/var/lib/mysql/recover/ chown mysql.mysql /var/lib/mysql/recover/$CURRENT_TABLENAME.ibd sleep 1 echo “importing tablespace” mysql -u root -e “alter table recover.$CURRENT_…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…data-recovery-tool:mysql-data-recovery:generating_a_table_definition With the table definition on table_defs.h it’s the moment to…data you need to recover and save it in another file. This is the output of our example: ~/data-recovery# cat data…
Post: Upcoming webinar on Data Recovery for MySQL
April 6, 2011 By 5 Comments
… of April on data recovery for MySQL. Almost every long serving DBA has been faced with the task of recovering data from a database… a walk through guide on how to restore your data after physical or logical failure, using practical examples to demonstrate how to tackle this challenging problem…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…GTID and how it works internally because there are many documents about that: http://dev.mysql.com/…GTID_PURGED to the GTID_EXECUTED value from the master. So now, we just need to recover the … when reading data from binary log: ‘The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION =…
Post: Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!
September 19, 2011 By 1 Comment
… 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’s binary logs, and how to recover…
