Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Top PG Clustering HA Solutions for PostgreSQL

Achieving high availability and clustering in PostgreSQL is not an easy task. In this blog entry we discuss some options for implementing these and not collapsing in the process!

Updated: ClusterControl Tips & Tricks: MySQL Query Performance Tuning

In this blog post, we’ll look into how ClusterControl can help you solve problems related to query performance using the Query Monitor.

An Overview of Database Indexing in PostgreSQL

This blog provides a high-level overview of database indexing and how you can use it to improve database performance.

How to Benchmark PostgreSQL Performance

This blog covers what you need to know to benchmark your PostgreSQL database to achieve peak performance.

PostgreSQL Schema Management Basics

This blog goes over the PostgreSQL Schema Management Basics that you should know when running a PostgreSQL environment.

Several Ways to Intentionally Fail or Crash your MySQL Instances for Testing

This blog post features some ideas (with examples) on how to crash a MySQL server in a Linux environment.

Multiple Data Center Setups Using Galera Cluster for MySQL or MariaDB

Regardless of how redundant your database is, if everything is in a single data center, it might not be good enough. Losing network connectivity to the datacenter means your service will be unavailable. This blog provides insight into setting up Galera Cluster across multiple data centers.

Video: Database Troubleshooting Tips for DevOps

This video describes three database scenarios which a DevOps Team may face and how to resolve them using ClusterControl and ProxySQL.

Using the Galera Replication Window Advisor to Avoid SST

In Galera Cluster, the gcache provides incremental state transfers by sending transactions to joining nodes. But if the gcache file is too small, this may cause full state snapshot transfers. The Galera replication window advisor will continuously review if your gcache size is large enough.

MySQL Tutorial - Troubleshooting MySQL Replication Part 2

This blog post walks you through some issues you may experience when deploying and managing a MySQL Replication environment and how to resolve those issues.