MariaDB High Availability with SafeKit: Install the mysql.safe Module for Failover

Overview of the SafeKit / MariaDB solution

Installation of the SafeKit / MariaDB solution on Windows and Linux (mysql.safe)

Package installation on Windows

Download and install the free version of SafeKit on 2 Windows nodes.

Note: the free version includes all SafeKit features. At the end of the trial, you can activate permanent license keys without uninstalling the package.
Upon completing the package installation, select Set console credentials and firewall rules now and configure a password for the admin user of the SafeKit console.

Set the same password on all nodes.
Exclude from antivirus scans C:/safekit/ (the default installation directory) and all replicated folders that you are going to define.

Antiviruses may face detection challenges with SafeKit due to its close integration with the OS, virtual IP mechanisms, real-time replication and restart of critical services.

Package installation on Linux

Install the free version of SafeKit on 2 Linux nodes.
Note: the free trial includes all SafeKit features. At the end of the trial, you can activate permanent license keys without uninstalling the package.
After the download of safekit_xx.bin package, execute it to extract the rpm and the safekitinstall script and then execute the safekitinstall script
Answer yes to firewall automatic configuration
Set the password for the web console and the default user admin.
Set the same password on all nodes.

Step by step configuration of the SafeKit / MariaDB solution

2. Configure node addresses

Enter the node IP addresses, press the Tab key to check connectivity and fill node names. If either node1 or node2 has a red color, check connectivity of the browser to both nodes and check firewall on both nodes for troubleshooting.
Then, click on Save and apply to save the configuration.
Check the Success ✅ message on both nodes.
If the configuration Failure ❌ occurs on one node, open the ▼ accordion for that node and review the messages. Note that you can use the SafeKit AI 🤖 for assistance.

If you want, you can add a new LAN and nodes ( first ➕) to create a second heartbeat and a dedicated replication network.

If you click on Advanced configuration, the cluster.xml file is displayed. This file is automatically populated by the console and deployed on the nodes.

4. Configure the module

In Module startup at boot, choose an automatic start of the module at boot without delay.
In Macros / SERVICES, enter the service names of your application, in the startup order, separated by commas. See this screenshot for a visual example of Milestone XProtect services 🖼️.
In Heartbeat networks, you should have a single heartbeat network on which the replication is made. If you have added a private LAN at step 2, then you can configure two heartbeats with the replication flow on the private LAN.
In Virtual IP addresses, enter a virtual IP address. A virtual IP address is a standard IP address in the same IP network (same subnet) as the IP addresses of both nodes.
Application clients must be configured with the virtual IP address (or the DNS name associated with the virtual IP address).
The virtual IP address is automatically switched in the event of a failure.
In Replicated directories, set the paths of directories to replicate. Check that they exist on both nodes and contain the application data.
Data and log replication are essential for a database.
You can create additional replicated directories as required.
See this screenshot for a visual example of Milestone XProtect SQL replication 🖼️.
In Checkers, you will be able to configure checkers if needed, such as process monitoring, custom checkers, TCP, ping, or split-brain checkers.
For example, if a process name is displayed in Monitored processes/services, it will be monitored with a restart action in case of failure. Configuring a wrong process name will cause the module to stop right after its start.

If you click on Advanced configuration, the userconfig.xml file is displayed. This file is automatically populated by the console and deployed on the nodes with the restart scripts.

In a cloud deployment, you do not need to configure a virtual IP address in SafeKit. The virtual IP is managed at the cloud load balancer level.

When you apply the SafeKit configuration, the startup type of services is automatically set to Manual in Windows services. This ensures that services do not start automatically when the system boots, but are instead started only when the module itself is started (the same applies on Linux).

9. Start the node with up-to-date data

If node 1 has the up-to-date replicated directories, select it and ⋯ Force start ▶ As primary.

When node 2 will be started, all data will be copied from node 1 to node 2.

If you make the wrong choice, you run the risk of synchronizing outdated data on both nodes.

It is also assumed that the MariaDB application is stopped on node 1 so that SafeKit installs the replication mechanisms and then starts the application in the start_prim script.

Use Start for subsequent starts: SafeKit retains the most up-to-date server. Starting As primary is a special start-up the first time or during exceptional operations.

10. Wait for the transition to ALONE (green)

Node 1 should reach the ALONE (green) state, which means that the virtual IP is set and that the start_prim script has been executed on node 1.

If ALONE (green) is not reached or if the application is not started, analyze why with the module log 🖼️ of node 1.

Click the 🔍 log icon of node1 to open the module log and look for error messages such as a checker detecting an error and stopping the module.
Click on start_prim in the log: output messages of the script are displayed on the right and errors can be detected such as a service incorrectly started.
Use the SafeKit AI 🤖 for assistance with log messages.

If the cluster is in WAIT (red) not uptodate, STOP (red) not uptodate state, stop the WAIT node and force its start as primary 🖼️.

11. Start node 2

⋯ Start node 2 with its contextual menu.
Wait for the SECOND (green) state.

Node 2 stays in the SECOND (orange) state while resynchronizing the replicated directories (copy from node 1 to node 2).

This may take a while depending on the size of files to resynchronize in replicated directories and the network bandwidth.

To see the progress of the copy, see the module log 🖼️ and the replication resources 🖼️ of node 2. Use the SafeKit AI 🤖 for assistance with log messages.

13. Testing

Stop the PRIM node by scrolling down its contextual menu and clicking Stop.
Verify that there is a failover on the SECOND node which should become ALONE (green).
And with Microsoft Management Console (MMC) on Windows or with command lines on Linux, check the failover of MariaDB services (stopped on node 1 in the stop_prim script and started on node 2 in the start_prim script).

If ALONE (green) is not reached on node2 or if the application is not started, analyze why with the module log 🖼️ of node 2.

Click the 🔍 log icon of node2 to open the module log and look for error messages such as a checker detecting an error and stopping the module.
Click on start_prim in the log: output messages of the script are displayed on the right and errors can be detected such as a service incorrectly started.
Use the SafeKit AI 🤖 for assistance with log messages.

If everything is okay, initiate a start on node1, which will resynchronize the replicated directories from node2.

If things go wrong, stop node2 and force the start as primary 🖼️ of node1, which will restart with its locally healthy data at the time of the stop.

Find more details, along with videos, in the SafeKit Online Training.

🔍 SafeKit High Availability Navigation Hub

Explore SafeKit: Features, technical videos, documentation, and free trial
Resource Type	Description	Direct Link
Key Features	Why Choose SafeKit for Simple and Cost-Effective High Availability?	See Why Choose SafeKit for High Availability
Use Cases	Explore How SafeKit Ensures the High Availability of Critical Infrastructure	See All Use Cases (OEM Software, Edge Servers, SCADA, and more)
Deployment Model	All-in-One SANless HA: Shared-Nothing Software Clustering	See SafeKit All-in-One SANless HA
HA Strategies	SafeKit: Infrastructure (VM) vs. Application-Level High Availability	See SafeKit HA & Redundancy: VM vs. Application Level
Technical Specifications	Technical Limitations for SafeKit Clustering	See SafeKit High Availability Limitations
Proof of Concept	SafeKit: High Availability Configuration & Failover Demos	See SafeKit Failover Tutorials
Architecture	How the SafeKit Mirror Cluster works (Real-Time Replication & Failover)	See SafeKit Mirror Cluster: Real-Time Replication & Failover
Architecture	How the SafeKit Farm Cluster works (Network Load Balancing & Failover)	See SafeKit Farm Cluster: Network Load Balancing & Failover
Competitive Advantages	Comparison: SafeKit vs. Traditional High Availability (HA) Clusters	See SafeKit vs. Traditional HA Cluster Comparison
Technical Resources	SafeKit High Availability: Documentation, Downloads & Trial	See SafeKit HA Free Trial & Technical Documentation
Pre-configured Solutions	SafeKit Application Module Library: Ready-to-Use HA Solutions	See SafeKit High Availability Application Modules

MariaDB High Availability with SafeKit: Install the mysql.safe Module for Failover

Configuring mysql.safe for Synchronous Replication & 2-Node SANless Clustering

High Availability Quick Installation Guide for MariaDB

1. Overview

2. Installation

3. Configuration

Overview of the SafeKit / MariaDB solution

Installation of the SafeKit / MariaDB solution on Windows and Linux (mysql.safe)

Prerequisites

Package installation on Windows

Module installation on Windows

Package installation on Linux

Module installation on Linux

Step by step configuration of the SafeKit / MariaDB solution

Prerequisites

1. Launch the SafeKit console

2. Configure node addresses

3. Select a module

4. Configure the module

5. Edit scripts (optional)

6. Communication encryption (optional)

7. Save and apply

8. Verify successful configuration

9. Start the node with up-to-date data

10. Wait for the transition to ALONE (green)

11. Start node 2

12. Verify that the cluster is operational

13. Testing

14. Support

🔍 SafeKit High Availability Navigation Hub