Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Integrating PostgreSQL with Authentication Systems

This blog provides an overview of popular authentication systems based on LDAP, Kerberos and RADIUS, and how to integrate them with your PostgreSQL database.

Top PostgreSQL Security Threats

This blog details some of the most recent security threats to PostgreSQL and some tips and resources to keep your data secure.

Setting up HTTPS on the ClusterControl Server

SSL is an important part of securing your ClusterControl installation. This blog post discusses HTTPS settings for ClusterControl and how to utilize them.

Updated: Become a ClusterControl DBA: Safeguarding your Data

So now that you have your databases up and running and highly available, how do you ensure that you have backups of your data? You can use backups for multiple things: disaster recovery, to provide production data to test against development or even to provision a slave node. This last case is already covered by ClusterControl. When you add a new (replica) node to your replication setup, ClusterControl will make a backup/snapshot of the master node and use it to build the replica. 

How to Achieve GDPR Compliance: Documenting Our Experience (II)

The journey to compliance continues with Severalnines & the European Union’s General Data Protection Regulation (GDPR).

PostgreSQL Privileges and Security - Locking Down the Public Schema

This blog details schema privileges and locking down the public schema for PostgreSQL.

How to Secure your PostgreSQL Database - 10 Tips

Security is not a game, it is a necessity! In this post we will discuss some common attacks against PostgreSQL server, and how to avoid them.

Updated: Become a ClusterControl DBA - SSL Key Management and Encryption of MySQL Data in Transit

In this blog post, we’ll show you how to generate self-signed certificates using ClusterControl, and encrypt all data traffic e.g. within a Galera Cluster and between MySQL databases and its clients.

PostgreSQL Privileges & User Management - What You Should Know

This blog demonstrates the basic PostgreSQL users and permissions.

Updated: Become a ClusterControl DBA: User Management

Learn how to delegate tasks and grant access to users and groups in ClusterControl by utilizing User Management.