Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

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.

How to Cluster Odoo 12 with PostgreSQL Streaming Replication for High Availability

Automating all your business processes with Odoo puts stringent requirements on the availability of the platform. What do you do if a server fails? In this blog post, we’ll show you how to cluster Odoo to achieve better availability and scalability on multiple servers. The softwares used are Odoo 12, HAProxy 1.8.8, Keepalived 1.3.9, PostgreSQL 11 and OCFS2 (Oracle Cluster File System).

Basic Administration Comparison Between Oracle, MSSQL, MySQL, PostgreSQL

Supporting different types of databases in a mixed environment is not an easy task. In this blog post we will compare different types of RDBMS systems from the DBA/DevOps administration perspective.

An Overview of the Index Changes in PostgreSQL 11

PostgreSQL 11 introduced several changes to the way it handles database indexes. In this blog, we provide an overview of these changes and how you can take advantage of them.

How to Manage Your PostgreSQL Databases from the ClusterControl CLI

What if you could deploy a 3-node streaming replication setup in one command? Or orchestrate a master failover with reslaving of nodes in one command? Welcome to ClusterControl’s command line interface to manage your PostgreSQL setups. This blog post shows you how to manage your PostgreSQL streaming replication cluster using s9s, the ClusterControl CLI.

Deploying and Managing PostgreSQL 11: New in ClusterControl 1.7.1

A few days ago was the release of a new version of ClusterControl, the 1.7.1, with several new features, including for PostgreSQL. In this blog, we will see how to deploy PostgreSQL 11 version using ClusterControl. We’ll also check out the new backup verification feature that you can use to automatically test your backups.

Announcing ClusterControl 1.7.1: Support for PostgreSQL 11 and MongoDB 4.0, Enhanced Monitoring

This blog provides an overview of the next iteration of the agent-based monitoring features for MySQL, Galera Cluster, PostgreSQL and ProxySQL in ClusterControl with its 1.7.1 release, support for PostgreSQL 11 and MongoDB 4.0, as well as a whole range of new monitoring and backup management features for PostgreSQL … and more.

An Overview of Just-in-Time Compilation (JIT) for PostgreSQL

Just-in-Time (JIT) compilation is the process of turning some form of interpreted program evaluation into a native program, and doing so at runtime. This blog shows hows to use this with PostgreSQL, which has built-in support to perform JIT compilation using LLVM when PostgreSQL is built with --with-llvm.

Pages