Backups are created at certain points to reflect (acting as a snapshot of the database) what data the database hosts at that given moment. If the database fails at a given point, we can use the last backup file to roll back the DB to a point before it failed. This blog provides you with some tips when crafting your backup policy.

Replicating from old, non-GTID MariaDB servers into GTID-enabled MariaDB clusters may cause unexpected issues. In this blog post we described what the issue is, what’s its origin and how you can work around it.

Keeping a standby node running all the time could be expensive and might not be necessary depending on the business availability requirements. In this blog, you’ll see how to create a cold standby PostgreSQL node with ClusterControl as a budget high availability alternative, how to create a backup policy and how to restore the backups in the cold standby node automatically using the AWS ClusterControl integrations.

With this blog post, we are going to show you how to automate backup maintenance so you can be sure your database backups are executed successfully and are reliable.

ClusterControl is all about delivering robust, open source, database management for the IT management needs of our clients. This goal drives us every day, so much so that it lead us to receive two awards recently from CompareCamp: the Rising Star of 2019 Award and the Great User Experience Award.

In this blog post, we are going to look into ways to customize our ClusterControl installation, especially the ClusterControl UI which by default will be located under /var/www/html (default document root of Apache).

Archiving your data provides many benefits, especially in terms of efficiency such as storage costs, optimizing data retrieval, data facility expenses, or payroll for skilled people to maintain your backup storage and its underlying hardware. In this blog, we'll look at the best practices for archiving your data in the cloud.

This blog explains how to encrypt and backup a MySQL database using Percona Server for MySQL 8.0 including tips for performing both full and incremental backups.

Galera Cluster is a high available database that can handle failure of some of its nodes just fine. How should you decide on the size of the cluster and is it enough to have a quorum to tell the cluster is highly available? This blog post will answer those questions.

This blog provides a basic overview of how to automate deployment of MongoDB using the database automation tool SaltStack.

In this blog post, we look deeper into one of the most advanced features offered by ClusterControl called automatic database recovery and failover. ClusterControl is able to recover clusters, nodes and database-related processes to ensure you achieve the best database uptime possible.

Vendor lock-in is a well-known concept for database technologies. This lock-in concept has also expanded to include cloud providers. In this blog, we’ll share some tips about how to avoid PostgreSQL cloud lock-in and also look at how ClusterControl can help in avoiding it.

This article gives an overview of the two most popular backup utilities available for MySQL, namely MySQL Enterprise Backup and Percona XtraBackup. We will discuss some best practices that can be applied to high availability topologies in order to make our backups reliable, secure and consistent.

PostgreSQL and its underlying platform solutions can help you cut down the high costs associated with an Oracle Database license; all with small to moderate changes. This blog walks you through some of the advantages of migrating from Oracle to PostgreSQL for your SQL database needs.

In a PostgreSQL database, VACUUM is the process to reclaim space occupied by dead tuples. In this blog, we will look into this process to know how it works and which options are available.