Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
Answer
Close
Polls
How are you currently backing up your data?
Submit
Custom backup scripts scheduled with CRON
ClusterControl
On-prem DB backup tool
Storage snapshot backup
Online backup service
Other
Thank you for submiting your answer!
Please select another item to change your answer.
Results so far (Total Voters: 21):
  • Custom backup scripts scheduled with CRON (43%, 9 Votes)

  • ClusterControl (0%, 0 Votes)

  • On-prem DB backup tool (14%, 3 Votes)

  • Storage snapshot backup (14%, 3 Votes)

  • Online backup service (10%, 2 Votes)

  • Other (19%, 4 Votes)

90 blog posts in 13 categories

How to Improve Replication Performance in a MySQL or MariaDB Galera Cluster

Can we increase Galera performance if we speed up applying data that is replicated between its nodes? In this blog post, we assess the impact of having multiple wsrep_slave_threads on the overall performance of Galera cluster.

How to Monitor MySQL or MariaDB Galera Cluster with Prometheus Using SCUMM

In this blog, we will show you how to monitor Galera Cluster for MySQL or MariaDB using Prometheus. We will have a look at the newly released SCUMM architecture for agent-based monitoring and how ClusterControl deploys Prometheus and exporters to collect database metrics and the graphs available in the different dashboards.

Become a ClusterControl DBA: Operational Reports for MySQL, MariaDB, PostgreSQL & MongoDB

The idea behind ClusterControl operational reporting is to put all of the most relevant data into a single document which can be quickly analyzed in order to get a clear understanding of the status of the databases and its processes. This blog post shows how to leverage the ops report functionality to understand the state of your MySQL, MariaDB, MongoDB and PostgreSQL infrastructure.

Become a ClusterControl DBA: Performance and Health Monitoring

This blog post shows how to leverage ClusterControl performance monitoring and advisors functionality to keep your MySQL, MongoDB and/or PostgreSQL databases and clusters healthy.

How to Deploy a Production-Ready MySQL or MariaDB Galera Cluster using ClusterControl

ClusterControl can be used to deploy open-source database clusters that are configured in complex topologies. The full high availability stack includes both database and proxy layers.

In this blog, we are going to show you how to deploy a production-grade Galera Cluster, complete with load balancers, for a high availability setup.

How to Monitor your Database Servers using ClusterControl CLI

In this blog post, we will show you how you can monitoring your database clusters using your terminal and the s9s Command Line Interface.

MySQL on Docker: How to Monitor MySQL Containers with Prometheus - Part 1 - Deployment on Standalone and Swarm

Prometheus is an open-source software for monitoring and alerting, it depends on exporters to ‘scrape’ information from e.g., MySQL running on Docker. In this blog, we’ll see how to deploy the database as well as the monitoring stack with Prometheus and its components. We’ll do this for both MySQL running on standalone Docker containers as well as a Galera Cluster running on Docker Swarm.

Asynchronous Replication Between MySQL Galera Clusters - Failover and Failback

Asynchronous replication places no low latency demands on the network, so it is possible to keep Galera Clusters in sync even when they are thousands of miles apart and utilise low-cost connections. We effectively can achieve a global system of loosely-coupled clusters. However, managing the global state translates into managing failover and failback operations at both node and cluster level.

Galera Cluster Recovery 101 - A Deep Dive into Network Partitioning

Galera automatic node provisioning and membership control simplifies database cluster operation and improves the reliability of its replication technology. In this blog post, we are diving into the Galera recovery process in events where network partitioning happens.

How to Improve Performance of Galera Cluster for MySQL or MariaDB

Galera Cluster comes with many cool features and advantages over traditional asynchronous replication, but these do not automatically translate into higher performance. In this blog post, we will look at what drives MySQL/MariaDB Galera performance, and see how we can get the most out of the cluster.

Pages