Database - General

Multi-datacenter is a common part of a DRP, but how can we use it in a simple way? And how can we deploy PostgreSQL to work on this topology? In this two-part blog, we will show how to implement a multi-datacenter setup for PostgreSQL covering topics like connectivity, deployment, and HA. This first part will show how to connect two datacenters via SSH.

This blog gives information for database designers, DBA’s and Developers who are new to Oracle NoSQL or MongoDB to help understand the terms and data model differences between these two NoSQL technologies.

PostgreSQL 12 comes with a great new feature called Generated Columns. In this blog, we’ll describe this new feature in detail, show how it works, and how to emulate this in a previous PostgreSQL version.

Database performance problems can happen anytime, one of the problems could be CPU related. Without fixing the cause, it will lead to more serious problems. This blog delivers some basic steps on how we can identify the problem from CPU utilization.

Percona Server for MongoDB is an enhanced open source and highly scalable database that may act as a compatible drop-in replacement for MongoDB Community Edition but with similar syntax and configuration. In this blog we will discuss the Percona version of MongoDB and how it expands the power of MongoDB in a variety of ways.

Disk space is an important but limited resource for all companies as they need to store data as long as possible. In this blog, we will see how we can detect a PostgreSQL out of disk issue, how you can prevent it and fix it if needed.

This blog provides an overview of the many new features and functions included in MongoDB 4.2

Everyone is out to get your data. The first step to protecting your database is knowing if you are vulnerable. This blog provides a checklist to help you determine just how secure your database is.

Running an efficient PostgreSQL operation can be challenging. In this blog we will show you how you can setup and optimize job scheduling for your PostgreSQL database

In this blog, we will help you to set database KPI for the Mysql 8.0 monitoring, and things that may cause harm to it. Knowledge of how to use limited resources is essential for anybody managing a production database.

MySQL 8.0 has important performance and security improvements and there are several things to take into account before taking it into production. In this blog, we’ll look at the new MySQL 8.0 features, some deprecations, and what you need to keep in mind before migrating.

ClusterControl provides full end-to-end database management & automation for MongoDB 4.2. In this blog, we will show you how you can easily deploy MongoDB 4.2 replicaSet and SharedCluster with ClusterControl 1.7.5

In the new 1.7.5 version, ClusterControl has added support for PostgreSQL 12. It means you can deploy, import, and perform all the well-known management and monitoring tasks that you usually do over this new PostgreSQL version, and even use some of the newly released features. In this blog, we’ll take a look at these features and see how to deploy PostgreSQL 12 with ClusterControl.

The internet can be a dangerous place for data that isn’t protected. Using a VPN connection is one way to protect your data in transit by encrypting the traffic over the internet. In this blog, you’ll show how to configure an OpenVPN server in a database node running in the cloud, and how to access it using a VPN client.

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.