… it’s time to give back. The call for papers (CFP) is now open for Percona Live London, November 11-12 at the… we need content for MySQL newcomers as well as the veterans. We’re also looking for sponsors. This is the showcase event for Europe’s…, DBAs and entrepreneurs. Download the prospectus and take a closer look at the benefits of sponsorship. Questions? Let me know in…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
….5.31), looking for optimizations with HAProxy to account for high connection rates, and using pacemaker with PXC. The goal is to reduce the overhead of status checks, mainly on the node. You can also look this PLMCE talk for HAProxy deployment strategies with PXC. To conclude, it is interesting to note that they…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… on your switching infrastructure). In essence, you’re looking for two of everything. Q: Is it possible to replicate only some tables from… explanation. Q: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6… you are using GTID-based replication, it looks like you’ll need to wait for the next release of MHA. Q: How…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… between tables versus observing queries only. An additional benefit is that SchemaSpy is command-line driven and builds the html after each… that the command line is shorter and neater. In my case here is the properties file in use for my Percona Server 5… you’re looking for other examples you can find a more comprehensive example here. Running SchemaSpy The syntax below if specific for MySQL…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… of looking for the binlog position of a specific event. The only part were we should pay attention is the server we choose for… UUID of s2, and that the other one is from s0 (for s0 which is crashed, the server UUID can be read in… the data with mysqlbinlog? There is a solution of course, but very poor in my opinion: look for the binlog file/position of…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
Hi, I was looking for your forum to ask this but it seems to be … long running select query. A query runs for say 300 seconds and because the resultset is huge, it eventually starts creating a…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… is okay because each correlation name (k1, k2, k3) is an index lookup. Look at the EXPLAIN output — it accesses these first, by looking… this solution was 150x faster for this case, so your suggestion is a good one! Thanks again for attending my webinar! Here are… our events. The next one is in London on November 11-12, 2013. We also look forward to the Percona Live MySQL…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…-checker –tables test.test # ######################################################################## # test.test # ######################################################################## # col2 is a left-prefix of col2_2 # Key …GA release, have a look at our upcoming sessions for the “Moving to 5….
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… by compression. If I use SSD for L2ARC, I’ll need to do the same for xfs… I am redoing my tpcc… difference right there. Will keep you posted. It is not an easy move for a MySQL dba to steal 20GB memory from… took a look at OmniOS but frankly it was the first time I read something about it. How different is it from…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… for a MySQL HA infrastructure is as much a business and philosophical decision as it is a technical one, but often the choice is… without adequately considering all three perspectives. When too much attention is paid to one of these aspects at the cost of… interests you, then register today to reserve your spot. I look forward to speaking with all of you next week.
