Is MariaDB simply a fork of MySQL? This is one of the most misleading ideas about MariaDB. Yes, it’s a project rooted in MySQL, but no, it’s not simply a fork of MySQL. MariaDB started as a fork many years ago by the creator of MySQL (Michael “Monty” Widenius). Many of the original developers of MySQL moved to this new project called MariaDB. In my eyes, MariaDB is the real continuation of MySQL under a different name.
Today, MariaDB has an impressive lineup of components and technologies that highly improve the database experience. From the reliable and open-source MariaDB Community Server to the cutting-edge MariaDB SkySQL second-generation cloud database service, in this article, we’ll dive into how each tool addresses real-world problems.
As software developers, we crave speed, reliability, and openness and the MariaDB Community Server aligns with all this. Rooted in MySQL, this open-source database server adheres to the
Once more and more people use our applications, data grows and new patterns and corner cases emerge. Development teams come across SQL queries that perform well and others that don’t so much. The typical case is that of OLTP vs OLAP. Transactional vs analytical. Another case is that of read-heavy vs write-heavy workloads. Not all tables are put under the same stress in the read-and-write spectrum. Not all tables are used for report generation. Different workloads require different ways to treat the data. And this is a concern of the database.
MariaDB includes ALTER TABLE some_table ENGINE=MyRocks
if we want to optimize such a table for write-heavy workloads. Also, cross-engine joins between tables are possible!
When it's time to move from development or small internal applications to production environments in business-critical applications,
Scaling, ensuring high availability, and managing databases can be daunting tasks. Enter MariaDB MaxScale, in my opinion, the best database proxy in the market. MaxScale acts as a traffic cop, directing queries to the right places and handling automatic failover seamlessly. Your applications won’t notice when a database node goes down or is put in maintenance mode. With support for various protocols like MongoDB and Kafka, MaxScale allows us to build resilient and scalable applications, minimizing complexity at the database cluster level. Everything looks like a single logical database thanks to MaxScale.
Creating reports or writing any kind of analytical ad-hoc SQL queries over mountains of data is challenging. Especially, when trying to make these reports and queries run fast. You might have to tweak indexes and maintain them. Not an easy task in databases with dozens or hundreds of tables and columns. That's where MariaDB ColumnStore comes to the rescue. Designed for data warehouses and analytical workloads, ColumnStore persists the data in a columnar fashion. This approach brings significant performance benefits, enabling lightning-fast analytical queries and insights without having to deal with database indexes.
Scaling both reads and writes while maintaining
Moving to the cloud has become essential for modern software development. MariaDB SkySQL makes the transition seamless. SkySQL allows deployments of MariaDB products effortlessly with a few clicks, whether it's MariaDB Enterprise Server, ColumnStore, or Xpand. Additionally, it offers serverless analytical deployments, geospatial services, remote monitoring, and cloud backup of MariaDB servers running anywhere (even on a Raspberry Pi if you want!). All this makes it a comprehensive solution for all cloud database needs.
MariaDB has become a go-to choice for many developers seeking robust, scalable, and reliable database solutions. From the open-source MariaDB Community Server to the production-ready MariaDB Enterprise Server and Xpand, MariaDB offers a range of tools to address all kinds of specific needs. MaxScale manages database traffic, ColumnStore unlocks analytical power, Xpand enables scalable reads and writes, and SkySQL simplifies cloud database deployments and management. With MariaDB, developers can focus on building software without losing sleep over database challenges.
In this article, I briefly explored some of the features that make MariaDB much more than a fork of MySQL. I hope you can see it now!
I’m happy to answer any questions or present this topic internally at your company, conference, developer group, meetup, or anything.