Best Practices for Database Backups
Backups - one of the most important things to take care of while managing databases. It is said there are two types of people - those who backup their data and those who will backup...
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...
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...
Running ProxySQL as Kubernetes Service
When running distributed database clusters, it is quite common to front them with load balancers. The advantages are clear - load balancing, connection failover and decoupling of the application tier from the underlying database topologies....
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...
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...
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...
Running ProxySQL as a Helper Container on Kubernetes
ProxySQL commonly sits between the application and database tiers, in so called reverse-proxy tier. When your application containers are orchestrated and managed by Kubernetes, you might want to use ProxySQL in front of your database...
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....
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...
Manage and Monitor Your Existing MySQL NDB Cluster
Of the different types of clustered MySQL environments, NDB Cluster is among the ones that involves most effort and resources to administer. And unless you are a command line guru, you would want to use...
How to Deploy a MySQL NDB Cluster Using ClusterControl
MySQL NDB Cluster is one of the best solutions to implement shared-nothing databases, which are durable and scale well. NDB cluster consists of several elements: there are management servers, data nodes and SQL nodes. Each...