Severalnines Blog
The automation and management blog for open source databases

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

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.

Watch the replay: 9 DevOps Tips for going in production with MySQL / MariaDB Galera Cluster

You can now watch the replay of this week’s webinar, during which our CTO Johan Andersson walked us through his tips & tricks on important aspects to consider before going live with MySQL / MariaDB Galera Cluster. While it may be easy to deploy Galera Cluster, how it behaves under real workload, scale, and during long term operation is a slightly more complex matter. Find out about some key best practices around monitoring, managing schema changes and pushing them in production, performance optimizations, configurations, version upgrades and performing backups to be best prepared for going in production with Galera.

Watch the replay

We’ve signed up football video and data platform Wyscout used by Real Madrid, Arsenal, Juventus & many more!

This week we’re delighted to be joining in on the beautiful game thanks to our new customer Wyscout, the world’s leading company providing video, data and technology to football people all over the world. The Wyscout team use ClusterControl to manage the database where all of the player intelligence is stored in and their platform is used by the world’s biggest clubs including, Arsenal, Juventus and Real Madrid. Needless to say we’re excited to be part of Wyscout’s global football adventure!

Read the press release

ClusterControl Tips & Tricks - Custom graphs to monitor your MySQL, MariaDB, MongoDB and PostgreSQL systems

As all of you will likely know, graphs play an important part in database management, as they’re your window onto your monitored systems. ClusterControl comes with a predefined set of graphs for you to analyze, which are designed to give you, at first glance, as much information as possible about the state of your database cluster. And as you might have your own set of metrics you’d like to monitor, ClusterControl allows you to customize the graphs available in the cluster overview section. This blog shows you how to make best use of these graphs and of our customisation features.

Read the blog

Become a MongoDB DBA: How to scale reads

This new post in our ‘Become a MongoDB DBA’ blog series takes us into the realm of scaling MongoDB. MongoDB offers both read- and write scaling, and we will uncover the differences of these two strategies for you. Whether to choose read- or write scaling all depends on the workload of your application: if your application tends to read more often than it writes data you will probably want to make use of the read scaling capabilities of MongoDB. This blog walks you through MongoDB read scaling.

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

Online schema change with gh-ost - throttling and changing configuration at runtime

When performing schema changes online, it is important to be able to control the performance impact on our running databases. This blog post discusses gh-ost’s throttling mechanism. We will also cover the runtime configuration changes that gh-ost allows.

Posted in:

How to perform online schema changes on MySQL using gh-ost

This blog post shows you how to use GitHub’s gh-ost to perform an online schema change on a MySQL master-slave replication setup.

Posted in:

Planets9s - 2016’s most popular s9s resources

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:

How to Perform Efficient Backup for MySQL and MariaDB

There are a number of ways to backup MySQL and MariaDB, each comes with pros and cons. An effective backup strategy will depend on the requirements of the business, the environment you operate in, and the resources at your disposal.

Posted in: