Migrating Google Cloud SQL for MySQL to an On-Prem Server
Google Cloud SQL for MySQL is a fully-managed database service that helps you set up, maintain, manage, and administer your MySQL relational databases on Google Cloud Platform. However, there are differences between Cloud SQL and...
An Overview of PostgreSQL 13 libpq sslpassword Connection Parameters
PostgreSQL since long has supported SSL connections and also certificate-based authentication mechanisms. Although nothing in this regard seems to be new for the PostgreSQL world. However, a small nagging issue for client connection (client-certificates based...
A Development & Operations Checklist for MongoDB
MongoDB operation and development checklists are meant to help database administrators avoid encountering issues in the MongoDB production environment. A Development Checklist should address issues such as... Schema design Data durability Replication Drives Sharding An...
Comparing Load Balancers for PostgreSQL
Load balancing increases system performance, especially from the application standpoint, allowing several computers to serve the same data. It works such that the load is being distributed among client queries to replica nodes aside from...
MaxScale Basic Management Using MaxCtrl for MariaDB Cluster – Part Two
In the previous blog post, we have covered 4 basic management components using the MaxCtrl command-line client. In this blog post, we are going to cover the remaining part of the MaxScale components which are...
An Overview of Trusted Extensions in PostgreSQL 13
In my previous blog, we explored new capabilities of Logical replication with Partition tables in PostgreSQL 13. Needless to say that there are multitude of such features in the mentioned release which will soon enhance...
How to Support Your DevOps Team With Their Database Needs
DevOps, by a simple definition, is a person who has to perform an operational duty “the developer's way”. It's like a blending of two worlds - software development and system or database administration - for...
MariaDB Server Database Encryption Basics
Encryption is one of the most important security features to keep your data as secure as possible. Depending on the data that you are handling, not always it is a must but you should at...
MaxScale Basic Management Using MaxCtrl for MariaDB Cluster
In the previous blog post, we have covered some introductions to MaxScale installation, upgrade, and deployment using MaxCtrl command-line client. In this blog post, we are going to cover the MaxScale management aspects for our...
What's New in MariaDB MaxScale 2.4
MaxScale 2.4 was released on December 21st, 2019, and ClusterControl 1.7.6 supports the monitoring and managing up to this version. However, for deployment, ClusterControl only supports up to version 2.3. One has to manually upgrade...
Exploring Storage Engine Options for MariaDB
MariaDB Server was originally derived from MySQL and has therefore inherited its pluggable storage engine architecture. Different storage engines have different characteristics in terms of performance but also features and possibilities. This allows users to...
Introduction to MaxScale Administration Using maxctrl for MariaDB Cluster
MariaDB Cluster consists of MariaDB Server with Galera Cluster and MariaDB MaxScale. As a multi-master replication solution, any MariaDB Server with Galera Cluster can operate as a primary server. This means that changes made to...