Load Balancing MariaDB Server

Configuration has yet to be fully verified, Kemp Support will gladly assist if your MariaDB Server traffic is not flowing as expected.


1   Introduction

MariaDB Server is one of the most popular database servers in the world. It’s made by the original developers of MySQL. MariaDB turns data into structured information in a wide array of applications, ranging from banking to websites. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases.

Service will be transparent, please see out transparency here. 


1.2  Document Purpose

This section details a configuration for a specific application that has been provided by a customer but has yet to be fully tested.

The purpose of this document is to give readers an overview on the recommended best practice settings when configuring the MariaDB Server components for load balancing.

Configuration has yet to be fully verified, but Kemp Support will gladly assist if MariaDB Server is not flowing as expected.


2  Configuration Required

One Virtual Service required on port 3306.

 2.1 Global Configuration  

     >No Changes Required


2.2  Virtual Service Configuration:


2.3   MariaDB Server

      > New Virtual Service

      > Enter IP Address

      > Port = 3306

      > Name = MariaDB Server     

> Add New Virtual Service

 2.4   Basic Properties

       > Service Type = Generic

 2.5    Standard Options   

      > Enable Transparency

      > Server Initiating Protocols = MySQL

      >  Persistence = Source IP 

      >  Persistence Time = 30min  

      > Scheduling Method = Round Robin

      >  Idle Connection Timeout = 660  (Default)

   2.6   Real Servers

      > Add New 

      > Enter IP Address

      > Port = 3306

      > Checker Parameter Type = TCP Connection Only


If you have successfully Load Balanced your MariaDB Servers environment by implementing this specific configuration, please give a thumbs up or please leave a comment on a possible alteration that was required to make it function. Thank you


1 comment


Fernando Leite

it's working!! Thanks.
The principle to MariaDB is the same to anothers databases, with one change:
Server Initiating Protocols -> Other Server Initiating


Please to leave a comment.

Didn't find what you were looking for?