Upgrade to Percona Server on a WHM/Cpanel Server or VPS [Deleted]

MattW said:
It's not your servers root password, it's your MySQL root users password.

Code: 
mysql_upgrade -u root -p
it will ask you for the password. Use the one in that file.
Click to expand...

PHP: 
root@linger [~]# mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
FATAL ERROR: Can't execute 'mysql'
root@linger [~]#
 
type
Code: 
which mysql_upgrade

then try running it again with the full path given in the results from the above?
 
MattW said:
type
Code: 
which mysql_upgrade

then try running it again with the full path given in the results from the above?
Click to expand...

Was this right:

PHP: 
 which mysql_upgrade
/usr/bin/mysql_upgrade
/usr/bin/mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: /usr/bin/mysql
FATAL ERROR: Can't execute '/usr/bin/mysql'
root@linger [~]#
 
yavuz said:
Was this right:

PHP: 
which mysql_upgrade
/usr/bin/mysql_upgrade
/usr/bin/mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: /usr/bin/mysql
FATAL ERROR: Can't execute '/usr/bin/mysql'
root@linger [~]#
Click to expand...
Hmm, no idea why your server isn't running that command. MySQL is definitely running?
 
MattW said:
Hmm, no idea why your server isn't running that command. MySQL is definitely running?
Click to expand...

Yeah it is, sites are accessible:

PHP: 
root@linger [~]# top
top - 04:51:55 up 25 days, 16:12,  1 user,  load average: 0.62, 1.93, 2.86
Tasks: 273 total,   2 running, 270 sleeping,   0 stopped,   1 zombie
Cpu(s):  3.2%us,  0.4%sy,  0.0%ni, 95.7%id,  0.3%wa,  0.0%hi,  0.4%si,  0.0%st
Mem:  24541076k total, 24332700k used,   208376k free,   422936k buffers
Swap:  2097136k total,   140188k used,  1956948k free, 21059556k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
22647 userxxxx  20   0  276m  62m  40m S 18.9  0.3   0:18.30 php
22590 userxx    20   0  722m  56m  36m S  5.0  0.2   0:41.40 php
22612 userxx    20   0  717m  52m  37m R  1.7  0.2   0:42.41 php
18355 mysql     20   0 4041m 827m 7568 S  1.3  3.5   1:30.76 mysqld
23318 userxxxx  20   0  275m  62m  40m S  1.3  0.3   0:05.87 php
   42 root      20   0     0    0    0 S  0.3  0.0  18:48.76 events/7
16039 nobody    20   0 2015m  26m  10m S  0.3  0.1   0:03.87 httpd
16344 nobody    20   0 2015m  23m  10m S  0.3  0.1   0:03.56 httpd
16631 nobody    20   0 2015m  24m  10m S  0.3  0.1   0:03.63 httpd
23930 root      20   0 15160 1456 1000 R  0.3  0.0   0:00.01 top
    1 root      20   0 19232 1116  912 S  0.0  0.0   0:07.31 init
    2 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthreadd
    3 root      RT   0     0    0    0 S  0.0  0.0   0:46.25 migration/0
    4 root      20   0     0    0    0 S  0.0  0.0   0:02.08 ksoftirqd/0
    5 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/0
    6 root      RT   0     0    0    0 S  0.0  0.0   0:01.86 watchdog/0
    7 root      RT   0     0    0    0 S  0.0  0.0   0:11.10 migration/1
    8 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/1
    9 root      20   0     0    0    0 S  0.0  0.0   0:05.99 ksoftirqd/1
   10 root      RT   0     0    0    0 S  0.0  0.0   0:01.28 watchdog/1
 
and what's the output of mysql -v

Code: 
root@vps [~]# mysql -v
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1166464
Server version: 5.5.34-cll MySQL Community Server (GPL)
 
root@linger [~]# mysql -v
mysql: unknown variable 'slow_query_log=1'

getting this as result :confused:
 
in that case, you've got an error with your my.cnf file

Check your error logs for MySQL, as you've probably got other issues with it as well.
 
MattW said:
in that case, you've got an error with your my.cnf file

Check your error logs for MySQL, as you've probably got other issues with it as well.
Click to expand...

I've checked my mysql error log /var/lib/mysql/mysql-error.log there isn't an error from today. Should I remove the my.cnf entry and try that again?
 
Yeah, did that but was the same, I removed some others that I had added on advise (mysql tuner, tuner-primer) now it works.

Thank you @MattW I was actually a bit terrified :D
 
I've run easyapache and it finished up successfully (I guess) and restarted mysql server. Looks good now. How do I know I'm running percona? mysql -v is returning this:

PHP: 
root@linger [~]# mysql -v
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2457
Server version: 5.5.35-33.0 Percona Server (GPL), Release rel33.0, Revision 611

Copyright (c) 2009-2013 Percona LLC and/or its affiliates
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Is that it?
 
Rich (BB code): 
Server version: 5.5.35-33.0 Percona Server (GPL), Release rel33.0, Revision 611
That's a pretty big give away ;)
 
Those who are running Percona on WHM / cPanel and experiencing internal server errors, a cPanel support technician solved the problem. The problem is caused by Percona's version of libmysqlclient:

In order to comply with Linux distribution packaging standards Percona‘s version of libmysqlclient has been renamed to libperconaserver. The old name was conflicting with the upstream libmysqlclient. Except for packaging, libmysqlclient and libperconaserverclient of the same version do not have any differences. Users wishing to continue using libmysqlclient will have to install the corresponding package of their distribution, such as mysql-lib for CentOS and libmysqlclient18 for Ubuntu/Debian. Users wishing to build software against libperconaserverclient should install libperconaserverclient-dev package. An old version of Percona-built libmysqlclient will be available for download.

You will find the issue and the resolution here: http://www.mysqlperformanceblog.com/2014/03/10/percona-server-5-6-16-64-0-now-available/
Click to expand...

to solve it, run;

Code: 
cd /usr/lib64
ln -s libperconaserverclient.so libmysqlclient.so

Then run an easyapache, it will fix the problem.
 
yea my server automatically upgraded to the latest version of 5.5 and that definitely broke my site for hours while I was asleep
 
Last edited:
just a quick question:

do i need to recompile apache and php via easyapche each time i update percona server via yum?
and i asume i need to turn off mysql when i do these updates?
 
You must log in or register to reply here.
Top Bottom