Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

What’s New in ProxySQL 2.0

ProxySQL 2.0 has been released recently with quite a few interesting features, including causal reads, SSL for frontend connections and native support for Galera Cluster. In this blog post, we will explore these new features.

Benchmarking MongoDB - Driving NoSQL Performance

Database systems are crucial components in the cycle of any successful running application. Every organization involving them therefore has the mandate to ensure smooth performance of these DBMs through consistent monitoring and handling minor setbacks before they escalate into enormous complications that may result in an application downtime or slow performance. This blog shows you how you can ensure you achieve MongoDB system performance.

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.

Benchmarking Manual Database Deployments vs Automated Deployments

Good system administrators and devops hate performing mundane tasks and constantly look for ways at automating themselves out of the job. There are plenty of automation tools out there to help the cause. But if automation is a no brainer, why aren’t more people doing it? In this blog post we compare three ways of deploying a MySQL Galera cluster - manual, Ansible playbook and ClusterControl.

How to Perform a Failback Operation for MySQL Replication Setup

In case of master failure in a MySQL Replication setup, the most updated slave can be promoted to new master and all slaves repointed to the new master. But once the failed master has been fixed, what is the best way to re-introduce it as master, so as to restore the original topology.

This blog post shows how to perform the MySQL master failback operation.

Benchmarking Managed PostgreSQL Cloud Solutions - Part Three: Google Cloud

This blog performance benchmarks Google Cloud SQL for PostgreSQL 9.6.10 using pgbench and sysbench.

Scaling Your Time-Series Database - How to Simply Scale TimescaleDB

How do you scale TimescaleDB? How do you convert a single TimescaleDB instance to cluster with no downtime? How does the application know which database node to access? This blog post provides an overview of how to use ClusterControl to scale your time-series data with minimal effort.

How to Easily Deploy TimescaleDB

TimescaleDB is based on PostgreSQL, and therefore, supports streaming replication as the primary method of replication. However, PostgreSQL does not come with automatic failover. This can be a problem in a high availability production environment, as manual failover implies prolonged downtime.

The good news is that failover in TimescaleDB can be completely automated in ClusterControl 1.7.2. This blog shows us how to deploy such a setup.

Monitoring & Ops Management of MySQL 8.0 with ClusterControl

MySQL 8.0 is a big step forward in terms of data consistency, developer features, performance and availability. MySQL 8.0 shortens the gap between proprietary databases and open source world, making the migration decision much easier to take.

But how can you manage it, along with other relational open source databases? In this blog post, we look at the challenges of operating a MySQL 8.0 database, and see how important tasks like monitoring, alerting, backups and failover can be handled in an automated way.

How to Deploy Open Source Databases - New Whitepaper

Choosing which DB engine to use between all the options we have today is not an easy task. An that is just the beginning. After deciding which engine to use, you need to learn about it and actually deploy it to play with it. In this whitepaper we’ll show you how to install, configure and secure some of the most popular open source DB engines.