Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Announcing ClusterControl 1.5 - Featuring Automatic Backup Verification and Cloud Upload

This blog provides an overview of the new features and functions contained in the ClusterControl 1.5 release.

The Galera Cluster & Severalnines Teams Present: How to Manage Galera Cluster with ClusterControl - The Replay

Introducing the replay of our joint webinar with the Galera Cluster Team in which we hear from Seppo Jaakola, CEO at Codership - the creators of Galera Cluster - on what the latest is on the most popular HA technology for MariaDB & MySQL and demonstrate how to manage it with ClusterControl.

MySQL & MariaDB Database Backup Resources

This blog provides a list of all our best resources created to help users build and executive an effective and efficient MySQL and MariaDB database backup strategy & plan.

HAProxy Connections vs MySQL Connections - What You Should Know

Max connections determines the maximum number of connections to the database server. This can be set on both the database server, or the proxy in front of it. In this blog post, we’ll dive into HAProxy and MySQL maximum connections variables, and see how to get the best of both worlds.

Posted in:

How to Stop or Throttle SST Operation on a Galera Cluster

A full node resync, or SST, can be a heavy, long-running operation that impacts the performance and stability of a Galera Cluster. This blog post explains a trick on how to stop an ongoing SST operation in a clean manner.

Posted in:

How to Automate Galera Cluster Using the ClusterControl CLI

As sysadmins and developers, we spend a lot our time in a terminal. So we brought ClusterControl to the terminal with our command line interface tool called s9s. This blog post shows how to use s9s to automate management of a Galera Cluster and a master-slave replication setup.

Posted in:

[Updated] Monitoring Galera Cluster for MySQL or MariaDB - Understanding metrics and their meaning

Read this blog to find out how ClusterControl combines the two most popular types of monitoring, and see how it presents needed information on Galera Cluster and how we should interpret it.

Posted in:

New Tutorial: MySQL & MariaDB Load Balancing with ProxySQL

Our new ProxySQL Tutorial gives you everything you need to learn about in order todeploy, manage and maximize this exciting new database-aware load balancing technology.

Galera Cluster Comparison - Codership vs Percona vs MariaDB

The blog post compares the three Galera Cluster variants - MySQL Galera Cluster by Codership, Percona XtraDB Cluster by Percona and MariaDB 10.x by MariaDB.

Posted in:

DevOps Considerations for Production-ready Database Deployments

MySQL is easy to install and use, it has always been popular with developers and system administrators. On the other hand, a production-ready MySQL environment for a business-critical enterprise workload is a different story. It can be a bit of a challenge, and requires in-depth knowledge of the database. This blog discusses some of the steps which have to be taken before we can consider our MySQL deployment production-ready.

Pages