Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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 ClusterControl DBA: Managing your logfiles

Learn about where to find the various system and database log files for MySQL, MongoDB & PostgreSQL and learn how to identify and resolve issues using ClusterControl’s log functionalities.

Become a MySQL DBA blog series - Troubleshooting with pt-stalk

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

Press Release: Severalnines adds silver lining to database management for CloudStats.me

Cloud-based server monitoring platform moves from MySQL to MariaDB with ClusterControl

Posted in:

Severalnines breaks records on MySQL, PostgreSQL and MongoDB

Severalnines, a database automation pioneer which helps businesses deploy and manage open source databases in any environment, closes 2015 on a high with new customer wins and new hires. Severalnines is entirely self-funded, having taken no external capital, allowing its product team to focus solely on solving pressing customer and community user needs.

Posted in:

Webinar replay & slides for MySQL DBAs: performing live database upgrades in replication & Galera setups

Thanks to everyone who joined us for our recent live webinar on performing live database upgrades for MySQL Replication & Galera, led by Krzysztof Książek. The replay and slides to the webinar are now available to watch and read online. During this live webinar, Krzysztof covered one of the most basic, but essential tasks of the DBA: minor and major database upgrades in production environments.

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

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

ClusterControl Tips & Tricks for MySQL: Max Open Files

You have created a large database with thousands of tables (> 5000 in MySQL 5.6). Then you want to create a backup using xtrabackup. Or, if it is a Galera cluster, you have to recover a galera node using wsrep_sst_method=xtrabackup[-v2].

nginx as Database Load Balancer for MySQL or MariaDB Galera Cluster

Nginx is well-known for its ability to act as a reverse-proxy with small memory footprint. It usually sits in the front-end web tier to redirect connections to available backend services, provided these passed some health checks. Using a reverse-proxy is common when you are running a critical application or service that requires high availability. It also distributes the load equally among the backend services.