We won’t cover how to back up MariaDB data, or migration from an earlier MariaDB version. The parts captured in this guide will describe how to install and configure MariaDB 10.8 on Debian 11 / Debian 10 systems.

Stored Procedures INOUT Parameters – Added support support for IN, OUT and INOUT parameter qualifiers.

Improved i18n support on Windows – On Windows 10+ systems, several problems with Unicode input and output in client were fixed.mysqlbinlog GTID support– mariadb-binlog (previously mysqlbinlog) now supports both filtering events by GTID ranges through –start-position and –stop-position, and validating a binary log’s ordering of GTIDs through –gtid-strict-mode.Spider Storage Engine Improvements – You can now declare Spider connections using the REMOTE_SERVER, REMOTE_DATABASE, and REMOTE_TABLE attributes and not abuse the COMMENT field for that.JSON Histograms – Histograms in the statistics tables are more precise and stored as JSON, not binary.Descending indexes – Individual columns in the index can now be explicitly sorted in the ascending or descending order.Lag free ALTER TABLE in replication – ALTER TABLE now gets replicated and starts executing on replicas when it starts executing on the primary, not when it finishes.Auto create partition – You can now use an AUTO keyword to inform the server to create more history partitions automatically.InnoDB redo log improvements – autosize innodb_buffer_pool_chunk_size and Improve the redo log for concurrency.Some of the notable features in MariaDB 10.8 are: Multiple storage engines and plug-ins are included in MariaDB, as well as support for geographic information system (GIS) and JavaScript Object Notation (JSON) features. MariaDB being relational database converts data into structured information and provides SQL interface for accessing stored data.

MariaDB server is a free to use and open source, robust and fast database server based on the MySQL technology. In this article we shall consider MariaDB database management system installation on Debian Linux. In tech terms, a DBMS provides utilities for database administration and interacts with end users, applications, and databases. The main purpose of a database server is to provide features of database management system (DBMS). Most web, mobile and desktop application services you interact with on daily basis depend on database server to complete any transaction.

Install mariadb debian 10