… got to learn when working with large data things in MySQL is patience and careful planning. Both of which relate two… people – I constantly run into the customers assuming it will be quick to rearrange their database or even restore from backup. You need… and restore will be faster but it can still take hours especially if database is already loaded. So operating wit such large databases…
Post: What Are Full, Incremental, and Differential Backups?
January 23, 2012 By 9 Comments
…. It makes a copy of all of your MySQL data. A differential backup, on the other hand, …databases have a lot of data that does not change from one backup to the next. Not copying this data into…the way that you would restore a backup. Suppose that you need to restore your database on Friday. If you …
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… moves out all MyISAM tables out of MySQL database directory, checks them with MyISAMchk and moves … can be done by using LOAD INDEX INTO CACHE statement, for other storage engines it … which you may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace …
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… because we don’t have a backup or the backup restore process doesn’t work. How can I recover deleted rows… ibd file and import them into the database. The time between the deletion of rows and the database stop is crucial. If pages… to import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data/salaries.recovery’ REPLACE INTO TABLE `salaries` FIELDS TERMINATED…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…cluster synchronization, both incremental and full restores The ability to read and …mysql> insert into autoinc (j) values (‘node2′ ); Query OK, 1 row affected (0.00 sec) node2 mysql> insert into…some databases this may be perfectly natural, but I believe most conventional relational databases will…
Post: Percona Server and XtraBackup weekly news, April 4th
April 4, 2011 By 1 Comment
… developments in the market such as MySQL 5.5, MariaDB, Drizzle, etc. The …databases. We committed code that makes xtrabackup copy the LRU dump file from Percona Server, so that after the backup is restored, the server will warm up very quickly. We merged new documentation into …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… backup will be aborted. Sometimes you might run into the errors on this step, The most common … recovery from the backup you will need to restore slaves as well and skip binary logs in …more simple steps 9) Extract/Copy database to the slave database directory. 10) Start MySQL Server. Wait for it to …
Post: Master-Master or Master with Many Slaves
April 6, 2007 By 7 Comments
… has to handle much more write load. Especially keeping into account MySQL replication is single thread it might be not long before… if you have 16GB boxes and say 12GB allocated to MySQL database caches you can get 12GB effective cache on the master…-clone it (or restore database from backup) compared to multiple master-master pairs. I however agree if you have small database (compared to…
Post: Percona Server and XtraBackup weekly news, March 5th
March 6, 2011 By Leave a Comment
… Squeeze in our repositories on the next release based on MySQL 5.1.55, which we estimate will be released on…, unfortunately it doesn’t look like we can get it into the next release. It was just too late in the… innobackupex always back up the MySQL system database, even for partial backups; it contains data that is necessary to restore other data correctly.
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… taking a consistent backup of your MySQL databases – but did you know that you can now restore directly from a snapshot (and binary… mysql-data-201202230157 started. mysql-data: Merged: 2.3% mysql-data: Merged: 0.2% mysql-data: Merged: 0.0% Merge of snapshot into logical volume mysql…
