Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Benchmarking Managed PostgreSQL Cloud Solutions - Part Four: Microsoft Azure

The last in our four part series “Benchmarking Managed PostgreSQL Cloud Solution” this blog takes a close (and somewhat painful) look at Microsoft Azure and benchmark it for PostgreSQL using pgbench and sysbench.

Database-Aware Load Balancing: How to Migrate from HAProxy to ProxySQL

HAProxy is a great piece of software, but it may just not be enough for more demanding users and environments. How do you migrate from HAProxy to ProxySQL? This blog post explains the process and shows how ClusterControl can help.

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.

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.

MongoDB Schema Planning Tips

This blog describes the major factors to consider when performing MongoDB schema planning. You will learn tips and tricks on proper indexing, how to avoid joins and other.

MySQL Replication for High Availability - New Whitepaper

This whitepaper covers information about MySQL Replication, with information about the latest features introduced in 5.6, 5.7 and 8.0. There is also a more hands-on, practical section on how to quickly deploy and manage a replication setup using ClusterControl.

ClusterControl Tips & Tricks - Dealing with MySQL Long Running Queries

Long running queries are pretty much inevitable in MySQL or MariaDB, and unfortunately, they can lead to disastrous results. But why do queries take long time to execute? How do you deal with them?

This blog post shows how you can use ClusterControl to easily detect them, especially in environments with many database instances.

Understanding the Effects of High Latency in High Availability MySQL and MariaDB Solutions

To insulate our database infrastructure from failures, we build redundant cluster systems. For instance, MySQL and MariaDB high availability can be implemented by master-slave as well as master-master replication solutions. There are a number of variables that affect our choice solution. In this blog, we will look into considerations around latency.

Understanding MongoDB Indexes

MongoDB uses multikey indexes to index the content stored in arrays. If you index a field that holds an array value, MongoDB creates separate index entries for every element of the array. This blog explores the different types of indexes and reviews some things you should consider when setting up one.

Pages