MariaDB is an open source relational database management system, created as a drop-in replacement for MySQL. It is developed by some of the original developers of MySQL and aims to remain free and open source software under the GNU GPL.
MariaDB: Open Source Relational Database Management System
An open source relational database management system, created as a drop-in replacement for MySQL, aiming to remain free and open source software under the GNU GPL.
What is MariaDB?
MariaDB is an open source relational database management system, created as a drop-in replacement for MySQL. It is developed by some of the original developers of MySQL and is intended to remain free and open source software under the GNU GPL.
After Oracle acquired MySQL in 2010, the founders of MySQL started the MariaDB project out of concerns that MySQL under Oracle's control would become closed-sourced. MariaDB aims for full compatibility with MySQL, ensuring a "drop-in" replacement capability with library binary equivalency and exact matching with MySQL APIs and commands.
While MariaDB initially started as a "cloned" version of MySQL, many new and original features have since been added including new storage engines like Cassandra and MyRocks, additional performance optimizations, advanced clustering with Galera Cluster 4, and enhanced security and encryption. Over time MariaDB has diverged from MySQL in terms of features and functionality while retaining a focus on speed, security, and reliability.
Notable users include Wikipedia, DBS Bank, ServiceNow and Google. MariaDB is used in numerous production deployments around the world, providing a stable, scalable and robust alternative to MySQL for enterprise applications and services.
MariaDB Features
Features
Relational database management system
Open source and community developed
Drop-in replacement for MySQL
Supports JSON data type
Galera Cluster for high availability
Encryption, compression and replication capabilities
Solid replacement for MySQL, but community support can be hit or miss
As a MySQL user migrating to MariaDB, the transition was seamless and the performance improvements in newer versions are noticeable. However, while the core features are robust, I've found some compatibility issues with older plugins and the community support forums …
Promised a Smooth MySQL Replacement, But Got a Headache
I migrated from MySQL, expecting a seamless experience, but ran into compatibility issues with a few critical plugins that broke our staging environment. While the open-source nature is a plus, the documentation felt scattered, making troubleshooting a frustrating scavenger hunt. …
A rock-solid and forward-thinking replacement for MySQL
Having migrated several projects from MySQL to MariaDB, I've been consistently impressed. The performance is excellent, especially with the Aria and InnoDB engines, and the enhanced features like window functions and JSON support are a real bonus. It feels like …
Frustrating upgrade experience and inconsistent behavior
We migrated from MySQL to MariaDB hoping for a smooth drop-in replacement, but encountered multiple compatibility issues with our existing applications. Some queries that ran perfectly on MySQL now produce different results or fail silently in MariaDB. The documentation wasn't …
SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private.SQLite is the most widely deployed database in the world - it is used in...
What Is MongoDB?MongoDB is a document-oriented NoSQL database that stores data in flexible, JSON-like documents instead of traditional rows and columns. It is one of the most popular databases for modern application development, particularly for applications that need flexible schemas and horizontal scaling.Key FeaturesMongoDB stores data as BSON (Binary JSON)...
PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development. It has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver performant and innovative...
What Is MySQL Community Edition?MySQL is the world's most popular open-source relational database management system, powering millions of websites and applications including WordPress, Facebook, and Twitter. The Community Edition is the freely downloadable version available under the GPL license.Key FeaturesMySQL provides ACID-compliant transactions (with InnoDB engine), full-text search, replication, partitioning,...
Apache Cassandra is a free, open-source, distributed NoSQL database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure.Key features of Cassandra include:Decentralized architecture with no single point of failureLinear scalability and proven fault-tolerance on commodity hardwareFlexible data...
CockroachDB is an open-source, distributed SQL database that provides scalability, survivability, and data consistency across multiple datacenters. Some key features include:Distributed architecture that scales horizontallyAutomated replication and failover for high availabilitySupport for strongly consistent ACID transactionsGeographic distribution of data across multiple datacentersAutomatic rebalancing and repair after failuresSQL interface with support...
CouchDB is an open-source NoSQL document-oriented database that focuses on ease of use and scalability. It uses a document-based data model that maps neatly to objects in web applications and fits better with object-oriented programming techniques compared to a relational database structure.Some key features and aspects of CouchDB include:JSON documents...
Sequel Pro is a feature-rich database management application for macOS exclusively designed for working with MySQL databases. It provides a graphical user interface that allows users to easily connect to local & remote MySQL databases, view & modify database structure and data, import & export data, run SQL queries, and...
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used for storing, retrieving, managing and analyzing data. SQL Server supports both online transaction processing (OLTP) and data warehousing workloads. Key features include:Support for structured, semi-structured and unstructured dataIn-Memory OLTP for faster transaction processingColumnstore indexes...
Amazon DynamoDB is a fast, fully managed and serverless NoSQL database service provided by Amazon Web Services (AWS). It offers reliable performance at any scale, integrated security, and in-memory caching for internet-scale applications.Some key features of DynamoDB include:High performance at any scale - It can handle more than 10 trillion...
PlanetScale is a relational database platform built for serverless applications. It is designed to be highly scalable, reliable, and easy to use.Key features of PlanetScale include:MySQL compatibility - Uses the MySQL protocol and SQL syntax, making it easy to migrate existing applications.Auto-scaling - The database scales up and down automatically...
IBM Lotus Approach is a discontinued Windows-based database software that was developed and sold by IBM Lotus Software in the 1990s. It combined relational database capabilities with integrated office productivity tools such as word processing, spreadsheet, e-mail, calendar, and time management.Some key features of Lotus Approach include:Relational database for storing,...
HSQLDB (HyperSQL DataBase) is an open-source relational database management system (RDBMS) written in Java. It offers a small, fast multithreaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes.Key features of HSQLDB include:Full support for standard SQL, JDBC API and PCI driversEmbedded, in-process, memory-only...
The H2 Database Engine is an open-source relational database management system written in Java. It can be embedded in Java applications or run in client-server mode, with either TCP or disk-based database files.Some key features of H2 include:Small footprint - The H2 jar file is around 2MB and it has...
Titan is an open-source, distributed graph database designed to handle large-scale graph data sets efficiently. It utilizes a NoSQL architecture and provides linear scalability, as well as real-time data access through a transactional database.Some key features of Titan Database include:Support for graph structures containing hundreds of billions of vertices and...
RethinkDB is an open-source, distributed JSON document database designed for easy scalability and high availability. Some key features of RethinkDB include:JSON document storage with a flexible schemaIntuitive ReQL query languageChangefeeds for easy scale-out and replicationAutomatic sharding and failover handlingSimple administration with a clean CLI and web UIStrong consistency guaranteesPowerful indexing...
Apache HBase is an open-source, distributed, versioned, non-relational database modeled after Google's Bigtable. It is written in Java and runs on top of HDFS (Hadoop Distributed File System), providing Bigtable-like capabilities for Hadoop.HBase provides fast random access to large amounts of structured data. It scales linearly to handle huge tables...
IBM DB2 is a proprietary relational database management system (RDBMS) that supports advanced database features for handling high-volume online transaction processing (OLTP) and analytics applications. Originally developed by IBM in the early 1980s for mainframe environments, DB2 runs on multiple platforms including Linux, UNIX, and Windows servers today.Key features of...
Couchbase is an open source, distributed multi-model NoSQL document-oriented database that is optimized for interactive applications. It provides sub-millisecond data operations, distributed across a scalable and flexible database cluster infrastructure designed for performance, scalability, and availability.Key capabilities and features include:Document-oriented storage of JSON documents as well as support for storing...
UnQLite is an embedded NoSQL database engine that provides a standard Key/Value store, as well as a Document Store with support for JSON documents. Some key features of UnQLite include:Written in pure C with no external dependencies, making it simple to integrate into applicationsFast in-memory and on-disk performance for reads...
Sqlite Page Explorer is a free, open source software application used for browsing and editing SQLite database files. It provides a simple graphical interface that allows users to easily view and modify SQLite databases without needing to write SQL code.Some key features of Sqlite Page Explorer include:Viewing table schemas and...
SQLGate is a comprehensive database administration and development tool designed specifically for SQL Server. It provides a user-friendly graphical interface for managing all aspects of SQL Server databases.With SQLGate, database administrators can easily perform tasks like creating and executing SQL queries, visually designing database tables and relationships, importing and exporting...
MarkLogic is an Enterprise NoSQL database platform optimized for building content-driven applications. It combines the features of a database, search engine, and application platform into a unified system.Some key capabilities and benefits of MarkLogic include:Document-oriented database with support for multiple data models like JSON, XML, graphs, geospatial, and morePowerful indexing...
ArangoDB is a native multi-model database system that supports multiple data models in one core engine and database system. The supported data models include graphs, documents (JSON documents), and key-value pairs. Using a single database system for multiple data models eliminates expensive data integration between systems and enables new graph...
CrateDB is an open source massively scalable SQL database that makes it simple to store and analyze massive amounts of machine data in real-time. It was designed from the ground up to power IoT, machine data, analytics, and other high data volume use cases.Some key features and benefits of CrateDB...
VoltDB is an in-memory SQL database designed to enable fast data ingestion and low latency access for applications that need to process large volumes of data and transactions in real-time. Some key aspects of VoltDB:An in-memory database that keeps all data in RAM for faster access.A shared-nothing clustered architecture that...
Mimer SQL is a relational database management system developed by the Swedish company Mimer Information Technology. It supports the SQL standards, including support for transactions, referential integrity, triggers and stored procedures.Some key features of Mimer SQL include:Small footprint - The database server executable is around 1MB in size, making it...
VistaDB is an embedded database engine for .NET applications. It allows developers to integrate a full-featured SQL database into their .NET applications without the need for any external database servers or client software.Some key features of VistaDB include:ACID-compliant transaction processingSQL access via ADO.NET interfacesSmall footprint - less than 1MB DLLNo...
CUBRID is an open-source relational database management system developed by Naver Corporation and the CUBRID community. It is designed for high performance, availability, scalability, and flexibility to power web/mobile applications and enterprise systems.Some key features and capabilities of CUBRID Database include:High performance through efficient query processing, indexing, and tuningHigh availability...
Amazon Relational Database Service (Amazon RDS) is a managed relational database service that provides resizable capacity and management capabilities for DB instances that use standard relational database engines. RDS enables you to operate production-ready databases in minutes with cost-efficient and resizable capacity.RDS provides automated patching, backups, read replicas, multi-region options,...
Matisse is a feature-rich vector graphics software designed for Windows. It enables users to create beautiful vector artwork from scratch for a wide range of purposes including illustrations, animations, UI/UX designs, logos, icons, diagrams, posters, and more.The application has an easy-to-use interface allowing both novice and professional illustrators to quickly...
BitcoinJS is an open-source JavaScript library for working with Bitcoin and cryptocurrencies in web applications. It provides a complete set of tools for building Bitcoin-enabled apps on the web.With BitcoinJS, developers can create and manage wallets, build and sign Bitcoin transactions, sign and verify messages, and interact with the Bitcoin...
Percona Server is an enhanced, drop-in replacement for MySQL Key features and benefits: Faster performance - Improved memory and CPU usage reduces query timesBetter scalability - Supports significantly more concurrent users and connectionsAdvanced diagnostics - Additional metrics and query analysis for troubleshootingEnhanced security - Expanded authentication plugins and data encryptionIncreased...
NuoDB is a distributed SQL database management system designed for deployment in the cloud. It provides support for standard SQL queries while also delivering scalability, high availability, and performance through a distributed architecture.Some key features and capabilities of NuoDB include:Distributed architecture across multiple servers for scalability and resilienceIn-memory caching layer...
Action PSQL is a powerful SQL Editor with advanced capabilities and features aimed at software developers and data analysts working with PostgreSQL and other databases. The centerpiece of Action PSQL is the SQL Editor pane where you can write and debug SQL queries.The SQL Editor provides syntax highlighting for various...
Polyhedra is an open-source relational database management system developed by Polyhedra Database Limited. It is designed for high availability and scalability in cloud and distributed environments.Some key features of Polyhedra include:Multi-master replication - Allows multiple nodes to concurrently accept write operations while continuously replicating to other nodesAutomatic failover - If...
DeepDB is a next-generation database management system that leverages artificial intelligence and deep learning to optimize database performance. It was created by a startup called DeepMatter to reimagine what a database can do.Some key features and benefits of DeepDB include:Automated query optimization using machine learning - DeepDB continuously analyzes queries...
Postgres-XC is an open-source, shared-nothing clustering extension for PostgreSQL. It allows PostgreSQL to scale out to handle write-intensive workloads across multiple nodes. Some key features:Horizontal scalability and load balancing - Add more nodes to scale out performance for handling heavy workloadsShared-nothing architecture - Nodes do not share resources, improving performance...
Starcounter is an in-memory database platform optimized for developing high-performance web applications. Some key features of Starcounter include:Shared-nothing architecture that allows horizontal scaling across server nodesACID-compliant transactions with rollback supportJSON-based data storageDeclarative data binding to UI frameworks like React and AngularSupports .NET and C# for app developmentQuery optimization and indexing...
OrbitDB is a decentralized peer-to-peer database built on top of IPFS, the InterPlanetary File System. It provides an easy-to-use API for storing and managing data in decentralized networks and applications.Some key features of OrbitDB include:Peer-to-peer - Data is replicated directly between peers rather than relying on central serversDistributed and decentralized...
Clustrix is a scale-out, distributed SQL database optimized for high performance analytics, machine learning, and operational workloads. Designed from the ground up as a scale-out relational database, Clustrix delivers sub-second response times and sustained performance with unprecedented linear scalability and fault-tolerance on commodity infrastructure. Leveraging patented distributed MVCC architecture, Clustrix...
EdgeDB is an open-source object-relational database management system designed specifically for graph-like data models, flexible schemas, and complex queries. It combines the power and query capabilities of graph databases with the reliability and performance of relational databases.Key features of EdgeDB include:Declarative query language EdgeQL based on GraphQL, allowing for complex...
SAP MaxDB is a relational database management system originally developed by MySQL and then by SAP SE. It is optimized for use with SAP business applications such as SAP ERP, SAP CRM, SAP SCM, and SAP SRM.Some key capabilities and benefits of SAP MaxDB include:High performance for transactional and analytical...
Frontbase is an open-source relational database management system (RDBMS) that is designed to be lightweight, fast, and easily embeddable into applications. Some key features of Frontbase include:Written in ANSI C for portability and performanceSmall footprint - can run on devices with as little as 32MB of RAMFull support for standard...