Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
166 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.

Posted in:

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.

Posted in:

Database Security - MySQL Upgrade Instructions for Zero-day Exploit

This blog shows you how to upgrade your MySQL and MariaDB databases, in order to address CVE-2016-6662 - a publicly disclosed vulnerability in MySQL.

Posted in:

Sign up for our new webinar: 9 DevOps Tips for Going in Production with Galera Cluster for MySQL / MariaDB

In this webinar, we will guide you through 9 key tips to consider before taking Galera Cluster for MySQL / MariaDB into production.

Posted in:

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.

Posted in:

Sign up for Part 2 of the MySQL Query Tuning Webinar Trilogy: Indexing & EXPLAIN

EXPLAIN is one of the most powerful tools at your disposal for understanding and troubleshooting troublesome database queries, but many developers rarely make use of it. This is part 2 of our webinar trilogy on MySQL Query Tuning.

Posted in:

Become a MongoDB DBA: Recovering your Data

This is our sixth post in the “Become a MongoDB DBA” blog series - how do you recover MongoDB using a backup.

How to set up read-write split in Galera Cluster using ProxySQL

This blog shows you how to setup read-write split in Galera Cluster using ProxySQL. It also covers some limitations that we found at the time of writing.

Posted in:

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.

Posted in:

MySQL on Docker: Introduction to Docker Swarm Mode and Multi-Host Networking

This blog post covers the basics of managing MySQL containers on top of Docker swarm mode and overlay network.