Join the community today
Become a Member

MariaDB Has Anyone replaced MariaDB with Percona 5.7?

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

  1. BamaStangGuy

    BamaStangGuy Active Member

    465
    136
    43
    May 25, 2014
    Ratings:
    +179
    Local Time:
    4:33 AM
    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. eva2000

    eva2000 Administrator Staff Member

    28,935
    6,567
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,747
    Local Time:
    7:33 PM
    Nginx 1.13.x
    MariaDB 5.5
    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. BamaStangGuy

    BamaStangGuy Active Member

    465
    136
    43
    May 25, 2014
    Ratings:
    +179
    Local Time:
    4:33 AM
    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. eva2000

    eva2000 Administrator Staff Member

    28,935
    6,567
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,747
    Local Time:
    7:33 PM
    Nginx 1.13.x
    MariaDB 5.5
    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. BamaStangGuy

    BamaStangGuy Active Member

    465
    136
    43
    May 25, 2014
    Ratings:
    +179
    Local Time:
    4:33 AM
    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.
     
    • Like Like x 1
  6. eva2000

    eva2000 Administrator Staff Member

    28,935
    6,567
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,747
    Local Time:
    7:33 PM
    Nginx 1.13.x
    MariaDB 5.5
    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. pamamolf

    pamamolf Well-Known Member

    2,487
    229
    63
    May 31, 2014
    Ratings:
    +390
    Local Time:
    12:33 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    Why?

    What issues will be there ?
     
  8. eva2000

    eva2000 Administrator Staff Member

    28,935
    6,567
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,747
    Local Time:
    7:33 PM
    Nginx 1.13.x
    MariaDB 5.5
    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 :)