Running Multiple MariaDB Server Processes

It is possible to run multiple MariaDB Server processes on the same server, but there are certain things that need to be kept in mind. This page will go over some of those things.

Configuring Multiple MariaDB Server Processes

If multiple MariaDB Server process are running on the same server, then at minimum, you will need to ensure that the different instances do not use the same datadir, port, and socket. The following example shows these options set in an option file:

The above values are the defaults. If you would like to run multiple MariaDB Server instances on the same server, then you will need to set unique values for each instance.

There may be additional options that also need to be changed for each instance. Take a look at the full list of options for .

To see the current values set for an instance, see for how to do so.

To list the default values, check the end of the output of this command:

Starting Multiple MariaDB Server Processes

There are several different methods to start or stop the MariaDB Server process. There are two primary categories that most of these methods fall into: starting the process with the help of a service manager, and starting the process manually. See for more information.

If you want to run different MariaDB versions on the same machine, using , or using Virtual Machines (VMs) are the recommended ways. A binary tarball uses least resources, Docker a bit more and a VM uses most resources.

Service Managers

and are the most common Linux service managers. is used in MacOS X. is a less common service manager.

Systemd

RHEL/CentOS 7 and above, Debian 8 Jessie and above, and Ubuntu 15.04 and above use by default.

For information on how to start and stop multiple MariaDB Server processes on the same server with this service manager, see .

Starting the Server Process Manually

mariadbd

is the actual MariaDB Server binary. It can be started manually on its own.

If you want to force each instance to read only a single , then you can use the option:

mariadbd-safe

is a wrapper that can be used to start the server process. The script has some built-in safeguards, such as automatically restarting the server process if it dies. See for more information.

If you want to force each instance to read only a single , then you can use the option:

mariadbd-multi

is a wrapper that can be used to start the server process if you plan to run multiple server processes on the same host. See for more information.

Other Options

In some cases, there may be easier ways to run multiple MariaDB Server instances on the same server, such as:

• Starting multiple containers.

• Using (no longer maintained).

_{This page is licensed: CC BY-SA / Gnu FDL}