Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Setting up HTTPS on the ClusterControl Server

SSL is an important part of securing your ClusterControl installation. This blog post discusses HTTPS settings for ClusterControl and how to utilize them.

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

Deploying Cloud Databases with ClusterControl 1.6

ClusterControl 1.6 comes with tighter integration with AWS, Azure and Google Cloud, so it is now possible to launch new instances and deploy MySQL, MariaDB, MongoDB and PostgreSQL directly from the ClusterControl user interface. This blog post shows you how.

Getting the Most Out of ClusterControl Community Edition

ClusterControl Community Edition is a database management system that can be used freely by database administrators and sysadmins to deploy and learn about different clustering solutions for MySQL, MariaDB, MongoDB and PostgreSQL.

Posted in:

How to do Point-in-Time Recovery of MySQL & MariaDB Data using ClusterControl

Point-in-Time recovery of MySQL & MariaDB involves restoring the database from backups prior to the target time, then uses incremental backups and the binlog to roll the database forward to the target time. This blog provides an overview of this new ClusterControl feature.

Visualizing your Cluster Topology in ClusterControl

Topology View provides a visual representation of your database nodes and load balancers in real time, in a simple and friendly interface and without the need to install any additional tools.

Announcing ClusterControl 1.6 - automation and management of open source databases in the cloud

You can now deploy MySQL, MariaDB, MongoDB and PostgreSQL clusters in the cloud. ClusterControl now supports deployments of your databases on AWS, Azure and Google Cloud. This blog provides an overview of the new features in the ClusterControl 1.6 release.

ClusterControl Tips & Tricks - Using socat on CentOS/RHEL for Streaming Backups

There are several ways to perform remote-to-remote data copy - socat, netcat, rsync, scp, sftp. ClusterControl previously used netcat for remote copy purposes, however we have flipped that decision to use socat. This blog post describes the reasons behind it.

Comparing Database Proxy Failover Times - ProxySQL, MaxScale and HAProxy

This blog describes the failover and switchover operations executed by ClusterControl, and compares failover times when using ProxySQL, MaxScale and HAProxy.

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