arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

Installing Enterprise Server

A guide to installing MariaDB Enterprise Server on various operating systems using package managers (YUM, APT, ZYpp) or binary tarballs.

hashtag
Overview

These instructions detail the deployment of MariaDB Enterprise Server in a Single Standalone Server configuration on a range of supported Operating Systems.

These instructions detail how to deploy a single-node row database, which is suited for a transactional or OLTP workload that does not require high availability (HA). This deployment type is generally for non-production use cases, such as for development and testing.

hashtag
MariaDB Database Products

These instructions detail the deployment of the following MariaDB database products:

Component
Description

hashtag
MariaDB Enterprise Server Components

These instructions detail the deployment of the following components:

Component
Description

hashtag
Term Definitions

Term
Definition

hashtag
Installation

MariaDB Corporation provides package repositories for YUM (RHEL, CentOS), APT (Debian, Ubuntu), and ZYpp (SLES).

hashtag
Install via YUM (CentOS, RHEL, Rocky)

  1. Retrieve your Customer Download Token at and substitute for CUSTOMER_DOWNLOAD_TOKEN in the following directions.

  2. Configure the YUM package repository.

Pass the version to install using the --mariadb-server-version flag to mariadb_es_repo_setup. The following directions reference 11.4. To configure YUM package repositories:

  1. Checksums of the various releases of the mariadb_es_repo_setup script can be found in the section at the bottom of the page. Substitute ${checksum} in the example above with the latest checksum.

  2. Install MariaDB Enterprise Server and package dependencies:

  1. Configure MariaDB.

Installation only loads MariaDB Enterprise Server to the system. MariaDB Enterprise Server requires configuration before the database server is ready for use. See .

hashtag
Install via APT (Debian, Ubuntu)

  1. Retrieve your Customer Download Token at and substitute for CUSTOMER_DOWNLOAD_TOKEN in the following directions.

  2. Configure the APT package repository.

Pass the version to install using the --mariadb-server-version flag to mariadb_es_repo_setup. The following directions reference

To configure APT package repositories:

  1. Checksums of the various releases of the mariadb_es_repo_setup script can be found in the section at the bottom of the page. Substitute ${checksum} in the example above with the latest checksum.

  2. Install MariaDB Enterprise Server and package dependencies:

  1. Configure MariaDB.

Installation only loads MariaDB Enterprise Server to the system. MariaDB Enterprise Server requires configuration before the database server is ready for use. See .

hashtag
Install via ZYpp (SLES)

  1. Retrieve your Customer Download Token at and substitute for CUSTOMER_DOWNLOAD_TOKEN in the following directions.

  2. Configure the ZYpp package repository.

Pass the version to install using the --mariadb-server-version flag to mariadb_es_repo_setup. The following directions reference 11.4.

To configure ZYpp package repositories:

  1. Checksums of the various releases of the mariadb_es_repo_setup script can be found in the section at the bottom of the page. Substitute ${checksum} in the example above with the latest checksum.

  2. Install MariaDB Enterprise Server and package dependencies:

  1. Configure MariaDB.

Installation only loads MariaDB Enterprise Server to the system. MariaDB Enterprise Server requires configuration before the database server is ready for use. See .

hashtag
Configuration

MariaDB Enterprise Server can be configured in the following ways:

  • and can be set in a configuration file (such as /etc/my.cnf). MariaDB Enterprise Server must be restarted to apply changes made to the configuration file.

  • and can be set on the command-line.

  • If a system variable supports dynamic changes, then it can be set on-the-fly using the statement.

hashtag
Configuration Files

MariaDB's packages include several bundled configuration files. It is also possible to create custom configuration files.

On RHEL, CentOS, and SLES, MariaDB's packages bundle the following configuration files:

  • /etc/my.cnf

  • /etc/my.cnf.d/client.cnf

  • /etc/my.cnf.d/mariadb-enterprise.cnf

And on RHEL, CentOS, and SLES, custom configuration files from the following directories are read by default:

  • /etc/my.cnf.d/

On Debian and Ubuntu, MariaDB's packages bundle the following configuration files:

  • /etc/mysql/my.cnf

  • /etc/mysql/mariadb.cnf

  • /etc/mysql/mariadb.conf.d/50-client.cnf

And on Debian and Ubuntu, custom configuration files from the following directories are read by default:

  • /etc/mysql/conf.d/

  • /etc/mysql/mariadb.conf.d/

hashtag
Configure MariaDB

Determine which system variables and options you need to configure.

Useful system variables and options for MariaDB Enterprise Server include:

System Variable/Option
Description
  1. Choose a configuration file in which to configure your system variables and options.

It is not recommended to make custom changes to one of the bundled configuration files. Instead, it is recommended to create a custom configuration file in one of the included directories. Configuration files in included directories are read in alphabetical order. If you want your custom configuration file to override the bundled configuration files, then it is a good idea to prefix the custom configuration file's name with a string that will be sorted last, such as z-.

  • On RHEL, CentOS, and SLES, a good custom configuration file would be: /etc/my.cnf.d/z-custom-my.cnf

  • On Debian and Ubuntu, a good custom configuration file would be: /etc/mysql/mariadb.conf.d/z-custom-my.cnf

  1. Set your system variables and options in the configuration file.

They need to be set in a group that will be read by , such as [mariadb] or [server].

For example:

hashtag
Start the Server

MariaDB Enterprise Server includes configuration to start, stop, restart, enable/disable on boot, and check the status of the Server using the operating system default process management system.

For distributions that use systemd (most supported OSes), you can manage the Server process using the systemctl command:

Operation
Command

hashtag
Test MariaDB Enterprise Server

When MariaDB Enterprise Server is up and running on your system, you should test that it is working and there weren't any issues during startup.

  1. Connect to the server using using the root@localhost user account:

This page is: Copyright © 2025 MariaDB. All rights reserved.

/etc/my.cnf.d/mysql-clients.cnf

  • /etc/my.cnf.d/server.cnf

  • /etc/mysql/mariadb.conf.d/50-mysql-clients.cnf

  • /etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf

  • /etc/mysql/mariadb.conf.d/50-server.cnf

  • /etc/mysql/mariadb.conf.d/60-galera.cnf

  • /etc/mysql/mariadb.conf.d/mariadb-enterprise.cnf

  • Sets the maximum number of simultaneous connections MariaDB Enterprise Server allows.

    Sets how MariaDB Enterprise Server handles threads for client connections.

    Sets the file name for the error log.

    Sets the amount of memory InnoDB reserves for the Buffer Pool.

    Sets the size for each Redo Log file and sets the number of Redo Log files used by InnoDB.

    Sets the maximum number of I/O operations per second that InnoDB can use.

    sudo systemctl enable mariadb

    Disable during startup

    sudo systemctl disable mariadb

    Status

    sudo systemctl status mariadb

    MariaDB Enterprise Server

    Modern SQL RDBMS with high availability, pluggable storage engines, hot online backups, and audit logging.

    InnoDB

    • It is a general purpose storage engine

    • It is ACID-compliant

    • It is performant

    • It is the transactional component of MariaDB's single stack solution

    row database

    • A database where all columns of each row are stored together

    • Best suited for transactional and OLTP workloads

    • Also known as a "row-oriented database"

    $ sudo yum install curl
    
    $ curl -LsSO https://dlm.mariadb.com/enterprise-release-helpers/mariadb_es_repo_setup
    
    $ echo "${checksum}  mariadb_es_repo_setup" \
        | sha256sum -c -
    
    $ chmod +x mariadb_es_repo_setup
    
    $ sudo ./mariadb_es_repo_setup --token="CUSTOMER_DOWNLOAD_TOKEN" --apply \
       --mariadb-server-version="11.4"
    $ sudo yum install MariaDB-server MariaDB-backup
    $ sudo apt install curl
    
    $ curl -LsSO https://dlm.mariadb.com/enterprise-release-helpers/mariadb_es_repo_setup
    
    $ echo "${checksum}  mariadb_es_repo_setup" \
        | sha256sum -c -
    
    $ chmod +x mariadb_es_repo_setup
    
    $ sudo ./mariadb_es_repo_setup --token="CUSTOMER_DOWNLOAD_TOKEN" --apply \
       --mariadb-server-version="11.4"
    
    $ sudo apt update
    $ sudo apt install mariadb-server mariadb-backup
    $ sudo zypper install curl
    
    $ curl -LsSO https://dlm.mariadb.com/enterprise-release-helpers/mariadb_es_repo_setup
    
    $ echo "${checksum}  mariadb_es_repo_setup" \
        | sha256sum -c -
    
    $ chmod +x mariadb_es_repo_setup
    
    $ sudo ./mariadb_es_repo_setup --token="CUSTOMER_DOWNLOAD_TOKEN" --apply \
       --mariadb-server-version="11.4"
    $ sudo zypper install MariaDB-server MariaDB-backup

    datadir

    Sets the path to the data directory. MariaDB Enterprise Server writes data files to this directory, including tablespaces, logs, and schemas. Change it to use a non-standard location or to start the Server on a different data directory for testing.

    bind_address

    Sets the local TCP/IP address on which MariaDB Enterprise Server listens for incoming connections. When testing on a local system, bind the address to the local host at 127.0.0.1 to prevent network access.

    port

    Sets the port MariaDB Enterprise Server listens on. Use this system variable to use a non-standard port or when running multiple Servers on the same host for testing.

    [mariadb]
    log_error                 = mariadbd.err
    innodb_buffer_pool_size   = 1G

    Start

    sudo systemctl start mariadb

    Stop

    sudo systemctl stop mariadb

    Restart

    sudo systemctl restart mariadb

    $ sudo mariadb
    
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 38
    Server version: 11.4.5-3-MariaDB-Enterprise MariaDB Enterprise Server
    
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [(none)]>
    MariaDB Enterprise Server
    https://customers.mariadb.com/downloads/token/arrow-up-right
    Versions
    MariaDB Package Repository Setup and Usage
    Configuration
    https://customers.mariadb.com/downloads/token/arrow-up-right
    Versions
    MariaDB Package Repository Setup and Usage
    Configuration
    https://customers.mariadb.com/downloads/token/arrow-up-right
    Versions
    MariaDB Package Repository Setup and Usage
    Configuration
    System variables
    options
    System variables
    options
    SET
    mariadbd
    mariadb Client

    Enable during startup

    Hybrid Transactional/Analytical Processing (HTAP)
    max_connections
    thread_handling
    log_error
    innodb_buffer_pool_size
    innodb_log_file_size
    innodb_log_files_in_group
    innodb_io_capacity
    spinner