Support

 View Only
  • 1.  Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Posted 07-08-2022 15:11
    Edited by Ryan Dill 07-08-2022 15:12
    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
    ------------------------------


  • 2.  RE: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Posted 07-12-2022 16:59
    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
    ------------------------------



  • 3.  RE: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Posted 07-12-2022 19:35
    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
    ------------------------------



  • 4.  RE: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Posted 07-15-2022 12:44
    Hi Ryan, 

    Thanks! We're digging into this and will follow up.

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



  • 5.  RE: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Posted 08-09-2022 08:33
    Hi, Carly -- any updates on this ask?

    Thanks.

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



  • 6.  RE: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Posted 08-12-2022 17:24
    Hi Ryan, 

    Apologies for the delay here! I believe both guides are now updated.

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



  • 7.  RE: Guides for upgrade from MySQL 5.7 to MySQL 8.0?

    Posted 25 days ago
    Thanks, Carly.

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