Best Practices for Enabling Database Alarms & Notifications
Database Alarms and Notifications are one of the best ways to notify us of what's going on with our monitored database servers. This does not limit alone to the database systems but the whole picture...
Database Design 101: Partitions in MySQL
In this blog post we are going to be discussing one of the most widely used features of MySQL - partitions. What is Partitioning? In MySQL, partitioning is a database design technique in which a...
ALTER TABLE in MySQL: Friend or Foe?
The ALTER TABLE statement is one of the most frequently used statements in the MySQL world - the statement allows you to add, delete or modify columns in a table. In this blog post we...
MongoDB Backup Management Tips for Sharded Clusters
Making proper backups of the database is a critical task. Besides setting the high availability architecture of your MongoDB for database services, you also need to have backups of your databases to ensure the availability...
How to Secure MySQL: Part Two
In the previous post about MySQL security, we have covered a range of options that can be used to make your MySQL instance(s) more secure. They included: General MySQL security measures; Controlling access in MySQL;...
A Look at the Percona Toolkit
The Percona Toolkit (PT Toolkit) was initially designed as a swiss army knife for MySQL/MariaDB/Percona Server and its underlying operating system to perform advanced database and system administration tasks that are hard to perform especially...
How to Deploy a Highly Available Canvas LMS with a PostgreSQL Database Cluster
In these pandemic times, Learning Management System (LMS) platforms are getting more and more important to allow you to continue learning remotely when the traditional education system just isn’t available anymore. Having an LMS platform...
How to Secure MySQL: Part One
Whenever application security is mentioned, people think of securing applications against some of the most frequent attacks such as injection, broken authentication, sensitive data exposure, and the like. However, while these attacks are prevalent, knowing...
An Overview of Percona Backup for MongoDB
The known and popular backup method for MongoDB is mongodump. It is a logical backup method, similar to mysqldump in MySQL or pg_dump in PostgreSQL database. There is another backup tool called Percona Backup for...
Using the pt-pg-summary Percona Toolkit for PostgreSQL
The Percona Toolkit is a powerful, free, and open-source product developed by Percona. It is a collection of command-line tools that allow you to perform different MySQL, MongoDB, PostgreSQL, and system tasks that, in general,...
Full-Text Searches in MySQL: The Good, the Bad and the Ugly
Sometimes when searching in a MySQL database you might want to run full-text search queries against character-based data. Today we’re discussing the advantages and disadvantages of such search methods. What are Full-Text Searches in MySQL?...
How to Deploy Percona Server for MongoDB for High Availability
High availability is a must when you run critical services in your production environment. It can be achieved by eliminating all single points of failures, including the database tier. So you can imagine our surprise...