Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Webinar: Become a MongoDB DBA - Scaling and Sharding

In this third webinar of the ‘Become a MongoDB DBA’ series, we will focus on scaling and sharding your MongoDB setup.

Posted in:

Completing the MySQL Query Tuning Trilogy: working with optimizer & SQL tuning

This webinar was the third and last part of our webinar trilogy on MySQL Query Tuning, in which we discussed query tuning and related tools. In this trilogy we’ve covered SQL tuning, indexing, the optimizer and how to leverage EXPLAIN to gain insight into execution plans. Part 3 focussed on working with the optimizer and SQL tuning.

Posted in:

Schema changes in Galera cluster for MySQL and MariaDB - how to avoid RSU locks

This post shows you how to avoid locking existing queries when performing rolling schema upgrades in Galera Cluster for MySQL and MariaDB.

Posted in:

Database Cluster Management - Manual vs Automation via ClusterControl

Database Cluster management tasks include restart/recovery of services that fail, topology changes, reconfiguration, rolling upgrades, backups and performing security procedures. Since the tasks usually involve multiple servers, these can be repetitive and error-prone. This blog looks at efficiency gains when using ClusterControl to manage a MySQL Galera cluster as compared to manual ways.

Posted in:

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.

Plenty of 9s on deck at Percona Live Amsterdam - Impressions

We took some time to share our immediate impressions of this year’s Percona Live Conference in Amsterdam. With live broadcast videos and pics to hand!

Posted in:

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.