Categories
Products
Technologies
Top Rated docs

November 2, 2018

Effective Monitoring of MySQL With SCUMM Dashboards: Part 3

We discussed in our previous blogs about the MySQL-related dashboards. We highlighted the things that a DBA can benefit from by studying the graphs, especially when performing their daily routines from diagnostics, metric reporting, and...

October 31, 2018

How to Create a Single Endpoint for Your PostgreSQL Replication Setup using HAProxy

Managing traffic to the database can get harder and harder as it increases in amount and the database is actually distributed across multiple servers. PostgreSQL clients usually talk to a single endpoint. When a primary...

October 30, 2018

SQL Firewalling Made Easy with ClusterControl & ProxySQL

Reading the title of this blog post may raise some questions. SQL firewall - what is that? What does it do? Why would I need something like that in the first place? Well, the ability...

October 26, 2018

How to Cluster Your ProxySQL Load Balancers

A proxy layer between applications and databases would typically consist of multiple proxy nodes for high availability. This is no different for ProxySQL. ProxySQL, just like other modern proxies, can be used to build complex...

October 25, 2018

Choosing a Database Proxy for MySQL & MariaDB

We’re happy to announce that our new whitepaper Choosing a Database Proxy for MySQL and MariaDB is now available to download for free! Load balancing and high availability go hand-in-hand. Without them, you are left...

October 24, 2018

Effective Monitoring of MySQL Replication With SCUMM Dashboards: Part 2

In our previous blog on SCUMM dashboards, we looked at the MySQL overview dashboard. The new version of ClusterControl (ver. 1.7) offers a number of high resolution graphs of useful metrics, and we went through...

October 19, 2018

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

In a disaster recovery plan, your Recovery Point Objective (RPO) is a key recovery parameter that dictates how much data you can afford to lose. RPO is listed in time, from seconds to days. Effectively,...

October 19, 2018

Effective Monitoring of MySQL With SCUMM Dashboards: Part One

We added a number of new dashboards for MySQL in our latest release of ClusterControl 1.7.0. - and in our previous blog, we showed you How to Monitor Your ProxySQL with Prometheus and ClusterControl. In...

October 17, 2018

Creating an Advisor to Check for SELinux and Meltdown/Spectre: Part Two

In part 1 of this blog, we showed you how to integrate a basic check with SELinux modes. In this part 2 blog, we’ll discuss and go over with Meltdown/Spectre integration to our Advisors, set...

October 16, 2018

Using ClusterControl Advisor to Create Checks for SELinux and Meltdown/Spectre: Part One

We previously showed you how to create your first database advisor in ClusterControl. Now let’s see how we can create a security advisor to check for SELinux and Meltdown/Spectre. We will be using the ClusterControl...

October 12, 2018

How to Monitor Your ProxySQL with Prometheus and ClusterControl

ClusterControl 1.7.0 introduces a bold new feature - integration with Prometheus for agent-based monitoring. We called this SCUMM (Severalnines ClusterControl Unified Management and Monitoring). In the previous versions, the monitoring tasks were solely performed agentlessly....

October 11, 2018

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

ClusterControl version 1.7 introduced a new way to watch your database clusters. The new agent-based approach was designed for demanding high-resolution monitoring. ClusterControl agentless, secure SSH-based remote stats collection has been extended with modern high-frequency...

Subscribe below to be notified of fresh posts