With nine databases available, deployed globally and across multiple cloud platforms, a lot can happen in a year. That's why we've put together this guide to everything that happened in the twelve months up to now - so you're ready for what we've got coming in 2018.
Let's dive in with a look at 2017 for each database - Redis, PostgreSQL, Elasticsearch, MongoDB, etcd, Scylla, JanusGraph, RabbitMQ and Compose for MySQL - that's currently available on Compose:
In 2017, Redis at Compose saw some big updates. We started the year adding horizontal scaling support with read-only slaves for those heavier workloads. In September, we brought Redis 4.0 online for all Redis users and in October we launched SSL connection support for Redis.
In Compose Articles, over the year we looked at how high availability works, how to talk to Redis using just the Unix echo command, how to make your own desktop Redis monitor, handling tagged data with Redis and how to go Serverless with Compose Redis. You'll find more in the Redis Curated Collection of articles.
It was June when we rolled out PostgreSQL 9.6 to Compose users and added pgRouting support. In September, we also updated how we do PostgreSQL high availability at Compose, moving from our open sourced Governor solution to Patroni, a project based on Governor.
In Compose Articles, we've looked at topics such as using OpenStreetMap data, making jsonb faster, PostgreSQL crosstabs for pivoting, how to store network addresses and many more. Which is why we have a Curated Collection of PostgreSQL articles.
In 2017, we added Kibana to the available Elasticsearch addons on Compose, putting a dedicated data dashboard at your finger tips. We followed that up with the first availability of Elasticsearch 5.4.2 on the Compose platform and have been tracking the Elasticsearch 5.x series since then with, most recently, Elasticsearch 5.6.3.
In Compose Articles, we looked at Elasticsearch's Painless scripting, tracking web site engagement and how to do geographical queries among other things.
2017 for MongoDB on Compose was a year of reconciliation and reinforcement as we worked to get the best possible reliability and availability for the database. MongoDB hit the news at the start of the year with ransomware attacks, something Compose MongoDB is protected from by default.
We've had plenty to talk about with MongoDB in Compose Articles though. Document validation, aggregation, metrics and MongoDB, creating signup forms using Node-RED, creating REST APIs to MongoDB and many more. Head over to the MongoDB Curated Collection for more.
2017 was a big year for etcd in Compose. We released etcd 3 on the platform and that brought new APIs, new features and an all round better database. In Compose Articles, we saw how to use etcd3 with Go and a migration guide for upgraders. Etcd3 has already established itself as providing a highly reliable and consistent backbone to services in the cloud; expect more from it in 2018.
The Scylla database is one of the newer databases at Compose, arriving in beta in late 2016. It's a Cassandra-compatible database built for performance. In August 2017, the arrival Scylla 1.7.4 marked Scylla leaving beta at Compose and a new lower Scylla entry point with 5GB of storage.
People have been putting Scylla to work and writing about it for Compose Articles. Tasks included doing sports data analysis and user and session management. For developers, we also had a look at Scylla tooling like Gocqlx for easier access to the data from Go.
We launched JanusGraph on Compose in June. JanusGraph is Compose's first managed graph database and it's backed by another Compose database, Scylla. In August, we made the graph more accessible by adding a data browser to JanusGraph and we made the browser better in November.
There's a whole new world of applications for graph databases and in Compose Articles we looked at them; from Markov Chains to powering a business chatbot and from traversing graphs in Gremlin to importing graph data over the network.
The messaging platform RabbitMQ had a popular year on Compose in 2017. RabbitMQ has been steadily updated on Compose over the year, the most recent version available is now 3.6.14 and we've added new options like support for MQTT and STOMP messages.
Compose articles also looked at using RabbitMQ and Rabbot to structure and scale and joining datasets using RabbitMQ.
Compose for MySQL
Compose for MySQL has remained in beta over 2017 as we have continued to improve its resilience. In August, we updated Compose for MySQL to version 5.7.19, revamped the backup system with Percona XtraBackup, expanded available privileges and enabled triggers and events. We then followed that in November with Compose for MySQL 5.7.20 and a smoother in-place updating process. Each iteration moves Compose for MySQL closer to leaving beta.
In Compose Articles, we looked at using Compose for MySQL as part of a custom email server, connecting to it from PHP on IBM Cloud and using it as part of an OAuth solution. We also checked out some command line alternatives and how to work with JSON in MySQL.
A quiet year all round for RethinkDB in 2017. In August, we brought the first community update of the database online.
Forward into 2018
So what does 2018 hold in store? Well, the end of TLS 1.0 and 1.1 support is coming in March. We've got plans for upgraded versions of Elasticsearch, MongoDB, PostgreSQL, RabbitMQ, JanusGraph and Scylla being worked on. And there's also Compose on the IBM Cloud which is getting its own unique features in 2018. When it's ready, we'll let you know, here on the Compose Articles blog.
Read more articles about Compose databases - use our Curated Collections Guide for articles on each database type. If you have any feedback about this or any other Compose article, drop the Compose Articles team a line at firstname.lastname@example.org. We're happy to hear from you.
attribution Wout Vanacker