Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

Posted in:

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.

Capacity Planning for MySQL and MariaDB - Dimensioning Storage Size

How much storage should we allocate to the database depends on how fast the database is expected to grow. It sounds like a simple question to answer, but there are a number of factors to consider before we can come up with an accurate answer. This blog post gives you some tips on how to plan and dimension storage size for your MySQL and MariaDB servers in production.

Posted in:

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.

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

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

How ClusterControl Configures Virtual IP and What to Expect During Failover

This blog post covers how ClusterControl helps you to eliminate single point of failure of your database load balancers by using virtual IP address.

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

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

Pages