This Week in Data with Colin Charles: Percona Live Europe!Colin Charles
Has a week passed already? Welcome back to the second column. A lot of time has been spent neck deep in getting speakers accepted and scheduled for Percona Live Open Source Database Conference Europe 2017 in Dublin, as well organizing the conference sponsors.
Percona Live Europe Dublin
At the time of writing, we are six weeks away from the conference, so a little over a month! Have you registered yet?
We have 12 tutorials that cover a wide range of topics: ProxySQL (from the author Rene Cannao), Orchestrator (from the author Shlomi Noach), practical Couchbase (to name a few). If we did a technology word cloud, the coverage includes MongoDB, Docker, Elastic, Percona Monitoring and Management (PMM), Percona XtraDB Cluster 5.7, MySQL InnoDB Cluster and Group Replication.
In addition to that, if you’re a MySQL beginner (or thinking of a career change) there is a six-hour boot camp titled MySQL in a Nutshell (Part 1 and Part 2)!. Come prepared with your laptop, and leave a MySQL DBA!
Remember that you have till 7:00 a.m. UTC-1, August 16th, 2017 to book the group rate at the event venue for €250/night. Use code PERCON.
- orchestrator/raft: Pre-release 3.0 is available. I’m a huge fan of Orchestrator, and now you can setup high availability for orchestrator via the Raft consensus protocol.
- MariaDB 10.0.32 is out, and it comes with a new Percona XtraDB, Percona TokuDB and a new InnoDB. You’ll want this release if you’re using TokuDB, as it merges from TokuDB 5.6.36-82.1 (which fixes the two issues problem).
- If you encountered the TokuDB problems above, you’ll want to look at MariaDB 10.1.26. One surprise hidden in the release notes: MariaDB Backup is now a stable/GA release. Have you used it yet?
- dbKoda is a next generation database development and administration tool now available for MongoDB, from Guy Harrison’s company (of MySQL Stored Procedure Programming book fame).
- An Adventure in InnoDB Table Compression (for read-only tables).
- If you read Korean, there’s an interview with me in their press.
- In MariaDB 10.2, you really want to remove any XtraDB options you have in your my.cnf. This includes options like innodb_flush_method = ALL_O_DIRECT.
- Kristian Nielsen writes passionately about MariaDB Server’s InnoDB merges, and how a merge error introduced extra fsync() calls.
- If you’re interested in how the sausage is made, some interesting questions were asked as of late: How was this records/fanout logic derived for the “no statistics” case in MySQL’s Query Planner? (and a little more). In addition, what is the history of lf_hash (with the associated paper “Split-Ordered Lists: Lock-Free Extensible Hash Tables” by Ori Shalev and Nir Shavit that you can easily search for).