Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
163 blog posts in 13 categories

MySQL Replication with ProxySQL on WHM/cPanel Servers - Part 2

In this second part of how to run MySQL Replication with ProxySQL on WHM cPanel servers, we cover the post-deployment operations for maintenance, management, failover as well as advantages over the standalone setup.

MySQL Replication with ProxySQL on WHM/cPanel Servers - Part 1

In this two-part blog series, we are going to give a complete walkthrough on how to run MySQL Replication with ProxySQL on WHM cPanel servers. This first part covers the deployment of MySQL Replication and ProxySQL, as well as ProxySQL integration with cPanel via standardized hooks integration. The second part will cover management and ongoing maintenance of the setup.

MariaDB MaxScale Load Balancing on Docker: Management - Part 2

In the previous blog, we looked at how to deploy MaxScale on Docker, and how to use Swarm service to run multiple replicas. This part focuses more on management operations with advanced use cases like service control, configuration management, query processing, security and cluster reconciliation.

MariaDB MaxScale Load Balancing on Docker: Deployment - Part 1

In this two-part blog series we are going to give a complete walkthrough on how to run the MariaDB MaxScale load balancer in a Docker environment. This first part covers the deployment using a standalone Docker container and MaxScale clustering via Docker Swarm for high availability.

Database Automation with Puppet: Deploying MySQL & MariaDB Galera Cluster

This post walks you through deployment of MySQL/MariaDB Galera Cluster using Puppet module. We’ll also look at how ClusterControl can be used to automate the management aspects of the environment once it’s set up.

Database Automation with Puppet: Deploying MySQL & MariaDB Replication

This post walks you through deployment of MySQL/MariaDB replication using Puppet module. We’ll also look at how ClusterControl can be used to automate the management aspects of the environment once it’s set up.

How to Migrate WHMCS Database to MariaDB Galera Cluster

The WHMCS software suite relies on a MySQL database to store its data, so how do you make it highly available? This blog post shows how to migrate the existing WHMCS database from a standalone MySQL server (provided by the WHM/cPanel server itself) to a three-node MariaDB Galera Cluster to improve the database availability.

Popular Docker Images for MySQL and MariaDB Server

There are many Docker images for MySQL and MariaDB, but which one should you use? This blog post lists the most popular Docker images that can be found on Docker Hub, the world's largest library and community for container images.

How to Perform a Failback Operation for MySQL Replication Setup

In case of master failure in a MySQL Replication setup, the most updated slave can be promoted to new master and all slaves repointed to the new master. But once the failed master has been fixed, what is the best way to re-introduce it as master, so as to restore the original topology.

This blog post shows how to perform the MySQL master failback operation.

Database High Availability for Camunda BPM using MySQL or MariaDB Galera Cluster

This blog post covers how to deploy a highly available MySQL or MariaDB database cluster for Camunda BPM 7.10 Community Edition on Linux. Camunda supports major databases through JDBC drivers, namely Oracle, DB2, MySQL, MariaDB and PostgreSQL. We will show two different implementations for the database endpoint, one leveraging ProxySQL and the other using the standard JDBC driver.

Pages