Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
12 blog posts in 11 categories

ClusterControl Tips & Tricks - Custom graphs to monitor your MySQL, MariaDB, MongoDB and PostgreSQL systems

This blog post will show you how to add custom graphs to ClusterControl to monitor specific MySQL, MariaDB, MongoDB or PostgreSQL metrics.

ClusterControl Tips & Tricks - Transparent Database Failover for your Applications

This blog shows you how to make database failure and failover transparent to your applications, by using HAProxy or MaxScale.

ClusterControl Tips & Tricks: Customizing your Database Backups

ClusterControl follows some best practices to perform backups using mysqldump or Percona xtrabackup. Although these work for the majority of database workloads, you might still want to customize your backups. This blog shows you how.

ClusterControl Tips & Tricks - Best Practices for Database Backups

In this blog, we will show you how to best leverage ClusterControl to build a safe and reliable backup system.

ClusterControl Tips & Tricks: MySQL Query Performance Tuning

In this blog post, we’ll look into how ClusterControl can help you solve problems related to query performance using the Query Monitor.

ClusterControl Tips & Tricks: Monitoring multiple MySQL instances on one machine

In this blog post, we’ll show you how to use ClusterControl to monitor multiple MySQL instances running on one host.

ClusterControl Tips & Tricks: Manage and Monitor your Existing MySQL NDB Cluster

Of the different types of clustered MySQL environments, NDB Cluster is among the ones that involves more effort and resource to administer. And unless you are a command line freak, you would want to use a tool that gives you a full view of what is going on in your cluster. It is possible to install ClusterControl and monitor your existing MySQL Cluster (NDB). In this blog post, we are going to show you on how to add two existing MySQL Clusters (production and staging) into ClusterControl. 

ClusterControl Tips & Tricks for MySQL: Max Open Files

You have created a large database with thousands of tables (> 5000 in MySQL 5.6). Then you want to create a backup using xtrabackup. Or, if it is a Galera cluster, you have to recover a galera node using wsrep_sst_method=xtrabackup[-v2].

ClusterControl Tips & Tricks: wtmp Log Rotation Settings for Sudo User

ClusterControl requires a super-privileged SSH user to provision database nodes. If you are running as non-root user, the corresponding user must able to execute sudo commands with or without sudo password. Unfortunately, this could generate another issue where performing remote command with “sudo” requires an interactive session (tty).

ClusterControl Tips & Tricks: User Management for MySQL

In this example we will look at how you can use ClusterControl to create a user and assign privileges to the user. We will create a user that has enough privileges to perform an xtrabackup.