Automated Testing of the Upgrade Process for MySQL/MariaDB/Percona Server
Upgrades are always a hard and time-consuming task. First, you should test your application in a test environment, so, ideally, you will need to clone your current production environment for this. Then, you need to...
Tips For Upgrading to the Latest MongoDB Version
The latest versions of MongoDB are built to integrate new or improved features from the predecessor versions. For this reason, it is recommended to run the latest version for maximum performance and additional features. Besides,...
Tips for Performing Database Maintenance with ClusterControl
Database Maintenance is a set of tasks that requires work on your database or set of database servers that involves improvement for its security, performance, optimization, upgrades, or even test such as benchmarking after changes...
Tips for Upgrading Percona Server for MongoDB
Percona Server for MongoDB is a MongoDB open source distribution powered by Percona. It is a free, fully compatible and drop in replacement for MongoDB Community edition. It also provides “enterprise grade” features that would...
Tips for Upgrading Percona XtraDB Cluster to 8.0
MySQL 8.0 has been available for a while and Percona XtraDB Cluster 8.0 has also been available for some time as well. Also, MySQL 5.6 is coming up to its End-of-Life and people using PXC...
How to Perform Rolling Upgrades for MySQL
There are different reasons for upgrading your databases. It could be to apply security fixes, to use new features, solve compatibility issues, or just to keep your system up-to-date. This upgrade can be a major...
How to Perform an Online Upgrade of Percona XtraDB Cluster to Percona XtraDB Cluster 8.0
Percona XtraDB Cluster based on MySQL 8.0 has been out there for some time, so it’s not surprising more and more people are attempting to migrate into it. You may wonder how to approach this...
How to Upgrade from MariaDB 10.4 to MariaDB 10.5
MariaDB 10.5 was released as GA in June 2020. In the release, there has been added support for Amazon S3 or any third-party public or private cloud that supports S3 API. It also features sophisticated...
How to Upgrade PostgreSQL 11 to PostgreSQL 12 with Zero Downtime
The most intuitive database upgrade way that you can think of is to generate a replica in a new version and perform a failover of the application into it, and actually it works perfectly in...
Tips for Upgrading to from MySQL 5.7 to MySQL 8
MySQL 8.0 has been with us already for quite some time and many MySQL users have already upgraded to this version. For those who are still using older MySQL versions, we would like to present...
Online Migration from MySQL 5.6 Non-GTID to MySQL 5.7 with GTID
In this blog post, we are going to look into how to perform online migration from MySQL 5.6 standalone setup to a new replication set running on MySQL 5.7, deployed and managed by ClusterControl. The...
How to Easy Manage Database Updates and Security Patches
Database security requires careful planning, but it is important to remember that security is not a state, it is a process. Once the database is in place, monitoring, alerting and reporting on changes are an...