Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

New Webinar Trilogy: The MySQL Query Tuning Deep-Dive

This is a new webinar trilogy on MySQL Query Tuning, which follows the popular webinar on MySQL database performance tuning. In this trilogy, we will look at query tuning process and tools to help with that. We’ll cover topics such as SQL tuning, indexing, the optimizer and how to leverage EXPLAIN to gain insight into execution plans.

The Holy Grail Webinar Replay: MySQL Database Performance Tuning

This is the replay of a webinar that discusses database performance tuning for MySQL databases.

How ProxySQL adds Failover and Query Control to your MySQL Replication Setup

An overview of ProxySQL in a MySQL replication environment, and how ProxySQL adds features like failover and query control to the setup.

MySQL Load Balancing with ProxySQL - an Overview

An overview of ProxySQL, an SQL-aware load balancer for MySQL and MariaDB. This blog post explains the concepts behind ProxySQL, and goes through installation and configuration.

Newly Updated “MySQL Load Balancing with HAProxy” Tutorial

We have recently updated our tutorial on MySQL Load Balancing with HAProxy.  Read about deployment and configuration, monitoring, ongoing maintenance, health check methods, read-write splitting, redundancy with VIP and Keepalived and more.

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.

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.

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.

Become a MySQL DBA blog series - Optimizer Hints for faster query execution

MySQL uses a cost-based optimizer to determine the best way to execute a query. It usually does a great job, but not all the time. There are different reasons for that. In some cases, it might not have enough information about the data and plan queries in a non-optimal way.