How to Achieve PostgreSQL High Availability with pgBouncer
In the database world, there are many common concepts like High Availability, Failover, and Connection pooling. All of them are useful things to implement on any system, and even a must in some cases. A...
Driving Performance for PostgreSQL with HAProxy
Database performance is a very important concern when maintaining your database cluster, especially as it grows over the time. This is especially true if your application started out with low traffic going then growting to...
Building a Highly Available Database for Moodle Using PostgreSQL
Impacted by the COVID-19 pandemic, a lot of SMBs/SMEs are transitioning to online platforms. Face-to-face or physical classes are also affected by this pandemic and a lot of schools and universities are also transitioning to...
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...
Best DBaaS Solutions for PostgreSQL
Cloud computing is getting more and more used in all companies to take advantage of all the features offered by this technology. It allows for On-Demand availability of compute power, database, storage, applications, and other...
Video: Database Disaster Recovery with ClusterControl
This past week we debuted a series of videos on database disaster recovery. From basic backup and restore, to switchover & failover, to full cluster-to-cluster replication, these videos show how ClusterControl offers you end-to-end protection...
Press Release: Severalnines Cluster-to-Cluster Replication Provides Peace of Mind With Multi-Cloud Disaster Recovery
Organizations around the world were unprepared for COVID-19's impact. Severalnines helps companies stay prepared when crisis strikes with their end-to-end disaster recovery solutions. If the COVID-19 pandemic has shown us anything, it’s that it is...
Logical Replication Partitioning With PostgreSQL 13
Every PostgreSQL release comes with few major feature enhancements, but what is equally interesting is that every release improves upon its past features as well. As PostgreSQL 13 is scheduled to be released soon, it’s...
An Overview of Caching for PostgreSQL
Most OLTP workloads involve random disk I/O usage. Knowing that disks (including SSD) are slower in performance than using RAM, database systems use caching to increase performance. Caching is all about storing data in memory...
PostgreSQL Anonymization On Demand
Before, during, and after the GDPR came into town in 2018, there have been many ideas to solve the problem of deleting or hiding user data, using various layers of the software stack but also...
Multi-Cloud Full Database Cluster Failover Options for PostgreSQL
Failover is the ability of a system to continue working even if some failure occurs. It suggests that the functions of the system are assumed by secondary components if the primary components fail or if...
Eliminating PostgreSQL Split-Brain in Multi-Cloud Databases
Using a multi-cloud or multi-datacenter environment is useful for geo-distributed topologies or even for a disaster recovery plan, and actually, it is becoming more popular nowadays, therefore the concept of split-brain is also becoming more...