Avatar of Eddie Shipman
Eddie ShipmanFlag for United States of America asked on

Upgrading mySQL on Suse Linux

I need to upgrade my mySQL version that is installed on an Suse Linux server. We have three of these and I want to test on one of them before upgrading our production server.
I do not have access to annything except command line.

Our configuration:
    internal:~ # cat /proc/version
    Linux version 2.6.32.12-0.7-default (geeko@buildhost) (gcc version 4.3.4 [gcc-4_3-branch revision 152973] (SUSE Linux) ) #1 SMP 2010-05-20 11:14:20 +0200
    internal:~ # lsb_release -a
    LSB Version:    core-2.0-noarch:core-3.2-noarch:core-4.0-noarch:core-2.0-x86_64:core-3.2-x86_64:core-4.0-x86_64:desktop-4.0-amd64:
                    desktop-4.0-noarch:graphics-2.0-amd64:graphics-2.0-noarch:graphics-3.2-amd64:graphics-3.2-noarch:graphics-4.0-amd64:
                    graphics-4.0-noarch
    Distributor ID: SUSE LINUX
    Description:    SUSE Linux Enterprise Server 11 (x86_64)
    Release:        11
    Codename:       n/a
    
    internal:~ # mysql
    mysql> show variables like '%version%';
    +-------------------------+----------------+
    | Variable_name           | Value          |
    +-------------------------+----------------+
    | protocol_version        | 10             |
    | version                 | 5.0.67         |
    | version_comment         | SUSE MySQL RPM |
    | version_compile_machine | x86_64         |
    | version_compile_os      | suse-linux-gnu |
    +-------------------------+----------------+

Open in new window

Now all the docs I read are that I have to insall a MariaDB package?? Is this the version of Suse that has the multiple mySQL variants on it and can I just switch between them?
How do I determine which ones are installed?
LinuxMySQL Server

Avatar of undefined
Last Comment
Eddie Shipman

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Dave Baldwin

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Eddie Shipman

Having Deadlock issues on Magento.
Dave Baldwin

Don't know what to tell you.  I would be hesitant to experiment on a production server.  There is an OpenSource version called OpenSUSE that you could install on another machine and experiment on.  https://www.opensuse.org/
ASKER
Eddie Shipman

I wasn't going to experiment on the production server. I have 2 test servers that I was going to do the upgrade on, first.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Dave Baldwin

Can you reproduce the deadlock problem on the test servers?  That is so you can tell that something changed.
ASKER
Eddie Shipman

No because of the traffic issues. I can't simulate the same traffic as on our production server. We have the exact same code on our staging server but do not get any deadlocks.
In fact, our servers are running on a Hyper-V VM and the staging site is an exact clone of the production site with the site url changed.