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

Become a MongoDB DBA: MongoDB Sharding Ins & Outs - Part 1

This is our eighth post in the “Become a MongoDB DBA” blog series: how to scale writes with MongoDB.

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:

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:

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.

Become a MongoDB DBA: How to scale reads

This is our seventh post in the “Become a MongoDB DBA” blog series - how do you scale reads with MongoDB.

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: