by Leif.Walsh | Feb 19, 2014 | MySQL
We just released version 1.4.0 of TokuMX, our high-performance distribution of MongoDB. There are a lot of improvements in this version (release notes), the most of any release yet. In this series of blog posts, we describe the most interesting changes and how they’ll...
by Leif.Walsh | Feb 18, 2014 | MySQL
We just released version 1.4.0 of TokuMX, our high-performance distribution of MongoDB. There are a lot of improvements in this version (release notes), the most of any release yet. In this series of blog posts, we describe the most interesting changes and how they’ll...
by Leif.Walsh | Feb 13, 2014 | MySQL
Today we are thrilled to announce the availability of the latest release (1.4.0) of TokuMX, our high-performance distribution of MongoDB. For those of you just joining us, TokuMX is an open-source distribution of MongoDB that shares much of the code, and all of the...
by Bill Karwin | Feb 12, 2014 | Insight for DBAs, Webinars
January 22 I gave a presentation on “How to Avoid Common (but Deadly) MySQL Operations Mistakes” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to...
by Ovais Tariq | Jan 21, 2014 | Insight for DBAs, MySQL, Percona Services
The other day I was working on an issue where one of the slaves was showing unexpected lag. Interestingly with only the IO thread running the slave was doing significantly more IO as compared to the rate at which the IO thread was fetching the binary log events from...
by Yves Trudeau | Jan 20, 2014 | Insight for DBAs, MySQL
Over the last few days, I integrated the MySQL 5.6 GTID version of the Percona Replication Manager (PRM) work of Frédéric Descamps, a colleague at Percona. The agent supports the GTID replication mode of MySQL 5.6 and if the master suffers a hard crash, it picks the...
by Yves Trudeau | Dec 10, 2013 | Insight for DBAs, MySQL
My December 4 webinar, “Geographical disaster recovery with Percona Replication Manager (PRM),” gave rise to a few questions. The recording of the webinar and the slides are available Percona Gold or Platinum Support contract. It is not availabe with...
by Stephane Combaudon | Oct 28, 2013 | MySQL, Webinars
I want to thank all attendees of my webinar, “MySQL 5.6 New Replication Features: Benefits, Challenges and Limitations”. We had questions that I didn’t have the time to answer: Q: If I run on Amazon’s RDS, do I need to worry about enabling...
by Stephane Combaudon | Oct 21, 2013 | MySQL, Webinars
On Wednesday I’ll be leading a webinar exploring MySQL 5.6’s new replication features. And yes, as usual I’ll deliver news on the good, the bad and the ugly (that is to say the benefits, limitations and challenges). The webinar, appropriately titled, “New...
by Jay Janssen | Oct 17, 2013 | MySQL
Checking throughput with async MySQL replication Replication throughput is the measure of just how fast the slaves can apply replication (at least by my definition). In MySQL async replication this is important to know because the single-threaded apply nature of...
by Roman Vynar | Sep 16, 2013 | Insight for DBAs, MySQL
Working day to day with Percona Remote DBA customers, we have been facing an issue from time to time when MySQL replication lag is flapping between 0 and XXXXX constantly – i.e. Seconds_Behind_Master is 0 for a few secs, then it’s like 6287 or 25341, again...
by Leif.Walsh | Jul 23, 2013 | MySQL
Since we released TokuMX, one of the most frequent requests has been for a migration tool. TokuMX has a completely different storage format than MongoDB, which means that you have to actually move all of your data out of MongoDB and into TokuMX, you can’t just...
by Stephane Combaudon | May 30, 2013 | Insight for DBAs, MySQL
The main benefit of using GTIDs is to have much easier failover than with file-based replication. We will see how to change the replication topology when using GTID-based replication. That will show where GTIDs shine and where improvements are expected. This is the...
by Stephane Combaudon | May 21, 2013 | MySQL
Global Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs much easier when having to maintain servers under a specific replication topology. However you should keep in...
by Bill Karwin | Jan 23, 2013 | Insight for Developers, MySQL, Percona Events
Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I...
by Bill Karwin | Jan 17, 2013 | Insight for Developers, MySQL, Percona Events
I’ll be presenting a webinar next Wednesday, January 23 at 10 a.m. (Pacific Time), about issues application developers should think about for scaling out read-query traffic using multiple MySQL instances in a replication pair. Specifically, about the care we...
by Aurimas Mikalauskas | Jan 9, 2013 | Insight for DBAs, MySQL
While we do have many blog posts on replication on our blog, such as on replication being single-threaded, on semi-synchronous replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication...
by Aurimas Mikalauskas | Aug 29, 2012 | Insight for DBAs, MySQL
If you ever had a replication slave that is severely behind, you probably noticed that it’s not catching up with a busy master at a steady pace. Instead, the “Seconds behind master” is going up and down so you can’t really tell whether the...
by Rich.Prohaska | Jul 16, 2012 | MySQL
We found a simple XA transaction that crashes MySQL 5.5 replication. This simple transaction inserts a row into an InnoDB table and a TokuDB table. The bug was caused by a flaw in the logging code exposed by the transaction’s use of two XA storage engines (TokuDB and...
by Tokutek | Apr 18, 2012 | MySQL
Thanks to all of those who came by our booth and to see Leif’s presentation on Read Optimization, and to my Lightning Talk on OLTP and OLAP at the Percona MySQL Conference and Expo. It was an incredible week and a great place to launch TokuDB v6.0 from! A big...
