… some in memory so even OS level approaches such as LVM backup may not work in all cases. We also get… handle Innodb specifics well. We could get rid of SQL level table locks and using Innodb internal data dictionary instead of Innodb files. We would use Innodb transactional log for replication (which could be extended…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…”snapshot” – shutting down MySQL Server and copying data, using LVM, Using Innodb Hot Backup Tool, Using another Slave, using backup image …_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_…
Comment: Disaster: LVM Performance in Snapshot Mode
February 8, 2009 By 55 Comments
… internally as the InnoDB buffer pool allows our DB to avoid having to do writes while catching up on replication. Though, this would be one benefit of having the InnoDB buffer pool use the linux page cache. Transferring the snapshot from the LVM image would come from…
Comment: Why you can't rely on a replica for disaster recovery
August 5, 2010 By 25 Comments
…. You can run queries, CHECK TABLEs, whatever you want while replication is proceeding to assure yourself the thing is going to…. Not true of low-level replication schemes. I second that backing up by “snapshotting” a hot innodb db works. You just let…. I don’t use “snapshots” per se. My experience with LVM snapshots has been disappointing in terms of performance. I use…
Comment: Disaster: LVM Performance in Snapshot Mode
February 24, 2011 By 55 Comments
… to mind is you better ensure you’re checking your replication is in sync with mk-table-checksum or other tools. There are many reasons replication may go silently our of sync and you do not… restore. If you’re using Innodb also check out xtrabackup it has lower overhead than LVM and it also has throttling you…
Comment: MySQL Replication vs DRBD Battles
April 29, 2008 By 12 Comments
… this is hard / impossible in many situations. We use both, replication and DRBD in production. One database which is doing nothing… this database). The main database is configured in Master-Master replication fashion. We evaluated using DRBD here too but did not… “online schema change” or LVM snapshot backup. And finally we were not able to get a descent InnoDB recovery time (26G buffer…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…example these 50 drives will unlikely be helpful solving replication delay or speeding up this 3 hours reporting …keep the same RAID volume. I tend to keep Innodb data files (and whole datadir) and log files …well because this makes it very easy to use LVM for backups while assuming you have BBU on …
Comment: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… to get a consistent backup of myisam suitable for a replication seed. Maybe one of the guys here has a fourth…’re using LVM, FLUSH TABLES WITH READLOCK … snap … RELEASE LOCK (this is a very brief outage) If you’re using innodb, you… of myisam tables that we’re seriously considering moving to innodb; myisam has a lot of issues around the whole concept…
