/ Register

Welcome to Centmin Mod Community
Register Now

MariaDB Has Anyone replaced MariaDB with Percona 5.7?

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by BamaStangGuy, Jan 25, 2017.

Tags:
Previous Thread Next Thread
Loading...
  1. Jan 25, 2017 #1
    BamaStangGuy

    BamaStangGuy Active Member

    668
    192
    43
    May 25, 2014
    Ratings:
    +272
    Local Time:
    6:10 PM
    On our new server we wish to remove MariaDB and install Percona 5.7 instead.

    On our test server we have done the following:

    yum remove MariaDB-*
    yum install Percona-Server-server-57 Percona-Server-client
    yum install postfix net-snmp mytop postfix-perl-scripts (these were removed via the first command)

    However, when i go to start mysql now with service mysql start I get the following:

    Code:
    [root@li35-170 yum.repos.d]# service mysql restart
Redirecting to /bin/systemctl restart  mysql.service
Failed to restart mysql.service: Unit not found.
[root@li35-170 yum.repos.d]# whereis mysql
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/share/man/man1/mysql.1.gz
    What is the proper way to uninstall MariaDB and install Percona?
     
  2. Jan 25, 2017 #2
    eva2000

    eva2000 Administrator Staff Member

    55,380
    12,255
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,835
    Local Time:
    9:10 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    My advice is stick with MariaDB 10.1 ;)

    what's output for
    Code (Text):
    yum history list
yum history XXX

    Where XXX is latest transaction id from list command

    check mysql log for clues too as variables may differ between Percona vs MariaDB
     
  3. Jan 25, 2017 #3
    BamaStangGuy

    BamaStangGuy Active Member

    668
    192
    43
    May 25, 2014
    Ratings:
    +272
    Local Time:
    6:10 PM
    We want to keep the exact same server configuration if possible. We had issues with MariaDB with our database size last time we tried to use it. Will check those out asap.
     
  4. Jan 26, 2017 #4
    eva2000

    eva2000 Administrator Staff Member

    55,380
    12,255
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,835
    Local Time:
    9:10 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    You mean https://community.centminmod.com/threads/crashes-on-large-db-imports.2562/#post-11910 ? did you ever submit or check the MariaDB Jira ? That was with MariaDB 10.0.17. Now MariaDB 10.0.29 is latest in 123.08stable and MariaDB 10.1.21 is latest on 123.09beta01 (recommended branch) :)

    MariaDB moved their Jira bug and issue tracker to System Dashboard - JIRA
     
  5. Jan 26, 2017 #5
    BamaStangGuy

    BamaStangGuy Active Member

    668
    192
    43
    May 25, 2014
    Ratings:
    +272
    Local Time:
    6:10 PM
    Yea that was the issue. We never looked into it as we decided to just stick with Percona over the years. It has done great. We will give MariaDB another shot this time around.
     
  6. Jan 26, 2017 #6
    eva2000

    eva2000 Administrator Staff Member

    55,380
    12,255
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,835
    Local Time:
    9:10 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Yeah Percona 5.7 is great too just managing differences in some variables supported between Percona and MariaDB 10.0/10.1 and soon MariaDB 10.2 will be problematic for fully automated routines.
     
  7. Jan 26, 2017 #7
    pamamolf

    pamamolf Well-Known Member

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +838
    Local Time:
    2:10 AM
    Nginx-1.26.x
    MariaDB 10.6.x
    Why?

    What issues will be there ?
     
  8. Jan 26, 2017 #8
    eva2000

    eva2000 Administrator Staff Member

    55,380
    12,255
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,835
    Local Time:
    9:10 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Differences between existing pre-percona and post-percona variables supported. Also if end user uses a variable not supported prior to percona update, mysql server won't start and really that wouldn't be something I'd like to provide tech support for free :)
     
Previous Thread Next Thread
Loading...

.