Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Scaling PostgreSQL for Large Amounts of Data

There are many approaches available to scale PostgreSQL depending on our environment and requirements. In this blog, we’ll see how we can do it, and how we can know if it’s needed in our system.

Database User Management: Managing Roles for MariaDB

Managing privileges on a database can be a hard and time-consuming task if we’re working in large organizations or if you have a complex privilege structure created on the database side. In this blog, we’ll see how we can cope with the database user management by using roles and how to use them on MariaDB.

Using the MyRocks Storage Engine with MariaDB Server

One of the advantages of MariaDB is to have options for different types of storage engines depending on our specific requirements. In this blog, we’ll see what the MyRocks storage engine is and how we can implement it with MariaDB.

How to Deploy MariaDB Server to a Docker Container

You're probably familiar with terms like Docker, Images or Containers, but not everyone knows what these technologies are and how to combine it with a database technology like MariaDB. In this blog, we’ll see an overview of these terms and how we can apply it to deploy a MariaDB server.

A Guide to Deploying TimescaleDB with Docker

While setting up a single instance of Timescale on a Docker container is a pretty straight-forward task, deploying a replication cluster to achieve high availability is not. Customizing something from the OS side, or choosing a different OS image altogether makes it even harder. In this blog, we’ll deploy TimescaleDB on Docker and discuss a way to make it easier to configure a replication with ClusterControl using a clean OS image.

Which Time-Series Database is Better: TimescaleDB vs InfluxDB

In the new time-series database world, TimescaleDB and InfluxDB are two popular options with fundamentally different architectures. One is based off a relational database, PostgreSQL, the other build as a NoSQL engine. In this blog, we’ll give you a short description of those two, and how they stack against each other.

How to Deploy PostgreSQL to a Docker Container Using ClusterControl

Deploying a single PostgreSQL instance on Docker is fairly easy, but deploying a replication cluster requires a bit more work. In this blog, we’ll see how to deploy PostgreSQL on Docker and how we can make it easier to configure a primary-standby replication setup with ClusterControl.

How to Use pgBackRest to Backup PostgreSQL and TimescaleDB

Managing backup environments can be complex, and, in case of failure, it’s important to reduce downtime and loss of data as much as possible. Full, differential and incremental backups are good options, they also help reduce the disk space usage. There are other important features like backup verification, uploading to remote systems or cloud, and compression, to complete our backup strategy. In this blog, we’ll see how we can use pgBackRest for backing up PostgreSQL and TimescaleDB and how we can manage all of these features from the same system.

An Overview of Streaming Replication for TimescaleDB

TimescaleDB uses a stream of write-ahead log (WAL) records to keep the standby databases synchronized. In this blog, we’ll review some concepts related to Streaming Replication and how ClusterControl can help us configure it in an easy way.

Backup Management Tips for TimescaleDB

Managing backup environments can be complex, and there are a number of options to consider - full, differential, incremental, point in time recovery, automatic restores for backup verification, uploading to remote systems or cloud, and so on. So how can we backup TimescaleDB? In this blog, we’ll see how ClusterControl can help us implement our backup management strategy for TimescaleDB.

Pages