Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

Getting Started with ProxySQL - MySQL & MariaDB Load Balancing Tutorial

Our ProxySQL Tutorial gives you everything you need to learn about in order to deploy, manage and maximize this exciting new database-aware load balancing technology.

Posted in:

Migrating from MySQL to PostgreSQL - What You Should Know

This blog provides a high level overview of what you need to know if you are considering migrating your database from MySQL to PostgreSQL.

Comparing Oracle RAC HA Solution to Galera Cluster for MySQL or MariaDB

This blog provides a comparison of achieving high availability with Oracle RAC vs MySQL Galera Cluster.

Posted in:

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.

New Webinar on How to Design Open Source Databases for High Availability

Join us March 27th for this webinar on how to design open source databases for high availability. From discussing high availability concepts through to failover or switch over mechanisms, we’ll cover all the need-to-know information when it comes to building highly available database infrastructures.

Posted in:

Failover for MySQL Replication (and others) - Should it be Automated?

This blog discusses whether automated failover should be used in a MySQL Replication environment setup.

Posted in:

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.

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