Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
21 blog posts in 1 category

Performing a Live Upgrade to MySQL 5.7

Once we’ve tested that our application works with MySQL 5.7, what is the best way to introduce 5.7 in our live environment? How can we minimize risks? What tools can help facilitate the process?

Posted in:

What to test before upgrading to MySQL 5.7

With the behaviour of some existing features changing in MySQL 5.7, how do you ensure an upgrade will not adversely affect your applications? This blog post looks at how to prepare and perform regression tests.

Posted in:

Understand what has changed between MySQL 5.6 and 5.7 before upgrading

With MySQL 5.7, new features have been added and some existing behaviors have been altered. This may cause potential issues with your database setup if you neglect proper research and testing - new behavior may not be compatible with your application. Find what needs to be checked before you start planning upgrade to MySQL 5.7.

Posted in:

Webinar Replay & Slides: How to Upgrade to MySQL 5.7

This is the replay of a live webinar on MySQL 5.7 and how to upgrade to it. It covers the important changes between versions 5.6 and 5.7, how to prepare your application, and how an actual upgrade may look like.

Webinar replay & slides for MySQL DBAs: performing live database upgrades in replication & Galera setups

Thanks to everyone who joined us for our recent live webinar on performing live database upgrades for MySQL Replication & Galera, led by Krzysztof Książek. The replay and slides to the webinar are now available to watch and read online. During this live webinar, Krzysztof covered one of the most basic, but essential tasks of the DBA: minor and major database upgrades in production environments.

Howto: Online Upgrade of MariaDB Galera Cluster 5.5 to MariaDB 10

In this blog post, we’ll look into how to perform an online upgrade to MariaDB Galera Cluster 10. At the time of writing, MariaDB 10.1 was still in beta so the instructions in this blog are applicable to MariaDB 10.0. If you are running the Codership build of Galera (Galera Cluster for MySQL), you might be interested in the online upgrade to MySQL 5.6 instead.

Posted in:

Howto: Online Upgrade of Galera Cluster to MySQL 5.6

Okay, this is a major upgrade so there are risks! Therefore, an upgrade must be carefully plan and tested. In this blog post, we’ll look into how to perform an online upgrade of your Galera Cluster (the Codership build of Galera) to MySQL 5.6. 

Posted in:

Become a MySQL DBA blog series - Database upgrades

In this blog post, we will cover one of the most basic tasks of the DBA - minor and major database upgrades. This is the sixth installment in the ‘Become a MySQL DBA’ blog series. Our previous posts in the DBA series include Replication Topology Changes, Schema Changes, High Availability, Backup & Restore, Monitoring & Trending.

HowTo: Offline Upgrade of Galera Cluster to MySQL 5.6 or MariaDB 10

MySQL 5.6 has an extensive list of new features and changes, so upgrading from a previous version can be risky if not tested extensively. For this reason, we recommend our users to read and understand the changes before doing the upgrade. If you are on older MySQL versions, it is probably time to think about upgrading. MySQL 5.6 was released in February 2013, that’s almost two years ago!

Posted in:

Online Schema Upgrade in MySQL Galera Cluster using TOI Method

As a follow-up to the Webinar on Zero Downtime Schema Changes in Galera Cluster, we’ll now walk you through the detailed steps on how to update your schema. The two methods (TOI and RSU) have both their pros and cons, and given parameters like table size, indexes, key_buffer_size, disk speed, etc., it is possible to estimate the time taken for the schema to be upgraded.

Posted in: