Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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:

Planets9s - Database Cluster Management, Optimizer & SQL Tuning, and more

Planets9s is a weekly communication on all the latest Severalnines resources and technologies around automation and management of open source databases such as MySQL, MariaDB, PostgreSQL & MongoDB.

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:

Planets9s - Joining the beautiful game with Wyscout, 9 DevOps Tips for Galera Cluster replay and more

Planets9s is a weekly communication on all the latest Severalnines resources and technologies around automation and management of open source databases such as MySQL, MariaDB, PostgreSQL & MongoDB.

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.

Planets9s - MySQL on Docker with Calico, Galera Cluster DevOps Tips, Percona Live and more

Planets9s is a weekly communication on all the latest Severalnines resources and technologies around automation and management of open source databases such as MySQL, MariaDB, PostgreSQL & MongoDB.

Posted in:

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: