… backups much easier and faster with Percona XtraBackup utility. We will discuss: * XtraBackup operational principles * Sample usage scenarios * Full backups * Incremental and partial backups * Importing and exporting individual tables * Streaming and parallel backups * Limitations and common issues. You…
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… decided to make innobackupex always back up the MySQL system database, even for partial backups; it contains data that is necessary to restore…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
…’m not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication… to perform mapping between master positions which you get with backup to distribution slave position. You can also clone other slaves… you can see no matter which road you take with partial MySQL Replication there are things to be careful with, so if…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…. Partially written .frm files or .frm being unsync with internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL… other problems which you may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…. MySQL also has broken group commit (which we have partial fix for) meaning concurrent transaction commits will need to be serialized. Second, MySQL… MySQL replication is a showstopper) and it also solves the other big pain of semi-online MySQL/OS upgrades and Schema changes. Backups…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… decide ether to grow system in MySQL+Apache pairs or split MySQL And Web Server and place them … generally require more monitoring and maintainence such as backups so you end up using some serious hardware … also on database boxes, might be only handling partial load etc. I would however only use it …
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this …(passive) master for serving some SELECT queries, taking backups, etc as usual. However, if you do …failover, you need some way to at least partially emulate a production workload on the standby machine. …
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… of backup which can be very helpful to go back in time with your data. One of vendors offering solution for MySQL… reclone slave from the master, another slave or restore from backup. So this is just question of having decent capacity planning… life environments can be even more complicated – one may use partial replication, replication to different storage engine, add some tables beyond…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… tried iiBench, which you can take there https://launchpad.net/mysql-patch/mytools What makes fractal indexes so interesting is the… soon. – The ways to do a backup is mysqldump/mysqlhotcopy. It is not fully transparent backup, as it applied TABLE LOCK on… run LVM backup. Actually I would say backup is only partially the problem of storage engine. The biggest problem is that MySQL does not…
Post: Small things are better
October 8, 2006 By 15 Comments
…, surviving power failures and even partial page writes but still they can get corrupted because of MySQL bugs, OS Bugs or hardware… kind failures. This is one thing you better to have backups for. Backups however take time to restore, especially if you do… to recover, smaller tables allow per table backup and recovery to happen faster. With MySQL and blocking ALTER TABLE there is yet…
