Severalnines Blog
The automation and management blog for open source databases

Planets9s - #MySQLHA CrowdChat Launch, HA for PostgreSQL and Live Upgrades to MySQL 5.7

Severalnines
July 07, 2016
Posted in: DB Ops Devops Planets9s

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 the Conversation: Severalnines Launches #MySQLHA CrowdChat

This new CrowdChat is brought to you by Severalnines and is hosted by a community of subject matter experts. CrowdChat is a community platform that works across Facebook, Twitter, and LinkedIn to allow users to discuss a topic using a specific #hashtag. This crowdchat focuses on the hashtag #MySQLHA. So if you’re a DBA, architect, CTO, or a database novice, sign up and become part of the conversation!

Sign up for #MySQLHA CrowdChat

Become a PostgreSQL DBA - How to Setup Streaming Replication for High Availability

Historically, PostgreSQL did not have support for replication, which was provided using external tools like Pgpool and Slony. These solutions did not come out of the box and most of them required a good bit of work to set them up. This was a serious drawback, and it made people look into MySQL, where replication had been available for a long time. Thankfully, with PostgreSQL 9.0, replication has been added natively to PostgreSQL and this post shows you how to set up streaming replication.

Read the blog

Performing a Live Upgrade to MySQL 5.7

After studying the differences between MySQL 5.6 and 5.7, and going through a vigorous regression test process in our two previous posts on this topic, it’s now time for perform the actual upgrade itself. How do we best introduce 5.7 in our live environment? How can we minimize risks? What do we do if something goes wrong? And what tools are available out there to assist us? This latest post provides answers to these questions as well as a link to the related whitepaper on how to upgrade to MySQL 5.7.

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

Planets9s - Eurofunk replaces Oracle with feature-rich Severalnines ClusterControl

Severalnines
December 02, 2016

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: DB Ops Devops Planets9s

How to build a stable MySQL Replication environment

Severalnines
November 29, 2016

During this webinar, participants will learn how to build a production-ready environment with MySQL replication. From OS and DB configuration checklists to schema changes and disaster recovery, they’ll have the information needed to plan and prepare the best setup for their requirements.

Posted in: DB Ops Events

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

Severalnines
November 25, 2016

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: DB Ops Devops Planets9s

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

Art van Scheppingen
November 23, 2016

In our previous post, we showed you how to shard your MongoDB databases and covered the theory behind it. But you are not done yet. How do you monitor the shards to make sure they are performing, and that data is distributed evenly between your shards? And how do you consistently backup your data across shards? This is our ninth post in the “Become a MongoDB DBA” blog series.