Severalnines Blog
The automation and management blog for open source databases

Planets9s - Join us next Tuesday for part 1 of our MySQL Query Tuning Trilogy

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.

Join us next Tuesday for part 1 of our MySQL Query Tuning Trilogy

Remember to join us next Tuesday, August 30th for the first part of our upcoming webinar trilogy on MySQL Query Tuning. In this first webinar we will discuss building, collecting, analysing, tuning and testing processes as well as the main tools involved, tcpdump and pt-query-digest. If you haven’t done so yet, sign up below to join us and get your questions answered around MySQL query tuning.

Register for the webinar

Deploying ClusterControl and MySQL-based systems on AWS using Ansible

We recently made a number of enhancements to the ClusterControl Ansible Role, so it now also supports automatic deployment of MySQL-based systems (MySQL Replication, Galera Cluster, NDB Cluster). The updated role uses the awesome ClusterControl RPC interface to automate deployments. It is available at Ansible Galaxy and Github.

Read the blog

Become a MongoDB DBA: backing up your data

In this blog post we describe what tools are available for making backups in MongoDB and what strategies to use. In previous posts of our MongoDB DBA series, we have covered Deployment, Configuration and Monitoring. The next step now is ensuring your data gets backed up safely. Find out how in this latest installment of our Become a MongoDB DBA blog series.

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: