Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
How are you currently backing up your data?
Custom backup scripts scheduled with CRON
On-prem DB backup tool
Storage snapshot backup
Online backup service
Thank you for submiting your answer!
Please select another item to change your answer.
Results so far (Total Voters: 32):
  • Custom backup scripts scheduled with CRON (44%, 14 Votes)

  • ClusterControl (0%, 0 Votes)

  • On-prem DB backup tool (16%, 5 Votes)

  • Storage snapshot backup (19%, 6 Votes)

  • Online backup service (9%, 3 Votes)

  • Other (13%, 4 Votes)

159 blog posts in 13 categories

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.

PostgreSQL High Availability with Master-Slave & Master-Master Architectures

Database servers can work together to allow a second server to take over quickly if the primary server fails (high availability), or to allow several computers to serve the same data (load balancing).

For HA PostgreSQL configurations we can have several architectures, but the basic ones would be master-slave and master-master architectures.

Top GUI Tools for PostgreSQL

Using a GUI is not a must, but it can be useful in some cases. In this blog, we'll see some advantages and warnings about the use of these tools, as well as do a short review of some of the most commons GUI tools for PostgreSQL.

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.

Webinar Replay: How to Automate & Manage PostgreSQL with ClusterControl

Watch the replay of our webinar on how to automate and manage PostgreSQL with ClusterControl. Sebastian Insausti, Support Engineer at Severalnines, will introduce us to the world of PostgreSQL ops automation: from the ‘old ways’ to the modern way of managing PostgreSQL; including a look at ClusterControl’s integrated approach to deployment, monitoring, performance management, scaling, upgrades and backup, delivered as an integrated suite that plugs into your favourite tools.

An Overview of JSON Capabilities Within PostgreSQL

This blog provides an overview of the JSON capabilities within PostgreSQL which were released in version 9.2.

One Security System for Application, Connection Pooling and PostgreSQL - The Case for LDAP

This blog describes how you can use LDAP for both authentication and connection pooling with your PostgreSQL database.

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.