Welcome to Centmin Mod Community
Register Now

FYI, MySQL 8.0 doesn't support minor version downgrades anymore

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Jan 12, 2020.

Thread Status:
Not open for further replies.
  1. eva2000

    eva2000 Administrator Staff Member

    54,606
    12,225
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,794
    Local Time:
    1:08 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    This is a public notice to let folks know that if you're using Oracle MySQL 8.0 or Percona MySQL 8.0 versions, that even minor version downgrades are not supported anymore unlike on MySQL 5.7 and below and MariaDB 10.4 and below. So you can't rollback/downgrade from MySQL 8.0.18 to 8.0.17 easily anymore without doing a full all database backup restore from a prior minor version upgrade backup. You'll have to backup not just your web app databases but system MySQL databases too (basically all databases on the server).
    Which means it's more important to have regular full all databases on server backups as only way to downgrade even MySQL 8 minor versions i.e. 8.0.18 to 8.0.17, is do to a full all databases on server restore from pre-upgrade backups !
    Info Links
    My Centmin Mod forum user's discussions
    Centmin Mod 123.09beta01 and newer officially only support MariaDB MySQL servers from 5.5, 10.1, 10.2, 10.3 and 10.4. With planned support for Oracle MySQL 8 and Percona MySQL 8 way into the future as outlined in dev dashboard at centminmod/centminmod.


    Preview of MySQL 8.0 on Centmin Mod 123.09beta01 on CentOS 7.7 64bit system
    Code (Text):
    cat /etc/redhat-release ; cat /etc/centminmod-release ; echo; mysqladmin ver
    
    CentOS Linux release 7.7.1908 (Core)
    
    123.09beta01.b392
    
    mysqladmin  Ver 8.0.18 for Linux on x86_64 (MySQL Community Server - GPL)
    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    Server version          8.0.18
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 1 hour 4 min 5 sec
    Threads: 2  Questions: 12278  Slow queries: 0  Opens: 347  Flush tables: 3  Open tables: 267  Queries per second avg: 3.193
    

    With version lock in place
    Code (Text):
    yum versionlock -q | grep mysql
    0:mysql-community-client-8.0.18-1.el7.*
    0:mysql-community-server-8.0.18-1.el7.*
    0:mysql-community-libs-compat-8.0.18-1.el7.*
    0:mysql-community-devel-8.0.18-1.el7.*
    0:mysql-community-common-8.0.18-1.el7.*
    
     
    Last edited: Jan 12, 2020
Thread Status:
Not open for further replies.