Severalnines Blog
The automation and management blog for open source databases

Planets9s - Top 9 Tips for MySQL Replication, MongoDB Sharding & NinesControl

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.

New webinar December 6th on Top 9 Tips to manage MySQL Replication

Join our new webinar during which Krzysztof Książek, Senior Support Engineer at Severalnines, will share his 9 Top Tips on how to build a production-ready MySQL Replication environment. From OS and DB configuration checklists to schema changes and disaster recovery,  you’ll have the 9 top tips needed for a production-ready replication setup.

Sign up for the webinar

Sign up for NinesControl for MySQL & MongoDB in the cloud

Built on the capabilities of ClusterControl, NinesControl is a database management cloud service, with no need to install anything. It enables developers and admins to uniformly and transparently deploy and manage polyglot databases on any cloud, with no vendor lock-in. If you haven’t tested NinesControl yet, do check it out - it’s free :-)

Try NinesControl

Become a MongoDB DBA: Sharding ins- and outs - part 2

Having recently discussed how to enable sharding on a MongoDB database and define the shard key on a collection, as well as explained the theory behind all this, we now focus on the monitoring and management aspects of sharding. Just like any database requires management, shards need to be looked after. Some of the monitoring and management aspects of sharding, like backups, are different than with ordinary MongoDB replicaSets. Also operations may lead to scaling or rebalancing the cluster. Find out more in this new blog post.

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: