Severalnines Blog
The automation and management blog for open source databases

Planets9s - The complete MySQL Query Tuning Trilogy, scaling & sharding MongoDB and more!

Severalnines
October 28, 2016
Posted in: DB Ops Devops Planets9s

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.

Watch Part 3 of the MySQL Query Tuning Trilogy: working with optimizer and SQL tuning

This week we completed our popular webinar trilogy on MySQL Query Tuning and the three parts are now available for you to watch online. Part 3 this Tuesday focussed on working with the optimizer and SQL tuning. In this session, Krzysztof Książek, Senior Support Engineer at Severalnines, discussed how execution plans are calculated. He also took a closer look at InnoDB statistics, how to hint the optimizer and finally, how to optimize SQL. Watch this last session or indeed all three parts by following the link below.

Watch replays

Sign up for our new webinar on scaling & sharding MongoDB

Join us for our third ‘How to become a MongoDB DBA’ webinar on Tuesday, November 15th, during which we will uncover the secrets and caveats of MongoDB scaling and sharding. Learn with this webinar how to plan your scaling strategy up front and how to prevent ending up with unusable secondary nodes and shards. We’ll also show you how to leverage ClusterControl’s MongoDB scaling and shard management capabilities.

Sign up for the webinar

ClusterControl Developer Studio: Custom database alerts by combining metrics

Following our introduction blogs to the ClusterControl Developer Studio and the ClusterControl Domain Specific Language, we now look at our MongoDB replication window advisor. It was recently added to the Advisors Github repository. Our advisor will not only check on the length of the replication window, but also calculate the lag of its secondaries and warn us if the node would be in any risk of danger. All advisors are open source on Github, so anyone can contribute back to the community!

Read the blog

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

This blog discusses the Rolling Schema Upgrade as the only feasible method to execute schema changes where pt-online-schema-change failed or is not feasible to use. We check how this behaves in real life, in two scenarios. First, we have a single connection to the Galera cluster. We don’t scale out reads, we just use Galera as a way to improve availability of our application. We will simulate it by running a sysbench workload on one of the Galera cluster nodes. We are also going to execute RSU on this node. Check out the blog for the full discussion.

Read the blog

That’s it for this week! Feel free to share these resources with your colleagues and follow us in our social media channels.

Have a good end of the week,

Jean-Jérôme Schmidt
Planets9s Editor
Severalnines AB

Related Post

Planets9s - Eurofunk replaces Oracle with feature-rich Severalnines ClusterControl

Severalnines
December 02, 2016

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: DB Ops Devops Planets9s

How to build a stable MySQL Replication environment

Severalnines
November 29, 2016

During this webinar, participants will learn how to build a production-ready environment with MySQL replication. From OS and DB configuration checklists to schema changes and disaster recovery, they’ll have the information needed to plan and prepare the best setup for their requirements.

Posted in: DB Ops Events

Planets9s - Top 9 Tips for MySQL Replication, MongoDB Sharding & NinesControl

Severalnines
November 25, 2016

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: DB Ops Devops Planets9s

Become a MongoDB DBA: Sharding ins- and outs - part 2

Art van Scheppingen
November 23, 2016

In our previous post, we showed you how to shard your MongoDB databases and covered the theory behind it. But you are not done yet. How do you monitor the shards to make sure they are performing, and that data is distributed evenly between your shards? And how do you consistently backup your data across shards? This is our ninth post in the “Become a MongoDB DBA” blog series.