Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
44 blog posts in 13 categories

Benchmarking Managed PostgreSQL Cloud Solutions - Part Four: Microsoft Azure

The last in our four part series “Benchmarking Managed PostgreSQL Cloud Solution” this blog takes a close (and somewhat painful) look at Microsoft Azure and benchmark it for PostgreSQL using pgbench and sysbench.

How to Deploy PostgreSQL to a Docker Container Using ClusterControl

Deploying a single PostgreSQL instance on Docker is fairly easy, but deploying a replication cluster requires a bit more work. In this blog, we’ll see how to deploy PostgreSQL on Docker and how we can make it easier to configure a primary-standby replication setup with ClusterControl.

Benchmarking Managed PostgreSQL Cloud Solutions - Part Three: Google Cloud

This blog performance benchmarks Google Cloud SQL for PostgreSQL 9.6.10 using pgbench and sysbench.

How to Deploy Highly Available PostgreSQL with Single Endpoint for WordPress

In this blog, we will learn how to setup Postgres in high availability mode, with a single endpoint for your WordPress service. We’ll also see how ClusterControl can help us manage the failover processes across database and load balancers.

Benchmarking Managed PostgreSQL Cloud Solutions - Part Two: Amazon RDS

This is part 2 in the series where we put different cloud providers head-to-head to see which one stands out. This blog is about benchmarking Amazon RDS using pgbench and sysbench and then comparing it to Amazon Aurora.

Configuring PostgreSQL for Business Continuity

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 during the disasters, otherwise, could end-up being an expensive deal.

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 and other critical business operations needs. This blog provides an overview of several options you can use to replicate your PostgreSQL data to a remote site.

Benchmarking Managed PostgreSQL Cloud Solutions - Part One: Amazon Aurora

A multi-part series of articles on PostgreSQL benchmarking in the cloud. Part one is an overview of available benchmarking tools for PostgreSQL followed by testing Amazon Aurora PostgreSQL based on the Amazon Guide for Benchmarking PostgreSQL.

The Current State of Open Source Backup Management for PostgreSQL

This blog takes a deep-dive into the most popular open source backup programs available for PostgreSQL, what their current state is, and how they compare to one another.

Migrating from DB2 to PostgreSQL - What You Should Know

This blog provides a high level overview of what you should know if considering a move from IBM’s DB2 to PostgreSQL including a comparison of commands and an examination of the incompatibilities of the databases.

Pages