… see anything suspicious in the /var/log/mysqld.log file which i believe is the error log you are talking about? 120502 11… files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 120502 11:51:16 InnoDB: Started; log sequence number 119….rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… we restore. [root@sb logs]# /root/bin/lvmsnap.sh snapshot Taking a new snapshot .. done Trimming excess snapshots .. Logical volume “mysql-data-201202230135…` /* generated by server */ … Now, let’s restore our data from the snapshot, under the hood restore is really a “rollback” to the snapshot…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… being enough to restore the whole system to operating state, especially for complex systems. Instead of looking just at data restore process you better look at the whole process which is required to bring system to the working state, including data… shortcut) – for example you may have master or relay binary log corruption. Master or Slave running out of space, Slave crashing…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… is to restore a part of the data set, when it’s time to do a full data restore, more tables means longer restore times. Deciding to create a new table for a part of the data set is… > amount of data in it. And do run EXPLAIN for your queries, especially > if you see them in slow query log. If…
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
… the backup method was raw data files, it shouldn’t take much more than 30 minutes to restore 100GB (50MB/s), but… XtraBackup incremental backup should be much faster than using binary logs. You can understand Vadim’s excitement when he announced… hope that it’s not often that you need to restore! Eventually this problem should be lessened by a MySQL…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… logs are essential part of creating good backup infrastructure as it gives you the possibility for point in time recovery. After restoring… periodic filesystem level backups of the binary log files which could still lead to data loss depending on the interval you back… that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman/5…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… 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 the backup, upon restoration… define the view. These stored procedures maintain the Flexviews data dictionary. The data dictionary is used by the incremental refresh algorithm to…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… to catch up and application is suffering because of stale data. This especially applies to Software as Service providers which often… the slave and need it to catch up or when restoring from backup, the loaded replication capacity matters during normal operation… spare server with backups restored on it and apply binary log to it. If 1 hour worth of binary logs applies for 10…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small number of… the InnoDB shared tablespace (ibdata) and the transaction IDs and log sequence numbers that are stored in the tablespace files also….cnf –apply-log –export /tmp/2012-01-22_14-13-20/ Now we’re going to delete some data from one table…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…restore…data_pending_readsblogpercona.commanual Innodb_data_pending_writesblogpercona.commanual Innodb_data_readblogpercona.commanual Innodb_data_readsblogpercona.commanual Innodb_data_writesblogpercona.commanual Innodb_data…
