Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

An Overview of PostgreSQL & MySQL Cross Replication

The blog gives a detailed account of achieving cross replication between MySQL and PostgreSQL databases using two of the renowned tools of the open source community. A step-by-step demo configuration gives the audience an easy to implement guide including a summarized explanation of which tool is rated over the other.

How to Setup MariaDB 10.3 Replication Using Ansible and Vagrant

Ansible is a system that allows you to automate the deployment of various IT services. In this blog, we’ll show you how to expedite the deployment of your MariaDB master/slave environment using some Vagrant boxes and Ansible playbook.

Database Automation with Puppet: Deploying MySQL & MariaDB Replication

This post walks you through deployment of MySQL/MariaDB replication using Puppet module. We’ll also look at how ClusterControl can be used to automate the management aspects of the environment once it’s set up.

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.

Monitoring & Ops Management of MySQL 8.0 with ClusterControl

MySQL 8.0 is a big step forward in terms of data consistency, developer features, performance and availability. MySQL 8.0 shortens the gap between proprietary databases and open source world, making the migration decision much easier to take.

But how can you manage it, along with other relational open source databases? In this blog post, we look at the challenges of operating a MySQL 8.0 database, and see how important tasks like monitoring, alerting, backups and failover can be handled in an automated way.

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.

MySQL on Docker: Multiple Delayed Replication Slaves for Disaster Recovery with Low RTO

A delayed replication slave is useful in recovering from accidental data deletion. But how long should the delay be? Too short delay might not be enough for you to get to a terminal and stop an offending query. Too long delay means a long recovery time when catching up.

This blog post shows how to deploy multiple MySQL delayed slaves on one single physical host with Docker, and shows some of the recovery scenarios.

Effective Monitoring of MySQL Replication with SCUMM Dashboards - Part 2

The new release of ClusterControl 1.7.0 introduces SCUMM (Severalnines ClusterControl Unified Management and Monitoring). Monitoring MySQL with SCUMM Part 1 adds the efficiency and productivity for a MySQL Database Administrator.

MySQL on Docker: Running ProxySQL as a Helper Container on Kubernetes

When your application containers are orchestrated and managed by Kubernetes, you might want to use ProxySQL to better take advantage of your distributed database service running on replication or Galera. In this post, we are going to cover how to run ProxySQL on Kubernetes as a helper container in a pod.

An Overview of Volume Level Replication for PostgreSQL Using DRBD

Volume level replication is a generic approach that not only applies to PostgreSQL, but also all relational databases. In this blog, we’ll show you how to use DRBD,  a distributed replicated storage system for Linux, to replicate your database for high availability.

Pages