This article will explain how to setup HA for MySQL Router as described in a previous article about where should the router stand.

For this setup, I will use Pacemaker (part of RedHat High Availability Add-on and available on RHEL, CentOS, Oracle Linux, …).

Of course we need a MySQL InnoDB Cluster but we won’t really use it for the HA setup of the MySQL Router.

Installing Pacemaker

The first step is to install pacemaker on all the machines we will use for our “MySQL Router Cluster”:

# yum install pacemaker pcs resource-agents

Now we need to start the pcsd service and enable it at boot (on all machines):

# systemctl start pcsd.service 
# systemctl enable pcsd.service

It’s time now to setup authentication, this operation is again …

Let us show you how to install MySQL on your CentOS 7 server. MySQL is a relational database management system that functions through the use of a query system. Created in 1995, it’s an open-source project that is currently developed by Oracle, and has existed since 1995. It’s fast, written in C and C++, and […]

This tutorial shows how to install an Apache web server on a CentOS 7 server with PHP (mod_php with PHP 5.4, 7.0, 7.1, or 7.2) and MySQL support. This setup is often referred to as LAMP which stands for Linux - Apache - MySQL - PHP.

This tutorial shows how to install ISPConfig 3.1 on a CentOS 7.4 (64Bit) server. ISPConfig 3 is a web hosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, Mailman, and many more.

LibreNMS is an open source monitoring tool based on PHP/MYSQL/SNMP. It's a fully featured network monitoring system that provides support for wide range of network hardware and operating systems including, FreeBSD, Cisco, Linux, HP, and more. In this tutorial, we will show you how to install and configure LibreNMS using Nginx as the web server and MariaDB as the database.

TaskBoard is a free and open source application to keep a track of the tasks that needs to be done. It requires minimal dependencies to work. Database is stored in SQLite which eliminates the requirement of MySQL or any other database server.

Pimcore is an open source enterprise content management system (CMS) written in PHP, It uses MySQL as database backend. In this tutorial, we will install Pimcore CMS on CentOS 7 server.

In this tutorial, I will show you step by step to configure MySQL securely for remote connections with SSL. MySQL is an open source relational database system that works on many Operating Systems including Windows, Linux, MacOS and FreeBSD. It is probably the most popular OpenSource RDBMS and a central component of the LAMP and LEMP Stacks.

In this tutorial, I will show you how to install Magento 2.1 with Nginx, PPHP 7.0 (FPM) and MySQL 5.7 on a CentOS 7 server. Magento is a widely used open source shop and content management system for e-commerce websites based on the PHP Zend Framework.

In today's business, it is increasingly necessary to share workspaces, labs, tools, and any other type of resources. Making the most of the available resources has become a competitive advantage for modern businesses. Booked is open source software written in PHP and MySQL that helps organizations and groups efficiently manage, record and track resources of any kind. It allows you to create schedules so users can find schedules available for resource use.