This Week in Data with Colin Charles #3: More Percona Live Europe!Colin Charles
We are five weeks out to the conference! The tutorials and the sessions have been released, and there’s an added bonus – you can now look at all this in a grid view: tutorials, day one and day two. Now that you can visualize what’s being offered, don’t forget to register.
If you want a discount code, feel free to email me at email@example.com.
We have some exciting keynotes as well. Some highlights:
- MySQL as a Layered Service: How to Use ProxySQL to Control Traffic and Scale Out, given by René Cannaò, the creator of ProxySQL
- Why Open Sourcing Our Database Tooling was the Smart Decision, given by Shlomi Noach, creator of Orchestrator, many other tools, and developer at GitHub (so expect some talk about gh-ost)
- MyRocks at Facebook and a Roadmap, given by Yoshinori Matsunobu, shepherd of the MyRocks project at Facebook
- Real Time DNS Analytics at CloudFlare with ClickHouse, given by Tom Arnfeld
- Prometheus for Monitoring Metrics, given by Brian Brazil, core developer of Prometheus
- A Q&A session with Charity Majors and Laine Campbell on Database Reliability Engineering, their new upcoming book!
Let’s not forget the usual State of the Dolphin, an update from Oracle’s MySQL team (representative: Geir Høydalsvik), as well as a keynote by Peter Zaitsev (CEO, Percona) and Continuent. There will also be a couple of Percona customers keynoting, so expect information-packed fun mornings! You can see more details about the keynotes here: day one and day two.
- Tarantool 1.7.5 stable. The first in the 1.7 series that comes as stable, and it also comes with its own Log Structured Merge Tree (LSM) engine called Vinyl. They wrote this when they found RocksDB insufficient for them. Slides: Vinyl: why we wrote our own write-optimized storage engine rather than chose RocksDB (and check out the video).
- MariaDB Server 10.2.8. A– as per my previous column, this build merges TokuDB from Percona Server 5.6.36-82.1 (fixing some bugs). There is also a new InnoDB from MySQL 5.7.19 (current GA release). Have you tried MariaDB Backup yet? There are some GIS compatibility fixes (i.e., to make it behave like MySQL 5.7). One thing that piqued my interest is the CONNECT storage engine (typically used for ETL operations) now has beta support for the MONGO table type. No surprises, it’s meant to read MongoDB tables via the MongoDB C Driver API. Definitely something to try!
- Comparing high availability for Google Cloud SQL and Amazon RDS by Preetam Jinka. Focuses only on Google Cloud SQL and Amazon AWS RDS (so new entrants like Microsoft, or even stalwarts like Rackspace are missing from this comparison). Come to Percona Live Dublin and listen to the talk Microsoft Loves MySQL and PostgreSQL to find out more about their new offering!
- Fun with Bugs #55 – On Some Public Bugs Fixed in MySQL 8.0.2. Valeriy Kravchuk looks at MySQL 8.0.2 bugs, and makes the statement “Percona seems to care a lot about improving MySQL 8.0 (as well as other Oracle MySQL GA versions).” He’s right, Percona really does care about making MySQL better.
- MyRocks my.cnf changes from June 16 to Aug 15. Mark Callaghan record of changes, and it’s important if you’re playing around with MyRocks.
- LDAP with auth_pam and PHP to authenticate against MySQL. Sheeri Cabral tells you how to use Percona’s PAM authentication plugin with PHP (so compiling php-cli).
- Creating better disaster recovery plan. Five questions for Tanya Reilly, Site Reliability Engineer at Google, who shares her thoughts on how to make better disaster recovery plans.
Percona’s website keeps track of community events, so check out where to listen to a Perconian speak. My upcoming appearances are:
- db tech show case Tokyo 2017 – 5-7 September 2017, Tokyo, Japan
- Open Source Summit North America – 11-14 September 2017, Los Angeles, CA, USA
- Percona Live Europe Dublin – 25-27 September 2017, Dublin, Ireland
- Velocity Europe – 17-20 October 2017, London, UK
- Open Source Summit Europe – 23-26 October 2017, Prague, Czech Republic
Bill Bogasky (MariaDB Corporation) says that if you’re looking for commercial support for Riak now that Basho has gone under, you could get it from Erlang Solutions or TI Tokyo. See their announcement: Riak commercial support now available post-Basho. Thanks, Bill!