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

I think the biggest news from last week was from cPanel – if you haven’t already read the post, please do – on Being a Good Open Source Community Member: Why we hesitated on MySQL 5.7. cPanel anticipated MariaDB being the eventual replacement for MySQL, based on movements from Red Hat, Wikipedia and Google. The advantage focused on transparency around security disclosure, and the added features/improvements. Today though, “MySQL now consistently matches or outpaces MariaDB when it comes to development and releases, which in turn is increasing the demand on us for providing those upgraded versions of MySQL by our users.” And maybe a little more telling, “when MariaDB 10.2 became stable in May 2017 it included many features found in MySQL 5.7. However, MySQL reached stable nearly 18 months earlier in October 2015.” (emphasis mine).

So cPanel is going forth and supporting MySQL 5.7. They will continue supporting MariaDB Server for the foreseeable future. This really is cPanel ensuring they are responsive to users: “The people using and building database-driven applications are doing so with MySQL in mind, and are hesitant to add support for MariaDB. Responding to our community’s desires is one of the most important things to us, and this is something that we are hearing asked for from our community consistently.”

I, of course, think this is a great move. Users deserve choice. And MySQL has features that are sometimes still not included in MariaDB Server. Have you seen the Complete list of new features in MySQL 5.7? Or my high-level response to a MariaDB Corporation white paper?

I can only hope to see more people think pragmatically like cPanel. Ubuntu as a Linux distribution still does – you get MySQL 5.7 as a default (very unlike the upstream Debian which ships MariaDB Server nowadays). I used to be a proponent of MariaDB Server being everywhere, when it was community-developed, feature-enhanced, and backward-compatible. However, the moment it stopped being a branch and a true fork is the moment where trouble lies for users. I think it was still marginally fine with 10.0, and maybe even 10.1, but the ability to maintain feature parity with enhanced features has long gone. Short of a rebase? But then… what would be different to the already popular branch of MySQL called Percona Server for MySQL?

While there are wins and support from cloud vendors, like Amazon AWS RDS and Microsoft Azure, you’ll notice that they offer both MySQL and MariaDB Server. Google Cloud SQL notably only offers MySQL. IBM may be a sponsor of the MariaDB Foundation, but I don’t see their services like Compose offering anything other than MySQL (with group replication nonetheless!). Platinum member Alibaba Cloud offers MySQL and PostgreSQL. However, Tencent seems to suggest that MariaDB is coming soon? One interesting statistic to watch would be user uptake naturally.

Events

From an events standpoint, the Percona Live 2018 Call for Papers has been extended to January 12, 2018. We expect an early announcement of maybe ten talks in the week of  January 5. Please submit to the CFP. Have you got your tickets yet? Nab them during our Percona Live 2018 super saver registration when they are the best price!

FOSDEM has got Sveta and myself speaking in the MySQL and Friends DevRoom, but we also have good news in the sense that Peter Zaitsev is also going to be at FOSDEM – speaking in the main track. We’ll also have plenty of schwag at the stand.

I think it’s important to take note of the updates to Percona bug tracking: yes, its Jira all the way. Would be good for everyone to start also looking at how the sausage is made.

Dragph, a “distributed fast graph database“, just raised $3m and released 1.0. Have you used it?

On a lighter note, there seems to be a tweet going around by many, so I thought I’d share it here. Merry Christmas and Happy Holidays.

He’s making a database
He’s sorting it twice
SELECT * FROM girls_boys WHERE behaviour = “nice”
SQL Claus is coming to town!

Releases

• Percona Monitoring and Management 1.5.3
• ProxySQL 1.4.4 – some interesting features include bandwidth throttling, limit connections to backends, monitoring replication lag, and more.
• MariaDB Server 10.2 is in CentOS 6 and CentOS 7 via Software Collections.

Link List

• Good presentation on multi-user Presto usage.
• You probably must be dabbling with containers, so Google released container-diff, a tool for quickly comparing container images. Check it out on GitHub.
• James Governor (RedMonk), writes On AWS and Pivotal, opinions and overlaps.
• That time Larry Ellison allegedly tried to have a professor fired for benchmarking Oracle
• Apache Cassandra users, should you use incremental repair?

Upcoming appearances

• FOSDEM 2018 – Brussels, Belgium – February 3-4 2018
• SCALE16x – Pasadena, California, USA – March 8-11 2018

Feedback

I look forward to feedback/tips via e-mail at colin.charles@percona.com or on Twitter @bytebot.

Percona is extending the Percona Live 2018 call for papers deadline to January 12, 2018!

Percona’s gift to you this holiday season is the gift of time – submit your speaking topics right up until January 12, 2018!

As the year winds up, we received many requests to extend the Percona Live Open Source Database Conference 2018 call for papers. Since many speakers wanted to submit during the week that they’re planning vacations (from Christmas until New Year’s Day), we realized that December 22 was too soon.

If you haven’t submitted already, please consider doing so. Speaking at Percona Live is a great way to talk about what you’re doing, build up your personal and company brands, and get collaborators to your project. If selected, all speakers receive a full complimentary conference pass.

Percona Live 2018 is the destination to share, learn and explore all pertinent topics related to open source databases. The theme for Percona Live 2018 is “Championing Open Source Databases,” with topics on MySQL, MongoDB and other open source databases, including time series databases, PostgreSQL and RocksDB. Session tracks include Developers, Operations, and Business/Case Studies.

Remember, just like last year, we aren’t looking for just MySQL-ecosystem–related talks (that includes MariaDB Server and Percona Server for MySQL). We are actively looking for talks around MongoDB, as well as other open source databases (so this is where you can add PostgreSQL, time series databases, graph databases, etc.). That also involves complementary technologies, such as the increasing importance of the cloud and container solutions such as Kubernetes.

Talk about your journey to open source. Describe the technical and business values of moving to or using open source databases. How did you convince your company to make the move? Was there tangible ROI? Share your case studies, best practices and technical knowledge with an engaged audience of open source peers.

We are looking for breakout sessions (25 or 50 minutes long), tutorials (3 hours or 6 hours long), and lightning talks and birds of a feather sessions. Submit as many topics as you think you can deliver well.

The conference itself features one day of tutorials and two days of talks. There will also be exciting keynote talks. Don’t forget that registration is now open, and our Super Saver tickets are the best price you can get (Super Saver tickets are on sale until January 7, 2018).

If your company is interested in sponsoring the conference, please take a look at the sponsorship prospectus.

All in, submit away and remember the Percona Live 2018 call for papers deadline is January 12, 2018. We look forward to seeing you at the conference from April 23-25 2018 in Santa Clara.

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

Hurry up – the call for papers (CFP) for FOSDEM 2018 ends December 1, 2017. I highly recommend submitting as its a really fun, free, and technically-oriented event.

Don’t forget that the CFP for Percona Live Open Source Database Conference 2018 in Santa Clara closes December 22, 2017, so please also consider submitting as soon as possible. We want to make an early announcement of the talks, so we’ll definitely do the first pass even before the CFP date closes.

Is ARM the new hotness? Marvell confirms $6 billion purchase of chip maker Cavium. This month we’ve seen Red Hat Enterprise Linux for ARM arrive. We’ve also seen a press release from MariaDB about the performance on the Qualcomm Centriq 2400 Processor.

Some new books to add to your bookshelf and read: MariaDB and MySQL Common Table Expressions and Window Functions Revealed by Daniel Bartholomew. The accompanying source code repository will also be useful. Much awaited for, by Percona Live keynote speakers, Database Reliability Engineering: Designing and Operating Resilient Database Systems by Laine Campbell and Charity Majors is now ready to read.

Releases

• Percona Toolkit 3.0.5 – improvements for MongoDB and MySQL here

Link List

• Easily restore an Amazon RDS MySQL database from your MySQL backup – using Percona XtraBackup, and uploading the resulting export to S3.
• Amazon RDS Now Supports Database Storage Size up to 16TB and Faster Scaling for MySQL, MariaDB, Oracle, and PostgreSQL Engines – 16TB for MySQL/MariaDB/PostgreSQL, storage limit is now 6TB, and provisioned IOPS (PIOPS) up to 40,000 from 30,000.
• Amazon RDS for MySQL and MariaDB Supports R4, T2 and M4 Instance Types
• The Expendables — Backends High Availability at BlaBlaCar – learn about the backend, that includes MariaDB Server, from the long-distance ridesharing community site, BlaBlaCar.
• Shenzhen MariaDB Developers Unconference Reportback – great read, wondering why the 10.4 plans aren’t public yet
• The Hacker News thread – ZFS from a MySQL perspective – commentary worth a read
• Sheeri wrote MySQL 5.7 InnoDB Temporary Tablespace – but why? The comments there are good reading, but in addition, Valerii’s Facebook thread is also worth a read.
• Several locks taken to the same record inside a transaction.
• Does PostgreSQL have transportable tablespaces or an equivalent?

Upcoming appearances

• ACMUG 2017 gathering – Beijing, China, December 9-10 2017 – it was very exciting being there in 2016, I can only imagine it’s going to be bigger and better for 2017 since it is now two days long!

Feedback

I look forward to feedback/tips via e-mail at colin.charles@percona.com or on Twitter @bytebot.

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

This week was exciting from a Percona exposure standpoint. We were at Open Source Summit Europe. I gave two talks and participated in a panel, as the co-located event for the Open Source Entrepreneur Network happened on the last day as well. We had a booth, and it was great to hang out and talk with my colleagues Dorothée Wuest and Dimitri Vanoverbeke as well as all the attendees that popped by.

Releases

• Percona Server for MongoDB 3.4.9-2.9. The RocksDB library is now at 5.7.3, which you use with MongoRocks.
• Percona Monitoring and Management 1.4.0. You can now have external Prometheus exporters, so use it to create dashboards for monitoring other services not provided by PMM itself. Prometheus, Grafana and Consul have all been updated as well.
• SQLite 3.21.0. SQLite now has atomic write capabilities when the Flash-Friendly File System (F2FS) is available, which should provide greatly reduced transaction overhead.

Link List

• From GitHub: Mitigating replication lag and reducing read load with freno.
• A crashing bug in MySQL: the CREATE TABLE of death (more fun with InnoDB Persistent Statistics).
• The Future of RethinkDB. A podcast with Mike Glukhovsky (co-founder of RethinkDB). Spend 70 minutes to learn about the shutdown, getting purchased by the Cloud Native Computing Foundation and a lot more.
• Serverless computing: economic and architectural impact. Are you thinking more about the serverless movement?
• “Why We Built Our Own Distributed Column Store” by Sam Stokes. Our friends at Honeycomb gave an excellent talk about motivations around this.

Feedback

I look forward to feedback/tips via e-mail at colin.charles@percona.com or on Twitter @bytebot.

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

Beyond spending time getting ready for Velocity and Open Source Summit Europe this week, there was some feature testing this week that compared MySQL and MariaDB. Naturally, a long report/blog is coming soon. Stay tuned.

Releases

I reckon a lot of folks are swamped after Percona Live Europe Dublin and Oracle OpenWorld, so the releases in the MySQL universe are a bit quieter.

• Percona Monitoring and Management 1.3.2. Fixes around Query Analytics
• MariaDB 10.3.2. Another alpha release that included instant ADD COLUMN contributed by Tencent, as well as storage-engine-independent column compression contributed by Tencent/AliSQL. Percona Server for MySQL has column compression, but this is naturally a different implementation. Read more about Storage-Engine-Independent Column Compression, compare it with Compressed columns with dictionaries if you like, and probably the best documentation for instant ADD COLUMN is this blog post.

Link List

• Query Analyzer: A Tool for Analyzing MySQL Queries Without Overhead. This is a cool post from LinkedIn.
• How To Test the Database. Daniel Nichter of Hack MySQL fame now writes at his new site, Hack Mongo.
• Different I/O Access Methods for Linux, What We Chose for Scylla, and Why. While the article has ScyllaDB in the title, it stands on its own when it comes to learning about different I/O patterns and tradeoffs. Well worth a read.
• Distributed consistency at scale: Spanner vs. Calvin
• The MySQL 8.0.3 release candidate has backup locks, quite similar to what’s been in Percona Server for MySQL. This is great news!
• Andy Jassy tweeted that Amazon Web Services Database Migration Service just hit 40,000 migrations. This is amazing, considering the service launched late 2015 and the general idea has always been “migrations are hard, start your next database project with the new tool.”

Upcoming Appearances

Percona’s website keeps track of community events, so check out where to see and listen to a Perconian speak. My upcoming appearances are:

• Velocity Europe – 17-20 October 2017, London, UK
• Open Source Summit Europe – 23-26 October 2017, Prague, Czech Republic

Feedback

I was asked why there weren’t many talks from MariaDB Foundation / MariaDB Corporation at Percona Live Europe 2017. Simple answer: there were hardly any submissions. We had two talk submissions from one speaker from the MariaDB Foundation (we accepted the one on MariaDB 10.3). There was another talk submission from a speaker from MariaDB Corporation (again, accepted). We announced the second talk in the sneak preview, but the talk was canceled as the speaker was unable to attend. We did, however, have a deep breadth of talks about MariaDB, with many talks that discussed high availability, security, proxies and the like.

I look forward to feedback/tips via e-mail at colin.charles@percona.com or on Twitter @bytebot.

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

This week: a quick roundup of releases, a summary of my thoughts about Percona Live Europe 2017 Dublin, links to look at and upcoming appearances. Oracle OpenWorld happened in San Francisco this past week, and there were lots of MySQL talks there as well (and a good community reception). I have a bit on that as well (from afar).

Look for these updates on Planet MySQL.

Releases

• Red Hat Software Collections 3.0 Beta now has MariaDB 10.2.7, MongoDB 3.4.7 and PostgreSQL 9.6.4 installable on RHEL6 and RHEL7 via SCL. How many deploy with Software Collections?
• PostgreSQL 10 released with logical replication, parallel query, SCRAM-SHA-256 authentication and more. Josh Berkus’ article on LWN is still relevant: A beta for PostgreSQL 10.
• RMariaDB: Database Interface and ‘MariaDB’ Driver is interesting if you’re into R as this driver works for MariaDB AND MySQL, whereas the RMySQL driver is considered legacy! Interesting naming choice?

Percona Live Europe Dublin

I arrived on Sunday and chose to rest for my tutorial on Monday. Ronald Bradford and I delivered a tutorial on MySQL Security, and in the morning we chose to rehearse. Percona Live Europe had a full tutorial schedule this year, albeit with one cancellation: MySQL and Docker by Giuseppe Maxia, whom we missed this conference. Check out his blog for further posts about MySQL, Docker, and SQL Roles in MySQL 8!

We had the welcome reception at Sinott’s Bar. There was a large selection of food on each table, as well as two drinks for each of us. It was lively, and I think we overtook most of the basement. Later that evening, there were drinks around the hotel bar, as people started to stream in for Tuesday’s packed schedule!

Tuesday was the conference kickoff, with Peter Zaitsev doing the opening keynote on the state of the open source database ecosystem. The bonus of this keynote was also the short 5-minute talks that would help you get a pick on the important topics and themes around the conference. I heard good things about this from attendees. While most people attended the talks, I spent most of my day in meetings! Then the Community Dinner (thank you Oracle for sponsoring), where we held this year’s Lightning Talks (and plenty more to drink). A summary of the social events is at Percona Live Europe Social.

Wednesday morning we definitely wanted to start a few minutes later, considering people were streaming in slower thanks to the poor weather (yes, it rained all day). The State of the Dolphin ensured we found out lots of new things coming to MySQL 8.0 (exciting!), then the sponsor keynote by Continuent given by MC Brown, followed by a database reliability engineering panel with the authors of Database Reliability Engineering Charity Majors and Laine Campbell. Their book signing went quickly too – they have many fans. We also heard from Pepper Media on their happy journey with Percona. Another great day of talks before the evening reception (which had less folk, since people were flying off that evening). Feel free to also read Matthias Crauwels, Percona Live Europe 2017 Review.

Percona Live Europe 2017 Dublin had over 350+ attendees, over 140+ speakers – all in a new location! If you have any comments please feel free to shoot me an email.

Oracle OpenWorld from Afar

At this year’s Oracle OpenWorld there was talk about Oracle’s new self-driving, machine-learning based autonomous database. There was a focus on Amazon SLAs.

It’s unclear if this will also be what MySQL gets eventually, but we have in the MySQL world lossless semi-sync replication. Amazon RDS for MySQL is still DRBD based, and Google Cloud SQL does use semisync – but we need to check further if this is lossless semisync or not.

Folk like Panoply.io claim they can do autonomous self-driving databases, and have many platform integrations to boot. Anyone using this?

Nice to see a Percona contribution to remove InnoDB buffer pool mutex get accepted, and apparently it was done the right way. This is sustainable engineering: fix and contribute back upstream!

I was particularly interested in StorageTapper released by Uber to do real-time MySQL change data streaming and transformation. The slide deck is worth a read as well.

Booking.com also gave a talk. My real takeaway from this was about why MySQL is strong: “thousands of instances, a handful of DBAs.” Doug Henschen also talks about a lot of custom automation capabilities, the bonus of which is many are probably already open source. There are some good talks and slide decks to review.

It wouldn’t be complete without Dimitri Kravtchuk doing some performance smackdowns, and I highly recommend you read MySQL Performance: 2.1M QPS on 8.0-rc.

And for a little bit of fun: there was also an award given to Alexander Rubin for fixing MySQL#2: does not make toast. It’s quite common for open source projects to have such bugs, like the famous Ubuntu bug #1. I’ve seen Alexander demo this before, and if you want to read more check out his blog post from over a year ago: Fixing MySQL Bug#2: now MySQL makes toast! (Yes, it says April 1! but really, it was done!) Most recently it was done at Percona Live Santa Clara 2017.

Link List

• Bossie Awards 2017 is out, showcasing the best open source databases and analytical tools. Featured: CockroachDB (based on the Spanner paper), MapD (GPU-powered in-memory database), CrateDB, Greenplum (thank you Pivotal!), Apache Spark, Apache Solr, Apache Arrow, Apache Kudu, Apache Zeppelin, the R Project, Apache Kafka, Cruise Control for Apache Kafka to help manage it, JanusGraph, and Apache TinkerPop. We’ll aim to have relevant sessions on these at Percona Live Santa Clara 2018.
• Franchise is an open source notebook for SQL; Redash is cloud-based, query, visualize and share.
• Query the planet: Geospatial big data analytics at Uber is a deep dive into Uber’s engineering effort to optimize geospatial queries in Presto.
• A Decade of Dynamo: Powering the next wave of high-performance, internet-scale applications is a great retrospective post on Amazon’s Dynamo from Werner Vogels.
• Time Series Database Lectures – Fall 2017 is the CMU Database Group focusing on time series database internals, with recorded videos. Highly recommended. At Percona, we’ve been watching time series databases getting popular and have made them one of our themes for the Percona Live conferences in 2017. 

Upcoming appearances

Percona’s website keeps track of community events, to see where to listen to a Perconian speak. My upcoming appearances are:

• Velocity Europe – 17-20 October 2017, London, UK
• Open Source Summit Europe – 23-26 October 2017, Prague, Czech Republic

Feedback

I look forward to feedback/tips via e-mail at colin.charles@percona.com or on Twitter @bytebot.

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

Percona Live Europe 2017 Dublin

We’ve spent a lot of time in the last few months organizing Percona Live Europe Dublin. I want to thank all the speakers, sponsors and attendees for helping us to pull off yet another great event. While we’ll provide some perspectives, thoughts and feedback soon, all the early mornings, jam-packed meetings and the 4 am bedtimes means I’ll probably talk about this event in my next column!

In the meantime, save the date for Percona Live Santa Clara, April 23-25 2018. The call for papers will open in October 2017.

Releases

• MariaDB 10.1.27. Percona XtraDB and TokuDB got updated from 5.6.37-82.2. Encryption gets tighter when it comes to temporary tables (fixes MDEV-12634).
• MySQL 8.0 is now a Release Candidate. You’ll want to read the highlights. As well as changes in replication.
• Percona XtraDB Cluster 5.7.19-29.22. New instrumentation to get a unified view of the cluster, new Percona XtraBackup support for encrypting data and backup threads.

Link List

• Why SQL is beating NoSQL, and what this means for the future of data – was SQL really being left for dead? It doesn’t feel like that to me, but this is an interesting read from our friends at TimeScale.
• It’s become unfashionable to talk about MariaDB MaxScale after the change to business source licensing, but after all this time (over a year now), there is a “list” of projects that use the BSL, including the ability to backup and restore MariaDB ColumnStore.
• Yahoo! makes Vespa open source. At Yahoo! this is the big data processing and serving engine.
• MySQL 8.0 Will Bring Unicode 9.0, Schema-less JSON, Greater Geospatial Support
• MariaDB ColumnStore engineer, Andrew Hutchings writes about Correcting MariaDB ColumnStore Benchmarks. “The moral of this story is don’t trust other people’s benchmarks.” I would like to see some MariaDB ColumnStore vs. ClickHouse benchmarks!
• Migrating a database from InnoDB to MyRocks – Yoshinori Matsunobu, speaker at Percona Live Europe Dublin (and many other such events) and MyRocks hacker, tells us how they migrated Facebook’s UDB completely last month. The UDB maintains Facebook’s social graph, and they cut their storage usage in half! Also, “Finally, we will work to support MyRocks for the upcoming MySQL 8.0,” is very promising because this shows continued investment in MyRocks and MySQL by Facebook.

Upcoming appearances

Percona’s website keeps track of community events, so check out where to listen to a Perconian speak. My upcoming appearances are:

• Velocity Europe – 17-20 October 2017, London, UK
• Open Source Summit Europe – 23-26 October 2017, Prague, Czech Republic

Feedback

I look forward to feedback/tips via e-mail at colin.charles@percona.com or on Twitter @bytebot.

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

Percona Live Europe Dublin

Are you affected by the Ryanair flight cancellations? Have you made alternative arrangements? Have you registered for the community dinner? Even speakers have to register, so this is a separate ticket cost! There will be fun lightning talks in addition to food and drink.

You are, of course, already registered for Percona Live Europe Dublin, right? See you there! Don’t forget to pack a brolly, or a rain jacket (if this week’s weather is anything to go by).

Open Source Summit North America

Last week, a lot of open source folk were in Los Angeles, California for the annual Open Source Summit North America (formerly known as LinuxCon). I’ve been to many as a speaker, and have always loved going to the event (so save the date, in 2018 it is August 29-31 in Vancouver, British Columbia, Canada).

What were major themes this year? Containerization. Everyone (large and small) seem to be moving workloads into containers. Containers and stateful applications make things all the more interesting, as well as thoughts on performance. This is a big deal for us in the MySQL/MongoDB/other open source database space. Technologies to watch include: Docker/Moby, Kubernetes, and Mesos. These are technologies people are frankly already deploying on, and it looks like the on-ramp is coming. Videos to watch:

• Are containers the future of IaaS? 
• The Anti-Pattern Wall of 2011 has Crumbled: Stateful Applications in Containers.

The cloud is still a big deal. Yes, people are all customers of Amazon Web Services. Sure they are looking at Microsoft Azure. Google Cloud Platform is – from my informal survey – the third most popular. In many instances, I had conversations about Oracle Cloud, and it looks like there is a huge push behind this (but not too many users that I’ve seen yet). So it’s still a bet on the future as it continues to be developed by engineers. A mention of Rackspace Cloud (which offers all the MySQL variants in the cloud) is good, but many large-scale shops haven’t thought about it.

There were also some “fun” keynotes:

• Open as In: Zeynep Tufekci – you want to read his book, Hooked: How to Build Habit-Forming Products
• Disrupted: My Misadventure in the Start-Up Bubble: Dan Lyons – also with an excellent book, Disrupted: My Misadventure in the Start-Up Bubble.

I wish more events had this kind of diverse keynotes.

From a speaker standpoint, I enjoyed the speaker/sponsor dinner party (a great time to catch up with friends and meet new ones), as well as the t-shirt and speaker gift (wooden board). I had a great time at the attendee expo hall reception and the party at Paramount Studios (lots of fun catered things, like In-N-Out burgers!).

Releases

• ProxySQL 1.4.3. Hot on the heels of 1.4.2 comes 1.4.3, nicknamed “The ClickHouse release.” Clients can connect to ProxySQL, and it will query a ClickHouse backend. Should be exciting for ClickHouse users. Don’t forget the SQLite support, too!
• Percona XtraDB Cluster 5.6.37-26.21
• MariaDB ColumnStore 1.1.0 Beta. Do you use ColumnStore? Or do you use ClickHouse? There’s a new beta that might be worth trying.
• MySQL 8.0.3 Release Candidate. Download this on your way to Percona Live Europe Dublin! Try it. There are many talks for this, including a keynote. You’ll find things like Histograms, more improvements around the optimizer, JSON and GIS improvements, security improvements, resource groups seem very interesting, data dictionary changes and a whole lot more!

Link List

• CallidusCloud Acquires OrientDB, the Leading Multi-Model Database Technology
• Database provider MongoDB has filed to go public. Bound to happen, and some highlights according to TechCrunch: “The company brought in $101.4 million in revenue in the most recent year ending January 31, and around $68 million in the first six months ending July 31 this year. In that same period, MongoDB burned through $86.7 million in the year ending January 31 and $45.8 million in the first six months ending July 31. MongoDB’s revenue is growing, and while its losses seem to be stable, they aren’t shrinking either. There have been over 30 million downloads of MongoDB community, and the link also has a nice cap table pie chart.”

Upcoming appearances

Percona’s website keeps track of community events, so check that out and see where to listen to a Perconian speak. My upcoming appearances are:

• 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

Feedback

I look forward to feedback/tips via e-mail at colin.charles@percona.com or on Twitter @bytebot.

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

What a long, packed week! Spent most of it at Open Source Summit North America, while still enjoying the myriad phone calls and meetings you have as a Perconian. In addition to two talks, I also gave a webinar this week on the differences between MySQL and MariaDB (I’ll post a blog Q&A in the near future).

Percona Live Europe Dublin

Have you registered for Percona Live Europe Dublin? If no, what’s keeping you from doing so?

In addition, I think it’s definitely worth registering for the community dinner. You can hang out with other like-minded folks, and see the lightning talks (we may announce more as time gets closer).

See what the MySQL Team will speak about at Percona Live Dublin. You’ll notice that a few of the releases I mention below have Percona Live Europe talks associated with them.

Releases

• gh-ost 1.0.42 released: JSON support, optimizations – in addition to the release, the little hint that GitHub itself is powered by MySQL 5.7 in production is great news
• orchestrator 3.0.2 GA released: raft consensus, SQLite
• ProxySQL 1.4.2 now comes with experimental native clustering
• Percona Server for MongoDB 3.4.7-1.8, now with packages for Debian 9

Link List

• The List of Replication Defaults That Have Changed in 8.0.2
• Do you use Vitess? Do you know that it is planning to join the Cloud Native Computing Foundation? (of course, we’re covering this with two talks at Percona Live Europe Dublin – one by a user, Slack, and the other by the people behind Vitess, YouTube/Google).
• Optimizing web servers for high throughput and low latency – this is long, but so very relevant and filled with lots of granular detail
• A FAQ by Citus Data: Databases and Distributed Deadlocks
• Better Database Migrations in Postgres – also worth using the tool Strong Migrations.

Feedback

On a somber note, former Perconian and all round great community member, Jaakko Pesonen passed away. Shlomi Noach commented online: Remembering Jaakko Pesonen.

I look forward to feedback/tips via e-mail at colin.charles@percona.com or on Twitter @bytebot.