Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
245 blog posts in 1 category

How to Customize your MySQL & MariaDB Backups with ClusterControl

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.

ClusterControl Tips & Tricks - Best Practices for Database Backups

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.

How to Create a Single Endpoint for your PostgreSQL Replication setup using HAProxy

PostgreSQL clients usually talk to a single endpoint, but what happens when you use a replication setup? Configuring the application to talk to the primary server does not work well if it fails! This blog reviews how HAProxy can be used on top of a replication setup, how to deploy and configure it, and how ClusterControl can help on these tasks.

SQL Firewalling Made Easy with ClusterControl & ProxySQL

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.

Posted in:

How to Cluster Your ProxySQL Load Balancers

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.

Posted in:

Choosing a Database Proxy for MySQL & MariaDB - New Whitepaper

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.

Effective Monitoring of MySQL Replication with SCUMM Dashboards - Part 2

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.

Webinar: Backup Management for MySQL, MariaDB, PostgreSQL & MongoDB with ClusterControl

Join us on November 13th 2018 for this webinar on Backup Management for MySQL, MariaDB, PostgreSQL and MongoDB with ClusterControl. Whether you are looking at rebuilding your existing backup infrastructure, or updating it, then this webinar is for you.

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.

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.

Pages