This is the second part of the blog “A Guide to Pgpool for PostgreSQL”. The first part covering load balancing, session pooling, in memory cache and installation can be found here. Many users look towards...

PostgreSQL is world’s most advanced and preferred open source RDBMS for many start-ups, mobile applications and developers. The traditional way to set up, operate and scale PostgreSQL is time consuming and requires expertise in database...

Distributed databases or clusters typically consist of multiple node and nodes types, and it is not always easy to understand how all these hang together. For instance, one could have a replication setup with intermediate...

Today we are excited to announce the 1.6 release of ClusterControl - the all-inclusive database management system that lets you easily deploy, monitor, manage and scale highly available open source databases - and load balancers...

What is Slony? Slony-I (referred to as just ‘Slony’ from here on out) is a third-party replication system for PostgreSQL that dates back to before version 8.0, making it one of the older options for...

What is ETL? ETL refers to Extract, Transform and Load, it is a 3 step process applied to extract the data from various sources (which can exist in various forms), cleanse, and load in to...

Pgpool is less actual today, than it used to be 10 years ago, when it was the default part of a production PostgreSQL set up. Often when somebody was talking about PostgreSQL cluster, they were...

PostgreSQL has the reputation of being rock solid from its beginnings, and over the years has accumulated a set of impressive features. However the peace of mind that your on-disk data is ACID compliant —...

Severalnines is excited to announce its newest customer Verisec AB, an international IT security company on the cutting edge of digital security, creating solutions that make systems secure and easily accessible for industries like banking,...

Going into production is a very important task that must be carefully thought and planned beforehand. Some not so good decisions may be easily corrected afterwards, but some others not. So it is always better...

Databases, tables, normalization, and a solid backup plan allow us to store and maintain data. Those combined best practices, in turn, afford us interaction with that data. In today's data-driven world, data is valuable. Not...

We’re happy to announce that our latest technical whitepaper on how to design highly available open source database environments is now available to download. Written back our colleague Krzysztof Książek, Senior Support Engineer at Severalnines,...