Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Scaling Connections in PostgreSQL using Connection Pooling

This blog provides a high-level overview of connection pooling for PostgreSQL. Connection pooling has become one of the most common methods of handling database connections prior to a query request.

How to Encrypt Your MySQL & MariaDB Backups

Backup encryption is a must if you want to store backups offsite for disaster recovery. This post will describe ways in which you can encrypt your MySQL and MariaDB backups.

Linking & Creating MongoDB Joins Using SQL - Part 3

This blog series describes how to create and link MongoDB joins using an SQL database and Studio3T. This blog focuses on multiple joins and collections.

Five Cool Things I Learned at the PostgreSQL Conference Europe 2018

This blog provides some insights into the coolest things shared at the 2018 PostgreSQL Conference Europe.

Posted in:

Webinar Replay: Backup Management for MySQL, MariaDB, PostgreSQL & MongoDB with ClusterControl

Watch the replay of this webinar on Backup Management for MySQL, MariaDB, PostgreSQL and MongoDB with ClusterControl. Whether you are looking at rebuilding your existing backup infrastructure, or updating it, then this webinar is for you.

Database Security - Backup Encryption In-Transit & At-Rest

Backup Encryption in-transit and at-rest are important when complying with PHI, PII, PCI DSS, GDPR, and HIPAA. This blog discusses how you can use ClusterControl to safely secure your data during transmission over the network or when persistently stored on disk.

Percona Live Frankfurt 2018 - Event Recap & Our Sessions

Severalnines was a sponsor at 2018’s Percona Live Europe which was held in Frankfurt, Germany. This blog details our participation at the event and includes the slides from the sessions we presented.

Posted in:

Linking & Creating MongoDB Joins Using SQL - Part 2

This is part 2 of a blog series that describes how to create and link MongoDB joins using an SQL database and Studio3T.

Care To Know Clauses: All About SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, and LIMIT

In this blog post, we visit, at a high-level, the major SQL clauses as they apply to PostgreSQL. There are many dialects of SQL but PostgreSQL’'s interpretation is the focus in this blog.

Utilizing Encryption to Strengthen PostgreSQL Database Security

This blog provides an overview of encryption for PostgreSQL as part of some of the overall measures needed to establish database security and keep your data protected.