HomeTechnologyThe DBaaS family is growing: Welcome to Kafka, MySQL, PostgreSQL, OpenSearch and...

The DBaaS family is growing: Welcome to Kafka, MySQL, PostgreSQL, OpenSearch and Redis!

Building on the success of Public Cloud Databases for MongoDB, we know how much a managed service increases the performance, scalability and resiliency of your databaseNow, a new batch of managed Databases as a Service (DBaaS) aka PostgreSQL, MySQL, Apache Kafka, OpenSearch and Redis is in free beta. Why do they stand out? What are their main use cases? In which typical business scenario can you leverage them? That’s what we’ll discuss today!

The DBaaS family is growing: Welcome to Kafka, MySQL, PostgreSQL, OpenSearch and Redis!

A large choice of “vanilla taste” DBMS

The market is brimming with database engines, we will offer you this large choice over the coming months. Our Public Cloud Databases are of course fully managed and suitable with the full OVHcloud portfolio including bare metal for instance.

Did you know that delegating the setup and daily operations of your database cluster could help your improve your performance by 15% to 20%? That’s a pretty fine argument to move your database to the cloud if it wasn’t already the case!

You might nonetheless wonder how these DBaaS differ from existing market choices?

Aiven
  • Aside from MongoDB, all other engines are open-source so that you’ve got no risk of vendor lock-in and can adapt your technology strategy in the lengthy run. We partner with the leader of open-source DBaaS, Aiven, to deliver this full portfolio.
  • What’s more, we deliver the official, full and updated experience or “vanilla taste” of each DBMS, and not a fork in our cloud environment. It means that you advantage from all the features, updates and community innovation.
  • They are hosted in our trusted Cloud-Act free cloud infrastructure – in Europe and Canada today, and soon in other parts of the world – to ensure you full data privacy and infrastructure compliance. 
  • Last, but not least, after the free beta, their pricing is fully clear, predictable and much cheaper than competition. Why don’t you check our price list by yourself? What you see is what you pay! All costs including outgoing traffic are included. Don’t overlook to multiply the price by the number of nodes!

You voted, we delivered

We know you have been waiting for these managed databases in the public cloud for some time, so we requested you which were your favorite ones and delivered them first. After 3 weeks of utilization, here is our beta testers’ podium:

You voted, we delivered
  1. Almost half of our first beta testers use PostgreSQL. It’s the most advanced, extensible and highly secure relational database that you use for mission critical business applications. 
  2. Another huge third of our users are on MySQL, 1 of the most wellliked transactional engines for eCommerce platforms, but also an ideal choice for many web applications. 
  3. Redis is the third favorite database with almost 15% adoption. It is frequently used for website caching and personalization, chat and messaging apps but also in the gaming industry for leaderboards.
  4. The last few percent of users are on Apache Kafka , the should have distributed data streaming platform. Its horizontal scalability is useful  for IoT data ingestion, real-time analytics as well for event-driven applications.

But what do Kafka, MySQL, PostgreSQL, OpenSearch and Redis do?

Long story quick: too many uses cases for 1 blog post! But let’s dive a bit into the main concepts and key differentiators.

Imagine that you are literally an e-commerce website… At least try to imagine 😀  It may be a tiny silly, but a fine way to understand.

It’s almost Christmas, plenty of clients are creating accounts, ordering presents, putting their credit cards. As a website, you cannot lose their information, you want to store it precisely. Here approach relational databases to the rescue!

Relational databases with MySQL and PostgreSQL

Relational databases are broadly adopted worldwide, with pretty simple tables, with columns and rows. Each desk can be linked to others, with relationships, it’s called a schema.

The most wellknown ones are MySQL, PostgreSQL, MariaDB and SQL server.

The thought is always the same, tables and relations, with a goal to guarantee data validity despite errors, power failures.

Imagine that you, the website, receive an order for a new gift; you ask for a payment of 50 euros. The customer is paying, but just for 2 seconds your database is flapping and unreachable.

Relational databases with MySQL and PostgreSQL

As a website, do you want approximate data? Do you want to be almost sure that the customer has payed? Certainly not! You want to be 100% confident about the transaction in your databases.

Relational Databases provide ACID guarantees (for Atomicity, Consistency, Isolation and Durability) that make them the best resolution to deal with this kind of use case.

MySQL and MariaDB are often used for simple website and web application, such as WordPress.

PostgreSQL is more manufacturing grade-oriented, with full ACID compliance, advanced security and high availability (HA mechanism, and various extensions for various use case (geographical data, metrics, …).

Also, PostgreSQL is the only database system in the list owned by no company. It’s owned by the PostgreSQL community, you and me. Unlike MySQL that’s the property of Oracle for example.

1637936464 123 The DBaaS family is growing Welcome to Kafka MySQL PostgreSQL
Example of relational tables

Let’s approach back to our e-commerce scenario!

It’s Christmas time for our website, your are now able to receive and store properly your products, the orders, the bills… neat!

But wait… Now more and more clients are coming to you, asking ALWAYS for the same price and description of this wonderful pair of socks. Worst, they put a few products in the basket, but don’t buy them.

You are slowed down by storing and giving information from your native storage (images). In the same way, pushing in database information that you would not need to hold (basket) is irritating. Last but not least, tons of requests in your relational databases (“SELECT Articles in discounted_prices…”) are always the same, giving the same results…

Grrr! It’s really painful to store this kind of ephemeral information. What if you could store and retrieve this data someplace very, very quickly?

Hello Redis! your best friend for caching data

The most handy database engine to answer your need is Redis.

Redis has 2 main traits: first, it shops data in volatile memory (RAM), not in classic storage such ad SSD drives. Second, it’s not a relational database, but a key-value store. You can store various type of data, such as HTML code, images, user sessions, gaming leaderboards, chat sessions, …

Redis

Each time you have to hold in mind that this data “can” be lost and you will store/retrieve it with huge performance.

Most wellliked use cases are website performance improvement, databases caching, gaming leaderboard, chat tools,.. Twitter, Snapshat, instagram, AirBnB, Pinterest.. they all use Redis!

1637936464 685 The DBaaS family is growing Welcome to Kafka MySQL PostgreSQL
Example of Keys and Values

The most handy database engine to answer your need is Redis.

Redis has 2 main traits: first, it shops data in volatile memory (RAM), not in classic storage such ad SSD drives. Second, it’s not a relational database, but a key-value store. You can store various type of data, such as HTML code, images, user sessions, gaming leaderboards, chat sessions, …

Each time you have to hold in mind that this data “can” be lost and you will store/retrieve it with huge performance.

Most wellliked use cases are website performance improvement, databases caching, gaming leaderboard, chat tools,.. Twitter, Snapshat, instagram, AirBnB, Pinterest.. they all use Redis!

Kafka, to avoid kafkaian situations

Apache Kafka, is the world’s most wellknown streaming tool. Imagine a highly-available and highly efficient platform, allowing you to connect to dozen data sources, “snif” the data in real time with near zero latency and push it someplace else. That’s Kafka which unlike Redis is used a bit everywhere.

Kafka

You don’t store information in Kafka, you connect Kafka to information sources. Then, of course, this data can be reused.

Main use cases are messaging between applications (it acts as a buffer), real time analytics and real time data pipelines, aggregation of metrics and logs (imagine a company with 1.5 million website ands 250’000 servers to monitor, for example (smile)).

1637936464 3 The DBaaS family is growing Welcome to Kafka MySQL PostgreSQL
Apache Kafka Principles. Source : Halovina

OpenSearch to hold en eye on everything

OpenSearch is an open source fork of Elasticsearch, allowing you to ingest data, such as all the logs of your website and easily analyze them.

OpenSearch

Perfect for us to follow all the 404 errors for example! Wonderful dashboard in minutes, in real time!

Here is an example made with OpenSearch sample data:

1637936464 320 The DBaaS family is growing Welcome to Kafka MySQL PostgreSQL
OpenSearch dashboard example with web data

The A-team of data ecosystem

As a website, you can think of relational databases, Redis, Opensearch and Kafka as the A-team. They are not identical at all; each of them has a specific position to play in the adventure.

The A-team of data ecosystem

At the end, I love it when a plan comes together!

The DBaaS family is growing Welcome to Kafka MySQL PostgreSQL

Learn more about these use cases with Aiven’s Cofounder and CTO, Heikki Nousiainen, at Ecosystem Experience!


Erika Gelinard

Data Product Marketer

at

OVHcloud

|
+ posts

Erika Gelinard dived into the Cloud ocean in 2010 and hasn’t left it since!
A B2B marketer, passionate about tech innovation, she is to help decision makers and users make the best of cloud technologies. French native and English speaker, loves to interview insightful and inspiring people.
At OVHcloud focused on data and Database as a Service solutions.


Managing GPU pools efficiently in AI pipelines

Product Manager for databases / huge data / AI
Twitter : https://twitter.com/bastienovh




Source

Most Popular