Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Optimize Performance of ClusterControl and Its Components

This blog post explains a number of ways to improve performance of ClusterControl and its components.

Announcing ClusterControl 1.7.1: Support for PostgreSQL 11 and MongoDB 4.0, Enhanced Monitoring

This blog provides an overview of the next iteration of the agent-based monitoring features for MySQL, Galera Cluster, PostgreSQL and ProxySQL in ClusterControl with its 1.7.1 release, support for PostgreSQL 11 and MongoDB 4.0, as well as a whole range of new monitoring and backup management features for PostgreSQL … and more.

MySQL Performance Cheat Sheet

You would be surprised by the number of MySQL installations running default configurations, regardless of the workload. However, what works well for a read-intensive workload might not work as well for a write-intensive one. Configuration parameters also need to take into account the underlying hardware. This cheat sheet provides some quick tips on how to tune some of the key MySQL variables in order to improve performance.

An Overview of Just-in-Time Compilation (JIT) for PostgreSQL

Just-in-Time (JIT) compilation is the process of turning some form of interpreted program evaluation into a native program, and doing so at runtime. This blog shows hows to use this with PostgreSQL, which has built-in support to perform JIT compilation using LLVM when PostgreSQL is built with --with-llvm.

Database High Availability Comparison - MySQL / MariaDB Replication vs Oracle Data Guard

This blog compares MySQL replication vs Oracle Data Guard solution for High Availability.

How to Improve Replication Performance in a MySQL or MariaDB Galera Cluster

Can we increase Galera performance if we speed up applying data that is replicated between its nodes? In this blog post, we assess the impact of having multiple wsrep_slave_threads on the overall performance of Galera cluster.

MySQL & MariaDB Query Caching with ProxySQL & ClusterControl

A query cache can greatly improve database performance, and there are various types of mechanisms available - from the inbuilt MySQL query cache to external key value stores like memcached or Redis. In this blog, we’ll show you how to cache your queries via ProxySQL, and avoid the overhead of an additional dedicated caching layer.

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.

Effective Monitoring of MySQL With SCUMM Dashboards - Part 3

In this 3rd part of the blog series, we’ll discuss what ClusterControl’s new InnoDB Metrics and MySQL Performance dashboards have to offer. These dashboards provide a pretty in-depth view of MySQL performance. We’ll go through the different graphs, and see how a DBA can leverage them.

MySQL on Docker: Running ProxySQL as Kubernetes Service

When your application containers are orchestrated and managed by Kubernetes, you might want to use ProxySQL in front of your database servers. In this post, we’ll show you how to configure ProxySQL as a Kubernetes service.