Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
20 blog posts in 1 category

Severalnines Launches #MySQLHA CrowdChat

This post discusses the official launch of our #MySQLHA Crowdchat. This CrowdChat is brought to you by Severalnines and is hosted by a community of subject matter experts. CrowdChat is a community platform that works across Facebook, Twitter, and LinkedIn to allow users to discuss a topic using a specific #hashtag. We are focusing on the hashtag #MySQLHA in this CrowdChat.

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.

Newly Updated “MySQL Load Balancing with HAProxy” Tutorial

We have recently updated our tutorial on MySQL Load Balancing with HAProxy.  Read about deployment and configuration, monitoring, ongoing maintenance, health check methods, read-write splitting, redundancy with VIP and Keepalived and more.

Get all the insight on open source database management and infrastructure operations with Severalnines whitepapers

Download our whitepapers to gain insight on how to automate and manage open source databases such as MySQL, MariaDB, MongoDB and PostgreSQL.

Posted in:

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: 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.

ClusterControl Tips & Tricks: Securing your MySQL Installation

During the life cycle of Database installation it is common that new user accounts are created. It is a good practice to once in a while verify that the security is up to standards. That is, there should at least not be any accounts with global access rights, or accounts without password. Using ClusterControl, you can at any time perform a security audit.

ClusterControl Tips & Tricks: Updating your MySQL Configuration

Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters. From time to time it is necessary to tune and update your configuration. Here we will show you how you can change/update  individual parameters using the ClusterControl UI. Navigate to Manage > Configurations.