Guides for upgrade from MySQL 5.7 to MySQL 8.0?

Ryan Dill
Ryan Dill Member Posts: 57
edited March 13 in Peer-to-Peer Support Forum
Jama Connect has supported MySQL 8 as a back-end database since at least Jama Connect 8.49.

We're now on Jama Connect 8.66, previously using a back-end of MySQL 5.7, and wish to now update to MySQL 8. Is there any upgrade guide or guidance from Jama Software we should be aware of?

I ask because I've already noticed three "recommended settings" in the Jama MySQL documentation which the MySQL 8 upgrade checker warns me are not valid in 8.0.29, and will be removed -- which implies to me that the Jama MySQL documentation may be out-of-date.

I'd like to make sure there aren't other "gotchas" that Jama Software may already be aware of in advance of the upgrade, and ensure they're communicated appropriately to customers.
Ryan Dill

Comments

  • [Deleted User]
    [Deleted User] Posts: 152
    edited July 2022
    Hi Ryan,

    Do you get the same removal warnings if you use the steps outlined in the Jama User Guide for updating and configuring MySQL instead?
  • Ryan Dill
    Ryan Dill Member Posts: 57
    edited July 2022
    Hi, Carly -- that page documents the same "recommended settings" as the page I mentioned (and actually links to the same page I mentioned at its top) -- so in a word, "yes". :)

    i.e. Both pages contain configuration values which are no longer valid in MySQL 8.0.29. The pertinent bits from the MySQL upgrade checker: 
    15) Removed system variables
      Error: Following system variables that were detected as being used will be
        removed. Please update your system to not rely on them before the upgrade.
      More information:
    https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html#optvars-removed

      query_cache_size - is set and will be removed
      query_cache_type - is set and will be removed
    (I mentioned a third recommended setting in my original message -- On further investigation, it turns out that third setting was actually not one recommended by Jama Software, so I won't bother mentioning it here -- I don't think the two above have been valid since 2017's MySQL 8.0.3, though)

    I'm assuming that whoever validated Jama Connect's MySQL 8.0 support must have run into the removal of support for these two variables, and documented it somewhere -- potentially along with anything else that customers should know about upgrading from 5.7 to 8.0. Could this information be provided?

    Thanks.
    Ryan Dill
  • [Deleted User]
    [Deleted User] Posts: 152
    edited July 2022
    Hi Ryan, 

    Thanks! We're digging into this and will follow up.
  • Ryan Dill
    Ryan Dill Member Posts: 57
    edited August 2022
    Hi, Carly -- any updates on this ask?

    Thanks.
    Ryan Dill
  • [Deleted User]
    [Deleted User] Posts: 152
    edited August 2022
    Hi Ryan, 

    Apologies for the delay here! I believe both guides are now updated.
  • Ryan Dill
    Ryan Dill Member Posts: 57
    edited September 2022
    Thanks, Carly.
    Ryan Dill
  • Sandra Wiegratz
    Sandra Wiegratz Member Posts: 14
    edited January 22

    Hi Rossi

    I'd like to come back to this ticket, since we want to update our dbms from MySQL 5.7 to 8.0 (we are running Jama 8.66.1 and want to upgrade step by step). Unfortunately, none of the links provided in this conversation are working anymore. Have you moved the documentation "Jama User Guide for updating and configuring MySQL" (https://help.jamasoftware.com/ah/en/upgrade-the-application-html/upgrade-and-configure-mysql.html) and "Jama MySQL documentation" (https://help.jamasoftware.com/ah/en/installing-jama-connect/installation-prerequisites/things-to-do-before-installation/use-mysql-for-database-server-html.html) to another space?

    Sandra



    ------------------------------
    Sandra Wiegratz
    MeVis BreastCare GmbH & Co. KG
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 07-12-2022 16:58
    From: Carly Rossi
    Subject: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Hi Ryan,

    Do you get the same removal warnings if you use the steps outlined in the Jama User Guide for updating and configuring MySQL instead?

    ------------------------------
    Carly Rossi // she/her
    Community Manager // Jama Software
    Portland, OR
    ------------------------------

    Original Message:
    Sent: 07-08-2022 15:11
    From: Ryan Dill
    Subject: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Jama Connect has supported MySQL 8 as a back-end database since at least Jama Connect 8.49.

    We're now on Jama Connect 8.66, previously using a back-end of MySQL 5.7, and wish to now update to MySQL 8. Is there any upgrade guide or guidance from Jama Software we should be aware of?

    I ask because I've already noticed three "recommended settings" in the Jama MySQL documentation which the MySQL 8 upgrade checker warns me are not valid in 8.0.29, and will be removed -- which implies to me that the Jama MySQL documentation may be out-of-date.

    I'd like to make sure there aren't other "gotchas" that Jama Software may already be aware of in advance of the upgrade, and ensure they're communicated appropriately to customers.

    ------------------------------
    Ryan Dill
    ------------------------------

  • [Deleted User]
    [Deleted User] Posts: 152
    edited January 23

    Hi Sandra, 

    Our user guides for self-hosted customers are now available on the Jama Software® Support site, in the Jama Connect® User Guide & Knowledge Articles section under Jama Connect® User Guide Documentation. 

    I hope that helps!

    ------------------------------
    Carly Rossi // she/her/hers
    Community Program Manager // Jama Software
    Portland, OR
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 01-22-2024 05:38
    From: Sandra Wiegratz
    Subject: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Hi Rossi

    I'd like to come back to this ticket, since we want to update our dbms from MySQL 5.7 to 8.0 (we are running Jama 8.66.1 and want to upgrade step by step). Unfortunately, none of the links provided in this conversation are working anymore. Have you moved the documentation "Jama User Guide for updating and configuring MySQL" (https://help.jamasoftware.com/ah/en/upgrade-the-application-html/upgrade-and-configure-mysql.html) and "Jama MySQL documentation" (https://help.jamasoftware.com/ah/en/installing-jama-connect/installation-prerequisites/things-to-do-before-installation/use-mysql-for-database-server-html.html) to another space?

    Sandra



    ------------------------------
    Sandra Wiegratz
    MeVis BreastCare GmbH & Co. KG
    ------------------------------

    Original Message:
    Sent: 07-12-2022 16:58
    From: Carly Rossi
    Subject: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Hi Ryan,

    Do you get the same removal warnings if you use the steps outlined in the Jama User Guide for updating and configuring MySQL instead?

    ------------------------------
    Carly Rossi // she/her
    Community Manager // Jama Software
    Portland, OR

    Original Message:
    Sent: 07-08-2022 15:11
    From: Ryan Dill
    Subject: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Jama Connect has supported MySQL 8 as a back-end database since at least Jama Connect 8.49.

    We're now on Jama Connect 8.66, previously using a back-end of MySQL 5.7, and wish to now update to MySQL 8. Is there any upgrade guide or guidance from Jama Software we should be aware of?

    I ask because I've already noticed three "recommended settings" in the Jama MySQL documentation which the MySQL 8 upgrade checker warns me are not valid in 8.0.29, and will be removed -- which implies to me that the Jama MySQL documentation may be out-of-date.

    I'd like to make sure there aren't other "gotchas" that Jama Software may already be aware of in advance of the upgrade, and ensure they're communicated appropriately to customers.

    ------------------------------
    Ryan Dill
    ------------------------------

  • Sandra Wiegratz
    Sandra Wiegratz Member Posts: 14
    edited January 29

    Thanks, Carly. In the meanwhile I have found the user guide pdfs for most versions of Jama Connect.

    ------------------------------
    Sandra Wiegratz
    MeVis BreastCare GmbH & Co. KG
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 01-23-2024 10:25
    From: Carly Rossi
    Subject: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Hi Sandra, 

    Our user guides for self-hosted customers are now available on the Jama Software® Support site, in the Jama Connect® User Guide & Knowledge Articles section under Jama Connect® User Guide Documentation. 

    I hope that helps!

    ------------------------------
    Carly Rossi // she/her/hers
    Community Program Manager // Jama Software
    Portland, OR
    ------------------------------

    Original Message:
    Sent: 01-22-2024 05:38
    From: Sandra Wiegratz
    Subject: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Hi Rossi

    I'd like to come back to this ticket, since we want to update our dbms from MySQL 5.7 to 8.0 (we are running Jama 8.66.1 and want to upgrade step by step). Unfortunately, none of the links provided in this conversation are working anymore. Have you moved the documentation "Jama User Guide for updating and configuring MySQL" (https://help.jamasoftware.com/ah/en/upgrade-the-application-html/upgrade-and-configure-mysql.html) and "Jama MySQL documentation" (https://help.jamasoftware.com/ah/en/installing-jama-connect/installation-prerequisites/things-to-do-before-installation/use-mysql-for-database-server-html.html) to another space?

    Sandra



    ------------------------------
    Sandra Wiegratz
    MeVis BreastCare GmbH & Co. KG

    Original Message:
    Sent: 07-12-2022 16:58
    From: Carly Rossi
    Subject: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Hi Ryan,

    Do you get the same removal warnings if you use the steps outlined in the Jama User Guide for updating and configuring MySQL instead?

    ------------------------------
    Carly Rossi // she/her
    Community Manager // Jama Software
    Portland, OR

    Original Message:
    Sent: 07-08-2022 15:11
    From: Ryan Dill
    Subject: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Jama Connect has supported MySQL 8 as a back-end database since at least Jama Connect 8.49.

    We're now on Jama Connect 8.66, previously using a back-end of MySQL 5.7, and wish to now update to MySQL 8. Is there any upgrade guide or guidance from Jama Software we should be aware of?

    I ask because I've already noticed three "recommended settings" in the Jama MySQL documentation which the MySQL 8 upgrade checker warns me are not valid in 8.0.29, and will be removed -- which implies to me that the Jama MySQL documentation may be out-of-date.

    I'd like to make sure there aren't other "gotchas" that Jama Software may already be aware of in advance of the upgrade, and ensure they're communicated appropriately to customers.

    ------------------------------
    Ryan Dill
    ------------------------------

Categories