… time to backup & purge binlogs versus when its time to look for more table storage) but it definitely allows mysql snapshots to be a lot smaller. I have to agree that there’s no reason to snapshot binlogs, because they always move forward, there’s never any going back. So my backup script does this…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… 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 the backup, upon restoration the backup may… is also like a snapshot. The incremental refresh method uses the changelogs collected by FlexCDC to update the snapshot to reflect the…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication …offer snapshots with low overhead allowing to take a backups conveniently. Also if you keep last uncompressed backup on SAN (or last snapshot) you…
Post: LVM Configuration mistake to Avoid
July 9, 2008 By 10 Comments
One of our customers was setting up box for MySQL LVM backups. The box had 2 RAID volumes (internal drives and enclosure… drives so LVM and backup has less backup on the running system. As the system was configured creating snapshot volume with 100G of… you can’t use space from one volume group for snapshot for another. What should have done instead is creating single…
Post: Avoiding SST when adding new Percona XtraDB Cluster node
August 2, 2012 By Leave a Comment
…to use a backup to prepare a new Percona XtraDB Cluster node. They want this to avoid State Snapshot Transfer that …grastate.dat comes from the global variable wsrep_provider_version: mysql> show global status like ‘wsrep_provider_version’; +————————+———–+ | Variable_name | …
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
For long time as main backup solution for MySQL on Linux we have been using LVM snapshots. Performance concerns from performance critical envinronment…. This is going to be fully OpenSource, GPL licensed backup solution for MySQL (MyISAM and InnoDB for now). We gathered basic ideas… looking to implement advanced functionality like incremental backup (copy only changes from last backup),table-level backup (copy only specified tables), streaming and…
Comment: Estimating Undo Space needed for LVM Snapshot
June 11, 2008 By 5 Comments
… logical volume for MySQL binlogs. This helps just for data management (its much more obvious when its time to backup & purge binlogs versus when its time to look for more table storage) but it definitely allows mysql snapshots to be a lot smaller. “”" When I was running important (to the company) MySQL swervers I had my…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… normal Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem. First why do you need incremental backups at… it only changes couple of percents per day. The solution MySQL offers – using binary log works in theory but it is…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
…. Innodb during recovery also prints position in the MySQL binary log: InnoDB: Last MySQL binlog file position 0 589600615, file name ./galax… other cases – for example when you’re taking LVM snapshot (for backup or to clone slave from the master) and can’t… and recommended way with FLUSH TABLES WITH READ LOCK for snapshot creation. This happens when you have large amount of tables…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…. Backup & restore MySQL and InnoDB data, and describe the advantages of common backup methods (mysqldump, file system snapshot, InnoDB hot backup). Setup and administer MySQL replication. Monitor MySQL servers in production. Discuss security issues with MySQL. Solve…
