How to Install ClusterControl to a Custom Location
ClusterControl consists of a number of components and one of the most important ones is the ClusterControl UI. This is the web application through which the user interacts with other backend ClusterControl components like controller,...
MySQL InnoDB Cluster 8.0 – A Complete Operation Walk-through: Part Two
In the first part of this blog, we covered a deployment walkthrough of MySQL InnoDB Cluster with an example on how the applications can connect to the cluster via a dedicated read/write port. In this...
PostgreSQL Deployment & Configuration with Puppet
Puppet is open source software for configuration management and deployment. Founded in 2005, it’s multi-platform and even has its own declarative language for configuration. The tasks related to administration and maintenance of PostgreSQL (or other...
Converting from Asynchronous to Synchronous Replication in PostgreSQL
High Availability is a requirement for just about every company around the world using PostgreSQL It is well known that PostgreSQL uses Streaming Replication as the replication method. PostgreSQL Streaming Replication is asynchronous by default,...
Tips for Migrating from MySQL Replication to MySQL Galera Cluster 4.0
We have previously blogged about What’s New in MySQL Galera Cluster 4.0, Handling Large Transactions with Streaming Replication and MariaDB 10.4 and presented some guides about using the new Streaming Replication feature in a part...
MySQL InnoDB Cluster 8.0 – A Complete Deployment Walk-Through: Part One
MySQL InnoDB Cluster consists of 3 components: MySQL Group Replication (a group of database server which replicates to each other with fault tolerance). MySQL Router (query router to the healthy database nodes) MySQL Shell (helper,...
An Overview of pgModeler for PostgreSQL
When a project is being designed, the first thing to think about is what its purpose will be... what is the best solution, and what are the alternatives. In software engineering, everything is done to...
An Overview of Various Auxiliary Plan Nodes in PostgreSQL
All modern database system supports a Query Optimizer module to automatically identify the most efficient strategy for executing the SQL queries. The efficient strategy is called “Plan” and it is measured in terms of cost...
Creating a PostgreSQL Replication Setup on Debian / Ubuntu
PostgreSQL can work separately on multiple machines with the same data structure, making the persistence layer of the application more resilient and prepared for some unexpected event that might compromise the continuity of the service....
An Overview of the JOIN Methods in PostgreSQL
In my previous blog, we discussed various ways to select, or scan, data from a single table. But in practical, fetching data from a single table is not enough. It requires selecting data from multiple...
Comparing Temporary Tables for PostgreSQL & Oracle GTT
The temporary tables are a useful concept present in most SGBDs, even though they often work differently. This blog describes the technical features for this kind of tables either in PostgreSQL (version 11) or Oracle...
ProxySQL Native Clustering with Kubernetes
ProxySQL has supported native clustering since v1.4.2. This means multiple ProxySQL instances are cluster-aware; they are aware of each others' state and able to handle the configuration changes automatically by syncing up to the most...