Database - General

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.

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

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.

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.

The automation of administrative tasks is a common practice in many companies. In this blog, you’ll learn the installation and programming of  Puppet modules in order to deploy and configure your PostgreSQL databases.

Vendor lock-in, or proprietary lock-in, occurs when a customer becomes dependent on a vendor for products and services. In this blog, we will see how to avoid it using open source tools.

This blog post shows how to send push notifications to your mobile phone via Telegram from the database server. For instance, you might want to get notified if a query takes more than 30 seconds to complete.

This blog is an overview of pgModeler, the PostgreSQL Database Modeler. It  explains how to install it and shows you around its main features and functions.

New in MySQL Galera Cluster 4.0, Streaming Replication allows you to now replicate large write-sets, which is perfect for bulk inserts or loading data to your database. In the second part we will show you how to enable Streaming Replication and what the results could look like when you use it.

New in MySQL Galera Cluster 4.0, Streaming Replication allows you to now replicate large write-sets, which is perfect for bulk inserts or loading data to your database. In the first part of this blog we will tell you about this new feature and how you can use it.

When selecting a database system, one should consider some factors regarding the kind of data you will be dealing with and whether the system you are selecting provides that capability. In this blog, we are going to discuss the advantages MongoDB offers for Big Data in comparison with Hadoop in some cases.

After experiencing some major issues with a MongoDB project our Guest Writer shares ten tips that a DBA or Developer should know before they start building a production-ready MongoDB setup.

This blog provides a high-level overview of Chef, what it does, and how you can use it to deploy a simple MongoDB database setup.

Ever wondered where to start learning to get trained in PostgreSQL? In this blog we will walk you through all the official PostgreSQL community resources and everything you need to become a PostgreSQL expert.

In this blog we’ll take a look at the most common PostgreSQL failure scenarios and show you how you can solve or cope with the issues. We’ll also look at how ClusterControl can help us get back online

Drupal is a CMS designed to create everything from tiny to large corporate websites. Failover comes in handy for any admin as it can eliminate long hours of downtime caused by corruption the need for maintenance. In this blog we’ll discuss how you can implement database failover for your MySQL or PostgreSQL databases.

Join methods are the various ways to join two tables depending on the kind of data, query, etc. In this blog, we’ll look at an overview of all the different join methods currently supported by PostgreSQL.

WordPress is, by far, the most popular CMS in the world powering millions of websites from small to large. But how can you ensure the unavailability of your database will not impact the website? In this blog post we will show how to achieve failover for your WordPress website using ClusterControl.

Scan methods are the various ways to select data from the table depending on the kind of data and percentage of data selected. In this blog, we’ll look at an overview of all the different scan methods currently supported by PostgreSQL.

In this blog, we will validate a PostgreSQL backup by restoring the backup onto a Docker container. For this post, we will use pgBackRest as the tool of choice to run the PostgreSQL backup which is maintained in a separate repository host.