Introduction to the Severalnines ClusterControl API and SDK – Part I
This is Part I of a multi-part Several9s blog series on how to use Severalnines' ClusterControl REST API client SDK to programmatically control ClusterControl in order to accomplish many facets of database life cycle management...
Upgrading PostgreSQL 11 to PostgreSQL 13 with TimescaleDB and PostGIS in Linux using pg_upgrade
Businesses and enterprises using old versions of PostgreSQL (PG) face challenges when upgrading to at least the most recent stable version from PostgreSQL 12 or PostgreSQL 13. There are many reasons why upgrading to the...
PostgreSQL and TimescaleDB backup restoration using ClusterControl CLI
Data is probably the most valuable asset in a company, so you need to make sure it is safe and can be restored in case of failure. Backups are the basic way to keep it...
ClusterControl – Advanced Backup Management – PostgreSQL
Information is one of the most valuable assets in a company, so you will need a good Disaster Recovery Plan (DRP) to prevent data loss in the event of an accident or hardware failure. Backups...
ClusterControl runtime configuration options
When you install ClusterControl, it has a default configuration that maybe doesn’t fit your requirements so probably you will need to customize this installation. For this, you can modify the configuration files, but you can...
How to configure AppArmor for PostgreSQL and TimescaleDB
Security is a must for all systems to protect your data as much as possible. Even when there is always a risk to be hacked, by following a security checklist will reduce this risk significantly....
How to configure SELinux for PostgreSQL and TimescaleDB
Data is the most important asset in a company, so you should take all the security considerations into account in your database to keep it as safe as possible. One important security feature on RedHat-based...
Advanced Failover Using Post/pre Script Hooks
The Importance of Failover Failover is one of the most important database practices for database governance. It’s useful not only when managing large databases in production, but also if you want to be sure that...
Managing Multiple Database Technologies with ClusterControl
Managing multiple open source database technologies in any environment can be a daunting task, especially if you have fewer resources. The scenario could be worse if deployment, monitoring, and other database management tasks are done manually....
6 Critical Components of Successful Data Governance
Properly established data governance means that you can make faster and smarter decisions. It sounds simple, but it requires you to build a set of processes and a culture that respects certain key principles. If...
Integrating ClusterControl with SNMP : Part Two
This blog post is a continuation of the previous part 1, where we have covered the basics of SNMP integration with ClusterControl. In this blog post, we are going to focus on SNMP traps and...
Integrating ClusterControl with SNMP – A Proof of Concept : Part One
ClusterControl comes with a number of distinctive alerts (or alarms) which you won't find in other monitoring systems. ClusterControl understands a database cluster topology as a whole - all database nodes and the relation between...