Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Become a MongoDB DBA: Monitoring and Trending (part 2)

This is our fourth post in the “Become a MongoDB DBA” blog series. It will give a deep dive in monitoring MongoDB: which metrics should you pay attention to, and why?

Become a MongoDB DBA: Monitoring and Trending (part 1)

This is our third post in the “Become a MongoDB DBA” blog series. It will give a primer in monitoring MongoDB: how to ship metrics using free open source tools.

High Availability Log Processing with Graylog, MongoDB and ElasticSearch

This blog post discusses how to deploy a Graylog cluster, with a MongoDB Replica Set deployed using ClusterControl.

Automate your Database with CCBot: ClusterControl Hubot integration

This post describes how to automate your database with CCBot. integrate ClusterControl with your ChatOps infrastructure via Hubot. We will go through the steps.

Integrating ClusterControl Alarms with Splunk

This blog shows how to integrate ClusterControl with a Log Management Tool like Splunk.

Syslog Plugin for ClusterControl

This blog shows how to install and configure ClusterControl’s syslog plugin to forward alarms to the syslog facilities.

Become a MySQL DBA blog series - 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.

Become a MySQL DBA blog series - Galera Cluster diagnostic logs

In a Galera cluster, whether you use MariaDB Cluster, Percona XtraDB Cluster or the Codership build, the MySQL error log is even more important. It gives you the same information as MySQL would, but you’ll also find in it information about Galera internals and replication. This data is crucial to understand the state of your cluster and to identify any issues which may impact the cluster’s ability to operate. In this post, we’ll try to make the Galera error log easier to understand.

Become a MySQL DBA blog series - 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.

Become a MySQL DBA blog series - Deep Dive SQL Workload Analysis using pt-query-digest

In our previous post, we showed you how to interpret reports generated by pt-query-digest. Today we’d like to cover some of its more advanced features, as it is a pretty extensive tool with lots of functionality. We’ll also show you what information you should be looking for, and how to derive conclusions based on that data.