Database - General

Benefits for organisations who have adopted a public cloud environment for databases include quick provisioning, data redundancy, traffic workload distribution, and also failover scenarios. In this blog, we review two different database server architectures when running in a hybrid cloud environment. Benefits for organisations who have adopted a public cloud environment for databases include quick provisioning, data redundancy, traffic workload distribution, and also failover scenarios. In this blog, we review two different database server architectures when running in a hybrid cloud environment.

Prior to MySQL 5.5, MyISAM was the default storage engine. In this blog post we will cover when, how, and why should you use MyISAM for MySQL.

This blog will guide you through the database options for Moodle and explain why MySQL or PostgreSQL is your best option for easy management, lower costs, and high availability.

Character sets determine what characters are valid in a query string. In this blog, we discuss the importance and performance implications of choosing different character sets in MySQL.

E-learning management systems, especially Moodle, can be used for blended learning, distance education and other e-learning projects in schools. This blog post will help you understand the value of database automation in them.

ClusterControl has a powerful, easy-to-use, and friendly UI, but using this UI is not the only way to manage your clusters. In this blog, we will show you how to use the ClusterControl CLI called s9s and what are the secret things that you can do using it.

MongoDB uses journaling to make sure that write operations are successful. This also helps prevent crashes.  In this blog we will provide an overview of the MongoDB journal and how to manage it.

The new Lookup fields feature from MongoDB Charts - dubbed Lookup Charts by the users - let’s you create a single chart from multiple data arrays without complicated coding and querying requirements. In this blog we will take a closer look at this new feature.

Staying alerted about your database operations is important. In this blog we will look at what kind of alarms you should enable and when they are needed.

Partitioning is a database design technique in which a database splits data into multiple tables, but still treats the data as a single table by the SQL layer. In this blog post, we discuss the advantages and disadvantages of partitioning in MySQL.

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.