Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Decoding the MongoDB Error Logs

This blog provides a high level introduction to the MongoDB error logs, where to find them and how to understand common issues.

How to Decode the PostgreSQL Error Logs

This blog provides the basic information you need to know to understand the PostgreSQL error logs and what to do when you find errors.

ClusterControl 1.5 Documentation - What’s New

Check out the latest updated resources of our documentation page.

Posted in:

HAProxy Connections vs MySQL Connections - What You Should Know

Max connections determines the maximum number of connections to the database server. This can be set on both the database server, or the proxy in front of it. In this blog post, we’ll dive into HAProxy and MySQL maximum connections variables, and see how to get the best of both worlds.

How to Stop or Throttle SST Operation on a Galera Cluster

A full node resync, or SST, can be a heavy, long-running operation that impacts the performance and stability of a Galera Cluster. This blog post explains a trick on how to stop an ongoing SST operation in a clean manner.

MySQL Troubleshooting with pt-stalk: Part 2

This post discusses the data collected by pt-stalk, and how to utilize it when troubleshooting problems with MySQL.

MySQL Troubleshooting with pt-stalk: Part 1

This post describes how to use pt-stalk, a tool that can help with data collection when troubleshooting problems with MySQL.

Troubleshooting Galera Cluster Issues: Part 2

This is part 2 of our blog on how to troubleshoot Galera cluster - SST errors, and problems with network streaming. In part 1 of the blog, we covered issues ranging from node crashes to clusters that won’t restart, network splits and inconsistent data. Note that the issues described are all examples inspired from real life incidents in production environments.

Troubleshooting Galera Cluster Issues: Part 1

In this blog post, we are going to show you some examples of things that can go wrong in Galera - inexplicable node crashes, network splits, clusters that won’t restart and inconsistent data. We’ll take a look at the data stored in log files to diagnose the problems, and discuss how we can deal with these.

Understanding the MySQL Error Log

We are yet to see a software that runs perfectly, without any issues. MySQL is no exception there. It’s not the software’s fault - we need to be clear about that. We use MySQL in different places, on different hardware and within different environments. It’s also highly configurable. All those features make it great product but they come with a price - sometimes some settings won’t work correctly under certain conditions.

Pages