Severalnines Blog
The automation and management blog for open source databases

Planets9s - 2016’s most popular s9s resources

Posted in:

Welcome to this week’s Planets9s, which is also the last edition of 2016!

Throughout the year, we’ve covered here all of the latest resources and technologies we create around automation and management of open source database infrastructures for MySQL, MongoDB and PostgreSQL. Thank you for following us and for your feedback on these resources. We look forward to continuing to interact with you all in 2017 and will strive to publish more information that’s helpful and useful in the new year.

But for now, and in no particular order, here are this year’s top 9 most popular s9s resources:

MySQL on Docker blog series - Part 1

In the first blog post of this series, we cover some basics around running MySQL in a container. The term ‘Docker’ as the container platform is used throughout the series, which also covers topics such as Docker Swarm Mode and Multi-Host Networking and more.

Read the blog(s)

MySQL Load Balancing with HAProxy - Tutorial

This tutorial walks you through how to deploy, configure and manage MySQL load balancing with HAProxy using ClusterControl.

Read the tutorial

MySQL Replication for High Availability - Tutorial

Learn about a smarter Replication setup that uses a combination of advanced replication techniques including mixed binary replication logging, auto-increment offset seeding, semi-sync replication, automatic fail-over/resynchronization and one-click addition of read slaves.

Read the tutorial

The Holy Grail Webinar: Become a MySQL DBA - Database Performance Tuning

Our most popular webinar this year discusses some of the settings that are most often tweaked and which can bring you significant improvement in the performance of your MySQL database. Performance tuning is not easy, but you can go a surprisingly long way with a few basic guidelines.

Watch the replay

Become a ClusterControl DBA - Blog Series

Follow our colleague Art van Scheppingen, Senior Support Engineer, as he covers all the basic operations of ClusterControl for MySQL, MongoDB & PostgreSQL with examples on how to do this and make most of your setup, including a deep dive per subject to save you time.

Read the series

Top 9 Tips for building a stable MySQL Replication environment - Webinar Replay

Get all the tips & tricks needed to build a stable environment using MySQL replication, as shared by Krzysztof Ksiazek, Senior Support Engineer at Severalnines.

Watch the replay

Top 9 DevOps Tips for Going in Production with Galera Cluster for MySQL / MariaDB

Galera Cluster for MySQL / MariaDB is easy to deploy, but how does it behave under real workload, scale, and during long term operation? Find out more with this popular webinar.

Watch the replay

Migrating to MySQL 5.7 - The Database Upgrade Guide

In this whitepaper, we look at the important new changes in MySQL 5.7 and show you how to plan the test process and do a live system upgrade without downtime. For those who want to avoid connection failures during slave restarts and switchover, this document goes even further and shows you how to leverage ProxySQL to achieve a graceful upgrade process.

Download the whitepaper

Become a MongoDB DBA - Blog Series

If you are a MySQL DBA you may ask yourself: “why would I install MongoDB”? This blog series provides you an excellent starting point to get yourself prepared for MongoDB. From deployment, monitoring & trending, through to scale reading and sharding, we’ve got you covered.

Read the series

As always, feel free to share these resources with your colleagues and follow us in our social media channels.

And that’s it for this year! Here’s to happy clustering in 2017!

“See” you all then,

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

Related Post

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:

Automating MySQL Replication with ClusterControl 1.4.0 - what’s new

This blog post will go through new replication features in ClusterControl 1.4.0, including enhanced multi-master deployment, managing replication topology changes, automated failover and handling of replication errors.

Posted in: