Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Analytics with MariaDB AX - the Open Source Columnar Datastore

What is a columnar datastore? When is it a better fit over a relational datastore? In this blog post, we will take a look at MariaDB AX and how it fits in this landscape.

How to Backup and Restore ClusterControl

Migrating ClusterControl to new hardware used to be a pain - you had to reinstall it on the new server, restore configuration/metadata from the old one and redo database grants so the new server can access your managed databases. Not any more! Starting with 1.7.1, it is possible to backup the ClusterControl server in one command and restore it on a new server, with data, grants and all.  This blog shows you how to do this using the s9s CLI.

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.

What is MariaDB TX? How to Manage the New MariaDB MySQL Fork!

MariaDB TX is a subscription in which MariaDB combines multiple offerings building a fully-featured, transactional database. The database used in MariaDB TX is MariaDB Server 10.3, which also includes Galera Cluster for synchronous multi-master replication. For the proxy layer MariaDB TX uses MaxScale.

Deploying MongoDB Using Docker

This blog provides an introduction to deploying MongoDB using a Docker container. We will look at some important concepts like volume mapping and connecting to a MongoDB container from another container using links.

Using PostgreSQL Logical Replication to Maintain an Always Up-to-Date Read/Write TEST Server

This blog discusses logical replication in PostgreSQL: its use cases, general information on the status of this technology, and a special use case in particular on how to setup a subscriber (replica) node of the primary server in order to function as the database server for the testing environment, and the challenges met.

MySQL on Docker: Multiple Delayed Replication Slaves for Disaster Recovery with Low RTO

A delayed replication slave is useful in recovering from accidental data deletion. But how long should the delay be? Too short delay might not be enough for you to get to a terminal and stop an offending query. Too long delay means a long recovery time when catching up.

This blog post shows how to deploy multiple MySQL delayed slaves on one single physical host with Docker, and shows some of the recovery scenarios.

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.

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.

Migrating from MSSQL to PostgreSQL - What You Should Know

If you are considering moving from a MSSQL environment to PostgreSQL, this blog provides a high level overview of what you should know to migrate between the two.

Pages