Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
153 blog posts in 1 category

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.

Automate Deployment of your MySQL or Postgres Cluster from Backup

Restoring backups on newly deployed clusters can be time consuming. There are a number of procedures and checks to go through, and it is a task that lends itself to automation. This blog post shows you how to automate the entire process and deliver improvements in terms of speed, efficiency and cost.

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.