Database - General

The MySQL ALTER TABLE statement is used to add, delete, or modify columns in an existing table as well as to add and drop various constraints on an existing table. In this blog post we discuss the advantages and disadvantages of using the ALTER TABLE in MySQL.

Mongodump does not maintain the atomicity of transactions across the shards, that is why it can not be used as a backup strategy for mongodb version 4.2 and above in a sharded cluster. In this blog, we will have a look at a method of doing consistent backups of MongoDB Sharded Clusters.

In part two of our mini-series on MySQL Security we take a look at several security features like user management as well as the plugins that are available to help keep your data safe.

The Percona Toolkit is a set of tools to help DBAs efficiently perform their daily routine duties. This blog will show you how to use these tools (and when to be extra cautious).

Learning Management Systems (LMS) are getting more important as they allow you to learn or teach remotely. It is important to have a Highly Available environment to ensure your systems keep working in case of failure. In this blog, we show how to deploy Canvas LMS for high availability using PostgreSQL and ClusterControl.

Protecting the data stored in your database is essential. In this blog post, we discuss what we can do to make MySQL more secure. Part one focuses on general security settings and managing user privileges.

Percona Backup for MongoDB is a distributed, low-impact solution for achieving consistent backups of MongoDB sharded clusters and replica sets. In this blog we show you how to use the Percona Backup for MongoDB tool

The Percona Toolkit is a collection of command-line tools that allow you to perform a variety of database and system tasks that, in general, are too complex to perform manually. In this blog, we will show you how to install Percona Toolkit and how to use the new pt-pg-summary Percona Toolkit component.

MySQL provides support for full-text indexing and searching. In this blog post, we discuss the advantages and disadvantages of utilizing the full-text search in MySQL.

Percona Server for MongoDB is a fork of the MongoDB Community Edition. In this blog we will show you how to deploy Percona Server for MongoDB for high availability.

MongoDB drivers allow node.js applications to connect with MongoDB to work with the data. In this blog we will give an overview of the MongoDB Go Driver.

There are different types of migrations. You can migrate from a technology to a different one, to a different datacenter, to the cloud, or even in the same place and same technology to another machine. In this blog, we will look at some open-source tools for PostgreSQL migrations with a short overview of each option.

The blog summarizes current solutions for implementing Query Caching and Load Balancing in PostgreSQL. It describes the following products: pgpool-II, Apache Ingest, Heimdall Data, HAProxy, and Bucardo.

Since version 10, PostgreSQL allows you to use logical replication which, in contrast to physical replication, you can replicate between different major versions of PostgreSQL. In this blog, we will see how to upgrade PostgreSQL 11 to PostgreSQL 12 with zero downtime using logical replication.

MongoDB operation and development checklists are meant to help database administrators avoid encountering issues in the MongoDB production environment. This blog walks you through what should be part of these checklists.

MongoDB Change Streams is a feature introduced to stream information from application to the database in real-time. In this blog we’ll take a look at this new feature and how it affects MongoDB running in a production environment.

HAProxy is one of the most common Load Balancing technologies nowadays. It is powerful open-source software and has many metrics to monitor to know how everything is going on. In this blog, we will look at the HAProxy statistics and how to monitor them.

Load Balancing plays an important role in a Database as a Service. The load balancer stands in front of the database servers and presents one endpoint to applications. In this blog we take a look at load balancing with DBaaS providers.

A MySQL database index is a data structure that improves the speed of operations in a table. In this post, we discuss the benefits and the drawbacks of using indexes in MySQL.

Load balancers can be deployed into a number of topologies to achieve high availability for the database service with zero single-point-of-failure (SPOF). This blog post covers the pros and cons of distributed or centralized setup for your database load balancers.

GridFs is an abstraction layer in MongoDB used in the storage and recovery of large files like videos, audios, and images. This blog will show you how to use this new feature.