Severalnines Blog
The automation and management blog for open source databases

Planets9s - Sign up for our webinar trilogy on MySQL Query Tuning

Severalnines
Posted in:

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

Sign up for our webinar trilogy on MySQL Query Tuning

This is a new webinar trilogy on MySQL Query Tuning, which follows the popular webinar on MySQL database performance tuning. In this trilogy, we will 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. This is a proper deep-dive into optimising MySQL queries, which we’re covering in three parts.

Sign up for the webinars

ClusterControl Developer Studio: MongoDB Replication Lag Advisor

This blog post explains, step by step, how we implemented our MongoDB replication lag advisor in our Developer Studio. We have included this advisor in ClusterControl 1.3.2, and enabled it by default on any MongoDB cluster or replica set. ClusterControl Developer Studio allows you to write your own scripts, advisors and alerts. With just a few lines of code, you can already automate your clusters. Happy clustering!

Read the blog

MySQL on Docker: Single Host Networking for MySQL Containers

Having covered the basics of running MySQL in a container and how to build a custom MySQL image in our previous MySQL on Docker posts, we are now going to cover the basics of how Docker handles single-host networking and how MySQL containers can leverage that. We’d love to hear your feedback, so feel free to comment on our blogs as well.

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

MongoDB Webinar - How to Secure MongoDB with ClusterControl

With authentication disabled by default in MongoDB, learning how to secure MongoDB becomes essential. In this webinar we will explain how you can improve your MongoDB security and demonstrate how this is automatically done by ClusterControl.

MySQL on Docker: Composing the Stack

Docker 1.13 introduces a long-awaited feature called Compose-file support. Compose-file defines everything about an application - services, databases, volumes, networks, and dependencies can all be defined in one place.  In this blog, we’ll show you how to use Compose-file to simplify the Docker deployment of MySQL containers.

Posted in:

How to deploy and manage MySQL multi-master replication setups with ClusterControl 1.4

MySQL replication, while simple and popular, may come in different shapes and flavors. Master slave or master master topologies can be configured to suit your environment.  ClusterControl 1.4 brings a list of enhancements to deploy and manage different types of MySQL replication setups. This blog outlines the different topologies that can be deployed, the merits of each topology, and shows how each can be managed in a live environment.

Posted in:

Automatic failover of MySQL Replication - New in ClusterControl 1.4

MySQL replication setups are inevitably related to failovers - what do you do when your master fails and your applications are not able to write to the database anymore? Automated failover is required if you need to quickly recover an environment to keep your database up 24x7. This blog post discusses this new replication feature recently introduced in ClusterControl 1.4.

Posted in: