Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

How to Minimize RPO for Your PostgreSQL Databases Using Point in Time Recovery

In a disaster recovery plan, the amount of data you can afford to lose, also called RPO, is directly dependent on Point in Time Recovery (PITR) features of your data infrastructure.

In this blog, we will see what PITR is, when it’s needed, how to easily use it with ClusterControl; and how, when setup correctly, it is an important element of a  disaster recovery plan.

Effective Monitoring of MySQL with SCUMM Dashboards Part 1

The new release of ClusterControl 1.7.0 introduces SCUMM (Severalnines ClusterControl Unified Management and Monitoring). SCUMM comes with a number of new dashboards that make database ops teams more efficient and productive. In this blog, we’ll look at how to leverage the MySQL Overview dashboard.

ClusterControl Developer Studio: Creating an Advisor to check for SELinux and Meltdown/Spectre Part 2

Advisors are a great way to extend the ClusterControl functionality and implement your own security check mechanism. It provides basic Web UI reporting, can send email alarms, and manage scripts directly through the Developer Studio..

In this part 2 of blog series, we will show you how to integrate Meltdown/Spectre vulnerability checks, setup an alarm, and debug your JS script.

ClusterControl Developer Studio: Using ClusterControl Advisor to create checks for SELinux and Meltdown/Spectre Part 1

ClusterControl Advisors is a great feature that you can extend and implement as your own security check mechanism that provides basic Web UI alarms, send email alarms, and script management directly through our Developer Studio.

In this part 1 of a blog series, we’re showing you how to check SELinux and Meltdown/Spectre vulnerability to get alarms and be notified as to the state of your servers.

A Developer’s Guide to MongoDB Sharding

This blog provides an overview of sharding in MongoDB and how it can be used concurrently with other methods to achieve high availability.

How to Monitor Your ProxySQL with Prometheus and ClusterControl

In this blog post, we’ll look into how to monitor your ProxySQL instances in-depth using ClusterControl’s new agent-based monitoring approach with Prometheus.

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.

ClusterControl Tips & Tricks: Manage and Monitor Your Existing MySQL NDB Cluster

NDB Cluster is an advanced storage engine in MySQL, and provides automatic sharding and replication of data. However, it does take quite a bit of effort to administer. This blog post explains how to import MySQL NDB Cluster into ClusterControl so you can manage it from a web interface.

How to Deploy a MySQL NDB Cluster Using ClusterControl

This blog post describes the process of easily deploying MySQL NDB Cluster using ClusterControl.

Posted in: