This Week in Data with Colin Charles 13: MariaDB, M18 and YugaByteColin Charles
This week we saw the closing of the CFPs for MariaDB’s user conference, M18. Peter Zaitsev and I submitted for Percona (don’t forget that there is also a developer’s conference tacked on to this event). We don’t have high expectations of getting a talk there, but hey – you never know! I submitted a talk on running MariaDB in the cloud (either hosted on Amazon RDS or Rackspace) or in your own compute instance. Another talk on capacity planning seemed to make sense as well.
An event Percona should be at is SCALE 16x, though I’ll admit I’m a bit surprised to see that there isn’t a dedicated MySQL track this year (the PostgreSQL track is still there).
MariaDB Corporation raised a total of $54m in 2017, with $27 being led by Alibaba Group in their latest round (completing the Series C funding round). The Reg reports claims that MariaDB has access to more than 60 million devs (is this number even higher than the MySQL developers out there?). The Techcrunch take. There hasn’t been any reporting of this in mainstream press like the Wall Street Journal or the Financial Times.
- MariaDB 10.2.10. Now comes with a stable (GA) MariaDB Backup, updated engines include InnoDB from 5.7.20 and CONNECT. innodb_defragment is also enabled by default – this should be really interesting to test, and an improvement for users.
- MariaDB 10.0.33. Comes with updated engines (TokuDB, InnoDB, XtraDB, CONNECT), as well as a newer PERFORMANCE_SCHEMA.
- HAProxy 1.8. A release candidate, but it has some impressive features: HTTP/2 protocol support, multithreading, and a whole lot more.
- Percona Monitoring and Management 1.4.1. Deploying on the Amazon Marketplace? Improvements to the metrics monitor too. Worth reading MySQL Dashboard Improvements in Percona Monitoring and Management 1.4.0.
- Percona XtraDB Cluster has some releases: Percona XtraDB Cluster 5.7.19-29.22-3 and Percona XtraDB Cluster 5.6.37-26.21-3.
- Amazon Aurora (MySQL) Speeds Join Queries by More than 10x with Asynchronous Key Prefetch. If your query would benefit from Batched Key Access (BKA) and Multi-Range Read (MRR), this is awesome for you.
- Scaling the GitLab database. Great read from production PostgreSQL users. They talk about connection pooling, load balancing, sharding, and a lot more.
- Modeling one-to-many in SQLite using the JSON1 extension
- Apache Kafka and the four challenges of production machine learning systems