… you have a consistent binary backup at a point in time. When running Percona Server, you can utilize the… that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, …. This will allow you to compare and restore values (potentially corrupted via user error or other…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… standard MySQL database configuration follows this active/passive pattern. There is a virtual IP that points to …and benchmarks.) First, we set long_query_time to 0 in order to log every query. (See … logs captured from our production systems. We restored a production database backup to our test …
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… your MySQL databases – but did you know that you can now restore directly from a snapshot (and binary logs for point in time recovery) in case… the MySQL data files. Restoring snapshot alone may not be enough since there can be a lot more events from the time of…’s see if our salaries table is restored. mysql> SHOW TABLES; +———————+ | Tables_in_employees | +———————+ … | salaries | … +———————+ 6 rows in set (0.05 sec) Success! Your…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…has it’s strong points given the conditions. Percona XtraBackup for MySQL for binary backups. Strong Points: It can restore an entire server …typically use mydumper restores: Restoring a single file Restoring a single schema or rolling forward a single schema to a point in time Restoring data while …
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… of replication) is to bring all slaves to the same point in time and load data locally with SQL_LOG_BIN=0 set… be very helpful to go back in time with your data. One of vendors offering solution for MySQL is R1Soft. Though I have… go far back so you can restore from several of backup generations and do point in time recovery. Timing recovery is also important. Especially for…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…” In my first post in this series, I described materialized views (MVs). An MV is essentially a cached result set at one point in time… method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery after a restoring a backup. Since the backup is a essentially a ‘snapshot’ of the data at the time of…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
…CHANGE MASTER TO to specified location to restore replication in case of crash (assuming you’re…High Performance MySQL book. In the bug Heikki explains the code was probably removed in MySQL 5.0…use this position to point to proper location on the master, or later use for point in time recovery using …
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… if you’re just planning on using binary log for point in time recovery it can go unnoticed. sync_binlog Is helping by… cause MySQL to fail with wierd error messages. In MySQL 4.1 sync_frm option was added which reduces this problem as time window… related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write about them some other time.
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… LOGS? How does the system guarantee that you can perform point-in-time recovery? How does the system guarantee consistency with the binary… system to set up new MySQL replication slaves? How? Does the system verify that the backup is restorable, e.g. does it… and download a whitepaper that just has a bullet point “Support for MySQL Databases”. Or “I have to transfer you to the…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…the same way. First let me start pointing out common causes of replication lag …could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… Automatic Buffer Pool Save/Restore available in Percona Server is great help in this case. Changing Slave…
