We help IT Professionals succeed at work.

Upgrading mySQL on Suse Linux

Eddie Shipman
on
119 Views
Last Modified: 2016-03-08
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?
Comment
Watch Question

Fixer of Problems
CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Eddie ShipmanAll-around developer
CERTIFIED EXPERT

Author

Commented:
Having Deadlock issues on Magento.
Dave BaldwinFixer of Problems
CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
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 ShipmanAll-around developer
CERTIFIED EXPERT

Author

Commented:
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 BaldwinFixer of Problems
CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
Can you reproduce the deadlock problem on the test servers?  That is so you can tell that something changed.
Eddie ShipmanAll-around developer
CERTIFIED EXPERT

Author

Commented:
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.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.