Severalnines Blog
The automation and management blog for open source databases

Planets9s - Become a MySQL DBA, Polyglot Persistence Meetups, MySQL Query Tuning 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.

Become a MySQL DBA at Percona Live this October

Whether you’re looking for monitoring and trending advice for your MySQL installation or how to diagnose issues with your MySQL setup; do backup and database upgrades; or tips and tricks for some of the common maintenance operations related to MySQL … This full-day tutorial, which we already held at Percona Live in Santa Clara last April, is now also on the tutorials schedule at Percona Live in Amsterdam this October. Do sign up for the conference, join us for this tutorial and ‘Become a MySQL DBA’!

Find out more

Sign up for our webinar on MySQL Query Tuning - Process & Tools

Join us for the first part of our upcoming webinar trilogy on MySQL Query Tuning led by Krzysztof Książek, Senior Support Engineer at Severalnines. This session focuses on the query tuning process and related tools. Building, collecting, analysing, tuning and testing will be discussed in detail as well as the main tools involved, tcpdump and pt-query-digest.

Sign up for the webinar

Join us at the Spotify & HQs for this month’s Polyglot Persistence Meetups

For this month’s Polyglot Persistence Meetups, we’re lucky enough to be hosted by Spotify in Stockholm on August 23rd and by in Amsterdam on August 31st. There’ll be interesting talks to listen to and discuss … as well as drinks and nibbles of course for some good chats. There are still seats available, so do feel free to sign up and join us there.

Sign up for the meetups

Become a MongoDB DBA: Backing up your data

Backups in MongoDB aren’t that different from MySQL backups.You have to start a copy process, ship the files to a safe place and ensure the backup is consistent. The consistency is obviously the biggest concern, as MongoDB doesn’t feature a transaction mode that allows you to create a consistent snapshot. Obviously there are other ways to ensure we make a consistent backup. In this blog post, we describe what tools are available for making backups in MongoDB and what strategies to use

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: