GETTING STARTED WITH MARIADB

MariaDB sets the standard for open source relational databases, with Oracle Database compatibility (e.g., sequences and PL/SQL), temporal tables, transparent sharding, instant schema changes, point-in-time rollback and modern SQL (i.e., common table expressions (CTEs), window functions, JSON functions and more). MariaDB Server includes ColumnStore for real-time analytics at scale, as well as Xpand for distributed SQL, and can be downloaded and installed in a variety of ways!

RESOURCES BY LANGUAGE

C

C developers can connect to MariaDB through a native MariaDB connector, Connector/C, which enables you to connect to and communicate with MariaDB databases within your C applications.

C++

C++ developers can connect to MariaDB through a native MariaDB connector, Connector/C++, which enables you to connect to and communicate with MariaDB databases from within your C++ applications.

Java

Java developers can connect to MariaDB using either MariaDB's native JDBC or R2DBC connectors, which enables you to connect to and communicate with MariaDB databases from within your Java (or any JVM-based) applications.

JavaScript

JavaScript developers can connect to MariaDB through a native MariaDB connector, Connector/Node.js, which enables you to connect to and communicate with MariaDB databases from within your Node.js applications.

Python

Python developers can connect to MariaDB through a native MariaDB connector, Connector/Python, which enables you to connect to and communicate with MariaDB databases from within your Python applications.

MARIADB FEATURES AND FUNCTIONALITY

MariaDB SkySQL

MariaDB SkySQL is the first and only database-as-a-service (DBaaS) to bring the full power of MariaDB Platform to the cloud, including its support for transactional, analytical and hybrid workloads.

MariaDB MaxScale

MariaDB MaxScale is an advanced database proxy and a core component of MariaDB Platform – powering its enterprise high availability, scalability, security and integration services. Among other features, MariaDB MaxScale routes queries and load balances, and in SkySQL does so to distributed and replicated services.

Connectors

MariaDB Connectors are lightweight and advanced database connectors for high-performance data access by applications on macOS, Linux, Linux on ARM and Windows. MariaDB provides several native connectors that support languages like C, C++, Java, Python and more!

Modern SQL

MariaDB implements more of the standard SQL specification than any other open source database, adding support for JSON, common table expressions (CTEs), window functions, temporal data tables and many other features over the last few years.

JSON

JSON is fast becoming the standard format for data interchange and for unstructured data. MariaDB Platform includes a range of JSON supporting functions.

Temporal Tables

Temporal tables function as versioned tables that can be used to access and modify past data, and find what changes have been made and when. MariaDB supports temporal data tables in the form of system-versioning tables (allowing you to query and operate on historic data), application-time periods (allowing you to query and operate on a temporal range of data), and bitemporal tables (which combine both system-versioning and application-time periods).

Migration Data Upload

No migration should ever be undertaken lightly and there must be obvious benefits to justify the overhead. The benefits of migrating to MariaDB depend on the situation and/or environment you’re migrating from. When it comes to migration, MariaDB offers a variety of ways to quickly and easily get the job done.

MARIADB WORKLOADS

Transactional

MariaDB Platform is the leading enterprise open source database, featuring Oracle Database compatibility, sharding, temporal tables, dynamic data masking and point-in-time rollback. It leverages an innovative architecture based on pluggable, purpose-built storage engines, allowing different tables (or databases) with different workloads to use different storage engines for better query performance – each one optimized for a specific workload.

Analytical

MariaDB Platform can be deployed as a columnar database for real-time analytics at scale, using distributed data and massively parallel processing (MPP) to perform interactive, ad hoc queries on hundreds of billions of rows with standard SQL. Further, MariaDB Platform implements a cloud-native storage architecture, and can optionally use object storage services in public or private clouds to lower costs and store an unlimited amount of data.

HTAP

MariaDB Platform supports Hybrid Transactional-Analytical Processing (HTAP) through its combination of MariaDB Enterprise Server, MariaDB Platform can be deployed as a MariaDB ColumnStore and MariaDB MaxScale. MariaDB HTAP allows you to combine the power and reliability of row-based storage with scalability with the performance of column-based storage to create truly robust, innovative and truly modern applications.

Distributed SQL

MariaDB Xpand turns MariaDB Enterprise Server into a distributed SQL database with no limits, supporting applications and services with a billion users as easily as those with a thousand. There are no application changes necessary because it supports standard SQL and the MySQL protocol, and no need to give up transactions and strong consistency either.