Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
Answer
Close
Polls
How are you currently backing up your data?
Submit
Custom backup scripts scheduled with CRON
ClusterControl
On-prem DB backup tool
Storage snapshot backup
Online backup service
Other
Thank you for submiting your answer!
Please select another item to change your answer.
Results so far (Total Voters: 32):
  • Custom backup scripts scheduled with CRON (44%, 14 Votes)

  • ClusterControl (0%, 0 Votes)

  • On-prem DB backup tool (16%, 5 Votes)

  • Storage snapshot backup (19%, 6 Votes)

  • Online backup service (9%, 3 Votes)

  • Other (13%, 4 Votes)

125 blog posts in 1 category

Watch the replay: MySQL Query Tuning Part 2 - Indexing and EXPLAIN

This is the replay of Part 2 of our webinar trilogy on MySQL Query Tuning. This session covered Indexing and EXPLAIN, one of the most important tools in the DBA’s arsenal.

Two Database Sharding Tools for MySQL

This blog post will introduce you to three different tools which are designed to help users shard their MySQL databases.

Database Sharding - How does it work?

Why do we shard? How does sharding work? What are the different ways to shard a database? This post goes through some of the theory behind sharding.

MySQL Query Tuning: Process & Tools - View the Replay & Slides

These are the replay details of the first part of our webinar trilogy on MySQL Query Tuning. In this session we discussed the process and tools required to tune MySQL queries.

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.