MySQL

Severalnines was a sponsor at 2018’s Percona Live Europe which was held in Frankfurt, Germany. This blog details our participation at the event and includes the slides from the sessions we presented.

ClusterControl provides centralized backup management for MySQL and MariaDB, and it supports the main backup tools - mysqldump, xtrabackup and mariabackup. The command line arguments used are supposed to be the most optimal for most use cases, but you might still want to customize these to fit your particular needs. In this post, we will show you how to do that.

This blog is about good practices for taking database backups using ClusterControl 1.7. ClusterControl’s centralized backup management for MySQL, MariaDB, PostgreSQL and MongoDB provides you with hot backups of large datasets, point in time recovery, at-rest and in-transit data encryption, data integrity via automatic restore verification, cloud backups (AWS, Google and Azure) for Disaster Recovery, retention policies to ensure compliance, and automated alerts and reporting.

In this 3rd part of the blog series, we’ll discuss what ClusterControl’s new InnoDB Metrics and MySQL Performance dashboards have to offer. These dashboards provide a pretty in-depth view of MySQL performance. We’ll go through the different graphs, and see how a DBA can leverage them.

Maintenance is something that an operation team can not avoid. ClusterControl can be configured to simplify your maintenance routines. In this post, we’ll show you some advanced use cases of cluster-wide maintenance with iterations using ClusterControl CLI.

This blog describes how to use ClusterControl and ProxySQL to implement an SQL firewall in front of your database servers. The firewall uses a regular expression matching engine to inspect SQL statements going to the database through the proxy, and determines whether to allow, block, reroute or rewrite the incoming query.

When your application containers are orchestrated and managed by Kubernetes, you might want to use ProxySQL in front of your database servers. In this post, we’ll show you how to configure ProxySQL as a Kubernetes service.

ProxySQL typically sits between the applications and the database servers, so we have to be careful that it does not become a single point of failure (SPOF). In this blog post, we’ll explain how you can set up a ProxySQL cluster for redundancy.

This whitepaper will discuss what proxies are, what their use is and how to build a highly available and highly controllable MySQL and MariaDB database environment using modern proxies such as HAProxy, ProxySQL and MaxScale.

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.

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.

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.

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.

Announcing the availability of our first white paper on ClusterControl, the only management system you’ll ever need to automate and manage your open source database infrastructure! Download ClusterControl - The Guide today!

This blog provides an overview of the new agent-based monitoring features for MySQL, Galera Cluster, PostgreSQL and ProxySQL in the ClusterControl 1.7 release.

In this webinar replay, we discuss how to effectively monitor distributed database clusters or replication setups for MySQL, MariaDB, PostgreSQL and MongoDB. We look at different types of monitoring infrastructures, from on-prem to cloud and from agent-based to agentless. Then we dive into the different monitoring features available in the free ClusterControl Community Edition - from time-series charts of metrics, dashboards and queries to performance advisors.

Advisors provide specific advice on how to address issues in areas such as performance, security, log management, configuration, storage space, etc. Learn how to write your first basic database advisor using the ClusterControl Developer Studio.

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.

In this blog post, we’ll show you how to use ClusterControl to monitor multiple MySQL instances running on one host.

This blog post will show you how to add custom graphs to ClusterControl to monitor specific MySQL, MariaDB, MongoDB or PostgreSQL metrics.

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.