This Week in Data with Colin Charles 25: Meltdown/Spectre still dominate, FOSDEM approaches and Timescale gets fundingColin Charles
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Still on Meltdown/Spectre, this time MariaDB Corporation has published Meltdown Vulnerability Impact On MariaDB Server – interesting the comparison between glibc/tcmalloc. Worthy Facebook thread about this too, with a bit of chat about MongoDB performance. Officially MongoDB says a degradation of 10-15%. ScaleGrid has a good post, in which they test MongoDB against AWS/Azure/DigitalOcean. It’s interesting that on AWS they see a 4-5% hit on insert workloads, but on Azure its 10-20% and on DigitalOcean its 30%! (The comparison for the balanced workload is that on AWS its 2-3%, 20-205% on Azure, and 30% on DigitalOcean).
We’ve chosen tutorials for Percona Live Santa Clara, and will be announcing them soon; and by the first week of February most talks as well. Don’t forget you have the option to still get the best price at registration now.
Don’t forget that in the next week, we have FOSDEM — many Perconians will be there and look forward to meeting with you. We have a community table. Peter Zaitsev has a talk in the main track. Don’t forget the fringe events: on 2nd February there is a pre-FOSDEM MySQL Day, the MySQL & Friends Community Dinner, and also a CentOS Dojo that I will be speaking at. Looking forward to a packed & fun-filled Friday, Saturday and Sunday!
It’s worth reading this: Timescale raises $16M from Benchmark, NEA, Two Sigma Ventures for the database to help us understand our machines and our world. Timescale has been an active participant in the Percona Live events, and this round of funding bodes very well for the PostgreSQL database world.
- MySQL 8.0.4 Release Candidate – this is a big deal, highly recommended for testing; plenty of blog posts on the MySQL Server Team blog as well as in this very Percona blog. Read the release notes as well.
- Percona Monitoring and Management (PMM) 1.6.1 – fresh off the heels of 1.6.0, more new features for PMM
- Percona XtraDB Cluster 5.6.38-26.23
- MariaDB 5.5.59
- Citus and pg_partman: Creating a scalable time series database on Postgres – Postgres 10 brings you native time partitioning, and with the Citus extension you can create tables distributed across nodes by ID and partitioned by time.
- antirez tells us he’s spending a lot of time working on Redis Streams
- Cut down database imports by a third using this one weird trick – an open source PostgreSQL bulk loader.
- Building a Distributed Log from Scratch, Part 5: Sketching a New System – its a many part series, all interesting if you have the time to read it.
- AWS Aurora Postgres, not a great first impression – I think the best part is the comments, where the product manager chimes in, about shared_buffers, and the fact that they are working on an Aurora PostgreSQL best practices document.
- Enhanced replication monitoring in ProxySQL 1.4.4 – in where ProxySQL works well with pt-heartbeat.
- Stream all the things – Nice video, focusing on streaming architectures for data sets that never end.
- CentOS Dojo Brussels – Brussels, Belgium – February 2 2018
- FOSDEM 2018 – Brussels, Belgium – February 3-4 2018
- SCALE16x – Pasadena, California, USA – March 8-11 2018
I look forward to feedback/tips via e-mail at firstname.lastname@example.org or on Twitter @bytebot.