Severalnines Blog
The automation and management blog for open source databases

Planets9s - Become a PostgreSQL and MongoDB DBA, New NinesControl & 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.

New blog series: Become a PostgreSQL DBA (if you’re really a MySQL DBA)

MySQL and PostgreSQL - two open source relational database management systems, each with their own set of use cases and users. You may be asking - why use both of these databases in one environment? Is there any value in having a replicated PostgreSQL setup running alongside a MySQL / MariaDB Galera cluster? In this blog post, which is the first in this new series, we try to answer these questions from the MySQL DBA standpoint and discuss different methods of deploying PostgreSQL.

Read the blog

Try the new NinesControl: deploy and monitor MySQL Galera clusters on Digital Ocean

This week we’re happy to announce the public availability of NinesControl (beta), our new database infrastructure management solution for the cloud. Designed with the needs of developers in mind, NinesControl enables users to easily deploy and monitor (MySQL) Galera clusters on DigitalOcean. Droplets are launched and managed using your own DigitalOcean account. We’d love to get your feedback on this new solution, so please do check it out and let us know what you think.

Try the new NinesControl

Become a MongoDB DBA: the basics of configuration

After covering the deployment of MongoDB in our previous blogpost in this series, we now move on to configuration basics. MongoDB is configured through both the config file (/etc/mongod.conf) and runtime. We discussed some of the configurables last month and now we go more in depth on each of them.

Read the blog

Sign up for our MySQL Database Performance Tuning webinar next week

There are still a few “seats” left for this popular new webinar on MySQL Database Performance Tuning, which takes place next Tuesday, June 14th. We’ll discuss some of the settings that can bring you significant improvement in the performance of your MySQL database as well as some of the variables which are frequently modified even though they should not. Performance tuning is not easy, but you can go a surprisingly long way with a few basic guidelines.

Sign up for the webinar

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: