Readers of this blog know that one of my favorite tools, Tungsten Replicator, can easily create multi-master replication topologies, such as all-masters, star, fan-in. While this is good news for system designers and ambitious DBAs, it also brings some inconvenience. When you allow updates to happen in more than one master, you risk having conflicts. You may have heard this term before. For the sake of clarity, let's define what conflicts are, before analyzing each case in detail.
class="alignleft wp-image-13951" style="margin: 12px;" alt="Percona Toolkit" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona_ToolkitLogoVert_RGB-300x249.png" width="300" height="249" />A new Percona Toolkit series has been released:
I’ve been trying out Republic Wireless, a startup that offers very inexpensive wireless service: $19 for unlimited talk, text, and data. In a nutshell: they resell Sprint’s network, and you agree to connect to wifi as much as possible; they use the Internet instead of the cell network when you’re on wifi. I thought for $19/month it wouldn’t hurt to give it a try. After several months, my experience has been that it isn’t worth using at all, no matter how cheap it is.
I don’t want to dwell on the problems at great length, but here are some of the issues I’ve had.
BE sure to attend the NOWG (Norwegian Oracle Users Group) conference (on a cruise ship) this April for presentations on Powerful EXPLAIN in MySQL 5.6 by Øystein Grovlen, What’s New in MySQL Server 5.6? by Geir Hoydalsvik, MySQL Query Optimizer: an overview by Jørgen Løland, and MySQL: An Introduction for Oracle DBAs also by by Øystein Grovlen.
title="MySQL Banner: Keynote stage by ebayink, on Flickr" href="http://www.flickr.com/photos/ebayink/2417342178/">
class="alignright" alt="MySQL Banner: Keynote stage" src="http://farm3.staticflickr.com/2388/2417342178_a1eb756660_o.jpg" width="280" height="210" />I actually don’t remember exactly whether it was in 2006, 2007 or 2008 — but around that time the MySQL community had one of the greatest MySQL conferences put on by O’Reilly and MySQL. It was a good, stable, predictable time.
Approximately 11 months ago,
href="http://www.mysqlperformanceblog.com/2012/05/04/testing-virident-flashmax-1400/" target="_blank">Vadim reported some test results from the Virident FlashMax 1400M, an MLC PCIe SSD device. Since that time, Virident has released the FlashMAX II, which promises both increased capacity and increased performance over the previous model. In this post, we present some benchmark results comparing this new model to its predecessor, and we find that indeed, the FlashMax II is a significant upgrade.
I had the pleasure of speaking on two excellent podcasts:
No need for me to introduce this podcast. I just have to say it was only when I interviewed that I realized the amount of work taken for producing one single cast. Kudos to Sheeri & Gerry and Rich Goyette the sound producer and thank you for your kind hospitality!
Percona is glad to announce the release of Percona XtraBackup 2.0.6 on March 20, 2013. Downloads are available from our download site
href="http://www.percona.com/doc/percona-xtrabackup/installation.html">Percona Software Repositories.
This release is the current GA (Generally Available) stable release in the 2.0 series.