Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

MySQL Query Tuning Trilogy: Working with optimizer and SQL tuning (3rd and final part)

This is the final part of our webinar trilogy on MySQL Query Tuning, in which we 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. Part 3: Working with the optimizer and SQL tuning.

Posted in:

9 DevOps Tips for going in production with MySQL / MariaDB Galera Cluster: webinar replay

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

Posted in:

We’ve signed up football video and data platform Wyscout used by Real Madrid, Arsenal, Juventus & many more

Today we announce Wyscout, the world’s leading company providing video, data and technology to football people all over the world, as our latest customer. We help manage the database where all of the player intelligence is stored in. The Wyscout platform is used by the world’s biggest clubs including, Arsenal, Juventus and Real Madrid.

Posted in:

ClusterControl Tips & Tricks - Custom graphs to monitor your MySQL, MariaDB, MongoDB and PostgreSQL systems

This blog post will show you how to add custom graphs to ClusterControl to monitor specific MySQL, MariaDB, MongoDB or PostgreSQL metrics.

MySQL on Docker: Multi-Host Networking for MySQL Containers (Part 2 - Calico)

This blog post covers the basics of deploying MySQL containers with Project Calico, a simple, pure layer 3 networking approach with no overlays for networking "workloads" such as VMs and containers.

Sharding MySQL with MySQL Fabric and ProxySQL

This blog post shows you how to set up a sharded MySQL setup based on MySQL Fabric and ProxySQL.

Posted in:

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: