This Week in Data with Colin Charles 41: Reflecting on GitHub’s Contribution to Open Source DatabaseColin Charles
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Some big news out from Microsoft about their acquisition of GitHub for $7.5 billion. GitHub hosts many projects, including from the MySQL ecosystem, but maybe more interesting is that their DBA team is awesome, give great talks, and are generally prolific writers. Some of the cool tools the MySQL world has gotten thanks to the excellent team include (but are not limited to): ccql, gh-ost for triggerless online schema migrations, and Orchestrator which is a GUI-based High Availability and replication management utility.
GitHub have given plenty of great presentations at past Percona Live events, and they’ve also written some excellent blog posts: MySQL infrastructure testing automation at GitHub, Mitigating replication lag and reducing read load with freno, Workload Analysis with MySQL’s Performance Schema, gh-ost: GitHub’s online schema migration tool for MySQL, Context aware MySQL pools via HAProxy, Orchestrator at GitHub, and a whole lot more.
Thank you for all the wonderful work, enjoy a beverage, and looking forward to more great stuff coming out of GitHub!
Over at Harvard Business Review, Paul V. Weinstein writes Why Microsoft Is Willing to Pay So Much for GitHub, and draws parallels to the MySQL acquisition by Sun Microsystems, stating that “MySQL’s value was strategic, not financial.”
An exclusive published at The Information, Oracle’s Aggressive Sales Tactics Are Backfiring With Customers was an interesting read. If you’re not a subscriber, the podcast The Information’s 411 — Oracles and Bad Omens is a free listen. To sum up, there have been some aggressive practices to get more people on the cloud, in lieu of server use audits. There is also naturally some customer unhappiness here.
There has been a lot of talk around GPU-based database providers (and some of this reminds me of the SQL-on-chip times, e.g. during Kickfire a decade ago). Alibaba Group leads $26.4M Series B in GPU database provider SQream, is the latest news in this space. Back in February, we heard about Brytlyt and MariaDB partnering up, and at Percona Live in April we saw a sponsor called BlazingDB in this space. Gamers have additional competition beyond just crypto-currency miners now for their GPUs: databases!
More database providers are now trading in the public markets, and here’s something interesting: Shares of software vendors Cloudera and MongoDB fall even as results beat estimates. Even though MongoDB declined as much as 5.6%, it is worth noting that it has been up 73%, year-to-date.
- SQLite Release 3.24.0 – now with non-standard SQL syntax, PostgreSQL style UPSERT.
- Have you tried mongo-monitor?
- Using Sequences in MariaDB Server? From a Java developer, do read MariaDB 10.3 supports database sequences.
- MySQL without the MySQL: An introduction to the MySQL Document Store – Dave Stokes from MySQL exposing the document store to a wider audience at opensource.com! It is just the tip of the iceberg, and I hope there is a lot more interest around this.
- We often know that in some emerging markets, pricing needs to be adjusted when it comes to boxed software. Nowadays, SaaS is all the rage, and I have to take my hat off for MongoDB Atlas doing a price reduction in Mumbai. 14% cheaper, the idea of “SaaS local pricing”, kudos for this MongoDB.
- Mastering MongoDB — Introducing multi-document transactions in v4.0
- Database folk know that it is a good idea to setup timezones as UTC. I recommend reading UTC is enough for everyone…right?. It is very well put.
- I/O Errors by Matthew Wilcox presented at PGCon.
- The original LSM paper – Mark Callaghan shares his notes on his re-read of the LSM Tree paper.
- While many of us were at Percona Live in Santa Clara this year, I didn’t realize that EuroSys was going on in Porto, Portugal. There was an interesting paper presented there: Reducing DRAM footprint with NVM in Facebook. From The Morning Paper, you can read an excellent summary. It has a lot of good information about MyRocks, how much of DRAM a typical server has (128GB), and a whole lot more. Since DRAM usage is reduced at Facebook, they have a 2nd level NVM-based cache. You too can enjoy MyRocks today in Percona Server for MySQL 5.7 and MariaDB Server 10.3, both are GA/stable releases! The paper is also a great read.
- SouthEastLinuxFest – Charlotte, NC, USA – June 8-10 2018
- Open Source Data Centre Conference – Berlin, Germany – June 12-13 2018 – code OSDC_FOR_FRIENDS gets you a discount
- DataOps Barcelona – Barcelona, Spain – June 21-22 2018 – code dataopsbcn50 gets you a discount
- OSCON – Portland, Oregon, USA – July 16-19 2018