This blog is aimed at explaining an overview of cross replication between PostgreSQL and MySQL, and further discussing the methods of configuring cross replication between the two database servers. Traditionally, the databases involved in a...

Here we are. Almost two decades into the 21st century and the need for more computing power is still an issue. Technology companies are pounding the pavement to tackle this massive problem head-on. Hardware engineers...

Logical Replication or Pglogical is a table level, WAL based replication mechanism which replicates the data of specific Tables between two PostgreSQL instances. There seems to be a confusion between “pglogical” and “Logical Replication”. Both...

One of the primary requirements for any database is to achieve scalability. It can only be achieved if the contention (locking) is minimized as much as possible, if not removed all together. As read /...

This is the 4th and last part in the series Benchmarking Managed PostgreSQLCloud Solutions. At the time of this writing, Microsoft Azure PostgreSQL was at version 10.7, newer than the two contenders: Amazon Aurora PostgreSQL...

Docker has become the most common tool to create, deploy, and run applications by using containers. It allows us to package up an application with all of the parts it needs, such as libraries and...

Your data is probably the most valuable assets in the company, so you should have a Disaster Recovery Plan (DRP) to prevent data loss in the event of an accident or hardware failure. A backup...

In this 3rd part of Benchmarking Managed PostgreSQL Cloud Solutions, I took advantage of Google’s GCP free tier offering. It has been a worthwhile experience and as a sysadmin spending most of his time at...

ClusterControl is an easy-to-use tool for monitoring performance of TimescaleDB in real-time. It provides dozens of predefined charts for displaying a wide variety of performance statistics regarding users, throughput, tablespaces, redo logs, buffers, caches and...

A few days ago was the release of a new version of ClusterControl, the 1.7.2, where we can see several new features, one of the main ones is the support for TimescaleDB. TimescaleDB is an...

We are excited to announce the 1.7.2 release of ClusterControl - the only database management system you’ll ever need to take control of your open source database infrastructure. ClusterControl 1.7.2 marks the first time for...

We’re happy to announce that our new whitepaper How to Deploy Open Source Databases is now available to download for free! Choosing which DB engine to use between all the options we have today is...