… improving the reliability and user experience of Percona XtraBackup as well as adding features to make it better suited to more environments. The…. New since 1.6: Percona XtraBackup can now save Galera replication information while performing a backup when given the –galera-info…
Post: Making replication a bit more reliable
March 4, 2009 By 14 Comments
…replication makes restoring slave a bit tricky (if possible at all). The main problem is that InnoDB transaction state and replication state are not synchronized. If we speak about backup and you can execute SHOW SLAVE STATUS command you can get reliable… engines is much more complex and I…
Comment: Making replication a bit more reliable
November 15, 2009 By 14 Comments
These “solutions” make replication LESS reliable and MORE likely to have further problems! FIX the problem, don’t hide it.
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… if you’re running replication Slave as slave thread will issue single IO request most of the time making it sensitive to…. Sure it is more reliable, same as server with multiple power supplies ECC memory kill-chip and RAID is more reliable than without these… using SAN you probably pay more than 2x premium anyway. Yet another approach is to use MySQL replication with something as MMM…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
A while ago I wrote about how to make MySQL replication reliable, part of which is to eliminate temporary tables. The idea … that. CREATE TABLE commits the transaction, so there’s implicitly more than one transaction. However, as the person pointed out, that… the binlog individually, there’s clearly an opportunity to break replication here. It looks like this doesn’t avoid the problem…
Comment: Finding your MySQL High-Availability solution – The questions
October 20, 2009 By 36 Comments
…. Also as @Ryan H pointed out, you can make unreliable things much more reliable by having many of them. 3.) Failures. Understanding types… is one of the big benefits of database replication, whether using MySQL or Tungsten Replicator. 4.) Backups. People tend to forget this is the first line of defense for data and jump straight to more…
Post: Percona welcomes Ewen Fortune and Piotr Biel
October 1, 2008 By 5 Comments
… has been working with our largest clients, helping them make their data centers more reliable, higher performance, and easier to manage. Other recent… move to new data centers, set up replication, eliminate performance and security problems, and much more. Anything I write about these two…
Comment: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 5, 2009 By 10 Comments
Moritz, rhel5-relay-patch is experimental and contains patch overwrite-relay-info, I wrote about it there http://www.mysqlperformanceblog.com/2009/03/04/making-replication-a-bit-more-reliable/
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… are rarely actionable or reliable indicators of problems, and… undetected while it becomes more and more severe. This can…replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication…, if your application environment makes it difficult to handle …
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…more availability issues caused by their own software bugs, DOS attacks and other issues. However as your system growths the reliability… further in the system and make recovery much more complicated than simply swapping the … (in particular if you use MySQL Replication for HA) the switch to the …
