asked on 1/26/2016

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?

Linux MySQL Server

Last Comment

Eddie Shipman

1/27/2016

ASKER CERTIFIED SOLUTION

Dave Baldwin

1/26/2016

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Eddie Shipman

1/26/2016

ASKER

Having Deadlock issues on Magento.

Dave Baldwin

1/26/2016

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

1/27/2016

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

1/27/2016

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

Eddie Shipman

1/27/2016

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.