This Week in Data with Colin Charles 35: Percona Live 18 final countdown and a roundup of recent news

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.

Percona Live is just over a week away — there’s an awesome keynote lineup, and you really should register. Also don’t forget to save the date as Percona Live goes to Frankfurt, Germany November 5-7 2018! Prost!

In acquisitions, we have seen MariaDB acquire MammothDB and Idera acquire Webyog.

Some interesting Amazon notes: Amazon Aurora Continues its Torrid Growth, More than Doubling the Number of Active Customers in the Last Year (not sure I’d describe it as torrid but this is great for MySQL and PostgreSQL), comes with a handful of customer mentions. In addition, there have already been 65,000 database migrations on AWS. For context, in late November 2017, it was 40,000 database migrations.

Releases

• Zstandard v1.3.4 – you can now tune compression parameters to go from near lz4 speeds, to near lzma ratios. Should this now be your go to compression format? Relevant from a MyRocks standpoint.
• DBdeployer – now a GA, at version 1. Goodbye MySQL Sandbox. Thanks for the awesome work Giuseppe Maxia! As he says, over 6,000+ tests performed.
• MariaDB 10.2.14 with MyRocks being Gamma (RC), bugs fixed. MariaDB 10.1.32 with bugs fixed. I guess both releases also have a new plugin, called DISKS, so the INFORMATION_SCHEMA now has a DISKS table.
• ProxySQL 1.4.8 just keeps getting better, with improvements even for ClickHouse backends.
• Percona Monitoring & Management (PMM) 1.9.1 now with faster loading of the index page with gzip/HTTP2, improvements for deployments on Amazon AWS, and something useful for Percona customers: the Percona Snapshot Server.
• Percona XtraBackup 2.4.10 with bug fixes, based on MySQL 5.7.19.
• Database Flow – self-describing, “Database Flow is an open source self-hosted SQL client, GraphQL server, and charting application that works with your database.”

Link List

• Amazon DynamoDB Continuous Backups and Point-In-Time Recovery (PITR) – continuous backup and restore with DynamoDB
• Managing db schema changes without downtime – from the co-founder of Discourse.
• All AWS Services GDPR ready
• What a Difference a Decade Makes – Stephen O’Grady on open source database adoption.
• 10 Steps to Develop an Incident Response Plan You’ll ACTUALLY Use
• Incident Post-Mortem and Security Advisory: Data Exposure After travis-ci.com Outage – be careful of those database queries
• PostgreSQL Begins Landing LLVM JIT Support For Faster Performance – incidentally have you also seen the work done by Vitesse Data?
• Monitoring PostgreSQL VACUUM processes
• textql – Execute SQL against structured text like CSV or TSV
• CockroachDB 2.0 Performance Makes Significant Strides
• GraphQL-to-MongoDB, or how I learned to stop worrying and love generated query APIs
• How Kustomer uses MongoDB and AWS to help fill in the gaps in the customer journey – I really enjoy reading these case studies that MongoDB are doing lately
• Enable your Devs to do Ops
• How to Speed-Up MongoDB Regex Queries by a Factor of up-to 10
• Building a Highly Available Web Application with Web Processing and Storing Capabilities Using MongoDB and Elk Stack

Upcoming appearances

• Percona Live 2018 – Santa Clara, California, USA – April 23-25 2018
• rootconf.in 2018 – Bangalore, India – May 10-11 2018
• Open Source Data Centre Conference – Berlin, Germany – June 12-13 2018
• DataOps Barcelona – Barcelona, Spain – June 21-22 2018
• OSCON – Portland, Oregon, USA – July 16-19 2018

Feedback

I look forward to feedback/tips via e-mail at [email protected] or on Twitter @bytebot.