How to Easily Deploy TimescaleDB
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...
Announcing ClusterControl 1.7.2: Improved PostgreSQL Backup & Support for TimescaleDB & MySQL 8.0
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...
How to Deploy Open Source Databases
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...
An Introduction to TimescaleDB
TimescaleDB is an open-source database invented to make SQL scalable for time-series data. It’s a relatively new database system. TimescaleDB has been introduced to the market two years ago and reached version 1.0 in September...
How to Deploy Highly Available PostgreSQL with Single Endpoint for WordPress
WordPress is an open source software you can use to create your website, blog, or application. There are many designs and features/plugins to add to your WordPress installation. WordPress is a free software, however, there...
Benchmarking Managed PostgreSQL Cloud Solutions: Part Two – Amazon RDS
This is the second part of the multi-series Benchmarking Managed PostgreSQL Cloud Solutions. In Part 1 I presented an overview of the available tools, I discussed the reason for using the AWS Benchmark Procedure for...
Configuring PostgreSQL for Business Continuity
Business Continuity for Databases Business continuity for databases means databases must be continuously operational even during the disasters. It is imperative to ensure that production databases are available for the applications all the time even...
How to Replicate PostgreSQL Data to Remote Sites
In a busy database environment with larger size databases, the need for real-time data replication is a common occurrence. Applications often need the production data to be replicated in real-time to remote sites for analytics...
Benchmarking Managed PostgreSQL Cloud Solutions – Part One: Amazon Aurora
This blog starts a multi-series documenting my journey on benchmarking PostgreSQL in the cloud. The first part includes an overview of benchmarking tools, and kickstarts the fun with Amazon Aurora PostgreSQL. Selecting the PostgreSQL Cloud...
The Current State of Open Source Backup Management for PostgreSQL
There are many ways to address taking backups of a PostgreSQL cluster. There are several articles and blogs which present the various technologies by which we can save our precious data in PostgreSQL. There are...
Migrating from DB2 to PostgreSQL – What You Should Know
Whether migrating a database or an application from DB2 to PostgreSQL, there are few things to know about the differences between the two database systems. PostgreSQL is world’s most widely used advanced open-source database. PostgreSQL...
How to Cluster Odoo 12 with PostgreSQL Streaming Replication for High Availability
Odoo (formerly known as OpenERP) is a suite of open-source business apps. It comes in two versions - community and enterprise. Some of the most popular apps (and free!) integrated within this platform are Discuss,...