Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Database-Aware Load Balancing: How to Migrate from HAProxy to ProxySQL

HAProxy is a great piece of software, but it may just not be enough for more demanding users and environments. How do you migrate from HAProxy to ProxySQL? This blog post explains the process and shows how ClusterControl can help.

Popular Docker Images for MySQL and MariaDB Server

There are many Docker images for MySQL and MariaDB, but which one should you use? This blog post lists the most popular Docker images that can be found on Docker Hub, the world's largest library and community for container images.

How to Execute and Manage MySQL Backups for Oracle DBA’s

Whether you’re planning to migrate from Oracle database to MySQL or run your new project with MySQL, you need to know how to do copies of your data. In this blog post, we will cover some of the most typical cases of the data backups with reference to Oracle backup methods. We will tell you how to guard yourself against data loss, what tools and commands to use, and how can you recover your data.

What’s New in ProxySQL 2.0

ProxySQL 2.0 has been released recently with quite a few interesting features, including causal reads, SSL for frontend connections and native support for Galera Cluster. In this blog post, we will explore these new features.

Benchmarking Manual Database Deployments vs Automated Deployments

Good system administrators and devops hate performing mundane tasks and constantly look for ways at automating themselves out of the job. There are plenty of automation tools out there to help the cause. But if automation is a no brainer, why aren’t more people doing it? In this blog post we compare three ways of deploying a MySQL Galera cluster - manual, Ansible playbook and ClusterControl.

How to Perform a Failback Operation for MySQL Replication Setup

In case of master failure in a MySQL Replication setup, the most updated slave can be promoted to new master and all slaves repointed to the new master. But once the failed master has been fixed, what is the best way to re-introduce it as master, so as to restore the original topology.

This blog post shows how to perform the MySQL master failback operation.

How to Deploy Open Source Databases - New Whitepaper

Choosing which DB engine to use between all the options we have today is not an easy task. An that is just the beginning. After deciding which engine to use, you need to learn about it and actually deploy it to play with it. In this whitepaper we’ll show you how to install, configure and secure some of the most popular open source DB engines.

Database High Availability for Camunda BPM using MySQL or MariaDB Galera Cluster

This blog post covers how to deploy a highly available MySQL or MariaDB database cluster for Camunda BPM 7.10 Community Edition on Linux. Camunda supports major databases through JDBC drivers, namely Oracle, DB2, MySQL, MariaDB and PostgreSQL. We will show two different implementations for the database endpoint, one leveraging ProxySQL and the other using the standard JDBC driver.

MySQL Replication for High Availability - New Whitepaper

This whitepaper covers information about MySQL Replication, with information about the latest features introduced in 5.6, 5.7 and 8.0. There is also a more hands-on, practical section on how to quickly deploy and manage a replication setup using ClusterControl.

Deploying Secure Multicloud MySQL Replication on AWS and GCP with VPN

MySQL Replication is still favored by some organization as it's simple to implement and run. However, in a multi-cloud setup like Google Cloud Platform <–> Amazon Web Services, things can get tedious without proper cluster management, monitoring and observability tools. This blog showcases how to create a secure implementation of cloud <–> cloud replication and how ClusterControl can be used to resolve these impediments.