Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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

ClusterControl Tips & Tricks - Dealing with MySQL Long Running Queries

Long running queries are pretty much inevitable in MySQL or MariaDB, and unfortunately, they can lead to disastrous results. But why do queries take long time to execute? How do you deal with them?

This blog post shows how you can use ClusterControl to easily detect them, especially in environments with many database instances.

Understanding the Effects of High Latency in High Availability MySQL and MariaDB Solutions

To insulate our database infrastructure from failures, we build redundant cluster systems. For instance, MySQL and MariaDB high availability can be implemented by master-slave as well as master-master replication solutions. There are a number of variables that affect our choice solution. In this blog, we will look into considerations around latency.

How to Run and Configure ProxySQL 2.0 for MySQL Galera Cluster on Docker

ProxySQL 2.0 has become GA and it comes with new exciting features such as GTID consistent reads, frontend SSL, Galera and MySQL Group Replication native support. This blog post shows how to run the new ProxySQL 2.x for Galera Cluster on Docker container, which is quite a bit different as compared to ProxySQL 1.x.

HA for MySQL and MariaDB - Comparing Master-Master Replication to Galera Cluster

Replication and Galera Cluster are both widely used to implement high availability for MySQL/MariaDB, but when should you pick one over the other? What are the limitations of each solution, and what are the trade offs?
In this blog post, we will look at the differences in terms of data consistency, conflict resolution, failover, node provisioning and robustness.

High Availability on a Shoestring Budget - Deploying a Minimal Two Node MySQL Galera Cluster

Learn how to set up a Galera cluster with just 2 nodes and use Garbd to retain high availability.

Dealing with Unreliable Networks When Crafting an HA Solution for MySQL or MariaDB

Networks may not be always stable or reliable, but your database clusters have to. This blog discusses the things to keep in mind when designing an HA solution for MySQL or MariaDB, deployed across potentially unreliable networks.

Hybrid OLTP/Analytics Database Workloads in Galera Cluster Using Asynchronous Slaves

Reporting and analytics is a common requirement, but should you run it on your production database? For Galera Cluster, heavy OLAP queries may interfere with the performance of regular OLTP operations. In this blog post, we’ll describe an easy way to offload OLAP workload from Galera Cluster to asynchronous replication slave.

Pages