Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Become a ClusterControl DBA: Adding Existing Databases and clusters (updated)

In our previous blog post we covered the deployment of four types of clustering/replication: MySQL Galera, MySQL master-slave replication, PostgreSQL replication set and MongoDB replication set. This should enable you to create new clusters with great ease, but what if you already have 20 replication setups deployed and wish to manage them with ClusterControl?

Become a ClusterControl DBA - SSL Key Management and Encryption of MySQL Data in Transit

In this blog post, we’ll show you how to generate self-signed certificates using ClusterControl, and encrypt all data traffic e.g. within a Galera Cluster and between MySQL databases and its clients.

Become a ClusterControl DBA: Operational Reports for MySQL and MariaDB

This blog describes the Additional Operational Reports for MySQL and MariaDB, which are available in the new ClusterControl 1.3 and how to best make use of them.

Become a ClusterControl DBA: User Management

Learn how to delegate tasks and grant access to users and groups in ClusterControl by utilizing User Management.

Become a ClusterControl DBA: Managing your logfiles

Learn about where to find the various system and database log files for MySQL, MongoDB & PostgreSQL and learn how to identify and resolve issues using ClusterControl’s log functionalities.

Become a ClusterControl DBA: Managing your Database Configurations

Learn about how to manage, alter and template your database configurations in ClusterControl for MySQL, MongoDB & PostgreSQL.

Become a ClusterControl DBA: Safeguarding your Data

So now that you have your databases up and running and highly available, how do you ensure that you have backups of your data? You can use backups for multiple things: disaster recovery, to provide production data to test against development or even to provision a slave node. This last case is already covered by ClusterControl. When you add a new (replica) node to your replication setup, ClusterControl will make a backup/snapshot of the master node and use it to build the replica. 

Become a ClusterControl DBA: Making your DB components HA via Load Balancers

There are various ways to retain high availability with databases. You can use Virtual IPs (VRRP) to manage host availability, you can use resource managers like Zookeeper and Etcd to (re)configure your applications or use load balancers/proxies to distribute the workload over all available hosts.

Become a ClusterControl DBA: performance monitoring and health

In the previous two blog posts we covered both deploying the four types of clustering/replication (MySQL / Galera, MySQL Replication, MongoDB & PostgreSQL) and managing/monitoring your existing databases and clusters. So, after reading these two first blog posts you were able to add your 20 existing replication setups to ClusterControl, expand them and additionally deployed two new Galera clusters while doing a ton of other things. Or maybe you deployed MongoDB and/or PostgreSQL systems.

Become a ClusterControl DBA - Deploying your Databases and Clusters

Many of our users speak highly of our product ClusterControl, especially how easy it is to install the software package. Installing new software is one thing, but using it properly is another. We all are impatient to test new software and would rather like to toy around in a new exciting application than to read documentation up front. That is a bit unfortunate as you may miss the most important features or find out the way of doing things yourself instead of reading how to do things the easy way.