Thanks to everyone who was in attendance on 05 June 2013 for my “Choosing a MySQL HA Solution” webinar. If you weren… also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If you’re thinking about employing… textual explanation. Q: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I… that took half the time. An important conclusion of my presentation today is that sometimes you find unexpected differences in performance like… faster for this case, so your suggestion is a good one! Thanks again for attending my webinar! Here are some more tips…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… slave; Those of you who have already done these operations with file-based replication know that it is usually very tedious and… lagging behind). s2> select count(*) from t; +———-+ | count(*) | +———-+ | 2 | +———-+ # s1 is behind s1> select count(*) from t; +———-+ | count(*) | +———-+ | 0 | +———-+ Can we… recover the data with mysqlbinlog? There is a solution of course, but very poor in my opinion: look for the binlog file…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
This is my 10th year attending and speaking at the MySQL Users Conference (… years the conference is still pretty “hardcore,” attracting many real MySQL practitioners as speakers as well as attendees who all share their… trick question into the audience I get someone who is aware of the problem and is able to answer it… as opposed to…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… service provider lock-in. Customers should be able to choose who provides services for your product. Independent expertise. Customers like to… alternatives. This is not because everybody likes “free beer,” but because customers like freedom of choice. Everything here is my personal position, but…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… is modifying a given row once per RTT, it could get slower if apply times start to lag. So what about my… at once. But what will actually happen to the clients who try to update the same row within the same RTT… has that logic (I usually get less than 5 people who do out of 100). But, what to do? Retrying automatically…
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
As is typical at the beginning of every April, many of us who submitted talks to the Percona Live MySQL Conference and… many. I had 3 official talks selected, including one that is a 6-hour tutorial, as well as a BoF. Here… a replication technology that somehow prevents or handles replication conflicts is a usually bad idea. If you’ve considered an architecture…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… as promised, here are all of the questions and my answers. (A recording is available here.) Q: One of the links to… webinar? A: All the scripts are included in the slides. My setup was the following: 1 instance installed by the package… with MySQL Sandbox, with the sakila database Thanks to everyone who attended the MySQL webinar!
Post: Percona Live MySQL Conference and Expo 2013: It feels like 2007 again
March 21, 2013 By Leave a Comment
…, forks, times of uncertainly, more acquisitions, more forks, rumors (“Oracle is going to kill MySQL and the whole Internet”) and just… titled, “Percona XtraBackup: Old and New Features.” I actually traded my other talk, “MySQL 5.6 improvements from InnoDB internals prospective… Sunny anything about InnoDB internals: He is one of the few engineers in the world who knows everything about InnoDB. If you…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… all of the great keynote, tutorial, and breakout session speakers who presented insights into MySQL and MySQL-related technologies in over… Aslett of 451 Research very insightful. My major takeaways from those talks were: Oracle is investing a tremendous amount of time and… an engineering team of over 200 developers The release process is more agile, predictable, and effective than ever before thanks to…
