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?

ASKER CERTIFIED SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Eddie Shipman

ASKER

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/

Eddie Shipman

ASKER

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.

Dave Baldwin

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

Eddie Shipman

ASKER

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.