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...
Moving from MySQL 5.7 to MySQL 8.0 – What You Should Know
April 2018 is not just a date for the MySQL world. MySQL 8.0 was released there, and more than 1 year after, it’s probably time to consider migrating to this new version. MySQL 8.0 has...
How to Install ClusterControl to a Custom Location
ClusterControl consists of a number of components and one of the most important ones is the ClusterControl UI. This is the web application through which the user interacts with other backend ClusterControl components like controller,...
What's New in PostgreSQL 12
On October 3rd 2019 a new version of the world's most advanced open source database was released. PostgreSQL 12 is now available with notable improvements to query performance (particularly over larger data sets and overall...
Custom Trigger Based Upgrades for PostgreSQL
1st RULE: You do not upgrade PostgreSQL with trigger-based replication 2nd RULE: You DO NOT upgrade PostgreSQL with trigger-based replication 3rd RULE: If you upgrade PostgreSQL with trigger-based replication, prepare to suffer. And prepare well....
What to Test Before Upgrading to MySQL 5.7
As we saw in a previous post, there are some important changes between MySQL 5.6 and 5.7. Since the behaviour of some existing features been altered, some detailed testing of the upgrade is in order....
Understanding What Has Changed Between MySQL 5.6 and 5.7 Before Upgrading
MySQL 5.7 has been GA since October 2015. At the time of writing, it is still a very new release. But more and more companies are looking into upgrading, as it has a list of...
Webinar Replay: How to Upgrade to MySQL 5.7
Thanks to everyone who participated in this week’s live webinar on how to upgrade to MySQL 5.7. If you missed the session and/or would like to watch the replay in your own time, it is...
Webinar Replay: Performing Live Database Upgrades in Replication & Clustered 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...
How to Perform an Online Upgrade of Galera Cluster to MySQL 5.6
Oracle released a GA version of MySQL 5.6 in February 2013, Codership released the first GA in their patched 5.6 series in November 2013. Galera Cluster for MySQL 5.6 has been around for almost 2...
An Overview of MySQL Database Upgrades
Database vendors typically release patches with bug/security fixes on a monthly basis, why should we care? The news is full of reports of security breaches and hacked systems, so unless security is not a concern,...
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...