Page 1 of 1
[Solved] VestaCP + Percona
Posted: Mon Nov 23, 2015 10:23 am
by .MP.
hi,
i've following the offical guide to install Percona after fresh install VestaCP (CentOS 6.7 x64).
but after that i have problems.
# /etc/my.cnf doesn't exist, but /etc/my.cnf.rpmsave exist
if i rename it, Percona won't start.
# i can't access phpMyAdmin, 403 Forbidden.
anyone can help me?
thanks.
Re: VestaCP + Percona
Posted: Mon Nov 23, 2015 2:59 pm
by skurudo
If by default my.cnf is not created. You have to create it yourself.
Some output like this:
/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-small.cnf
/usr/share/doc/Percona-Server-server-51-5.1.51/my-huge.cnf
/usr/share/doc/Percona-Server-server-51-5.1.51/my-medium.cnf
/usr/share/doc/Percona-Server-server-51-5.1.51/my-large.cnf
/usr/share/doc/Percona-Server-server-51-5.1.51/my-innodb-heavy-4G.cnf
/usr/share/doc/Percona-Server-server-51-5.1.51/my-small.cnf
And you can copy and rename percona conf file (try medium for start)
Re: VestaCP + Percona
Posted: Wed Nov 25, 2015 7:15 am
by .MP.
i only have this :
/usr/local/vesta/install/rhel/5/mariadb/my-large.cnf
/usr/local/vesta/install/rhel/5/mariadb/my-medium.cnf
/usr/local/vesta/install/rhel/5/mariadb/my-small.cnf
/usr/local/vesta/install/rhel/5/mysqld/my-large.cnf
/usr/local/vesta/install/rhel/5/mysqld/my-medium.cnf
/usr/local/vesta/install/rhel/5/mysqld/my-small.cnf
/usr/local/vesta/install/rhel/6/mariadb/my-large.cnf
/usr/local/vesta/install/rhel/6/mariadb/my-medium.cnf
/usr/local/vesta/install/rhel/6/mariadb/my-small.cnf
/usr/local/vesta/install/rhel/6/mysqld/my-large.cnf
/usr/local/vesta/install/rhel/6/mysqld/my-medium.cnf
/usr/local/vesta/install/rhel/6/mysqld/my-small.cnf
/usr/local/vesta/install/rhel/7/mariadb/my-large.cnf
/usr/local/vesta/install/rhel/7/mariadb/my-medium.cnf
/usr/local/vesta/install/rhel/7/mariadb/my-small.cnf
/usr/local/vesta/install/rhel/7/mysqld/my-large.cnf
/usr/local/vesta/install/rhel/7/mysqld/my-medium.cnf
/usr/local/vesta/install/rhel/7/mysqld/my-small.cnf
/usr/share/php/phpseclib/openssl.cnf
/usr/share/doc/Percona-Server-server-56-5.6.27/my-default.cnf
/usr/share/percona-server/my-default.cnf
/var/lib/mysql/auto.cnf
mysqld and mariadb only, dont have percona.
which one should i use?
Re: VestaCP + Percona
Posted: Wed Nov 25, 2015 7:16 am
by skurudo
.MP. wrote:i only have this :
mysqld and mariadb only, dont have percona.
which one should i use?
One of those:
/usr/share/doc/Percona-Server-server-56-5.6.27/my-default.cnf
/usr/share/percona-server/my-default.cnf
I think - second - copy and rename.
Re: VestaCP + Percona
Posted: Wed Nov 25, 2015 7:56 am
by .MP.
done this is my.cnf content :
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 240K
#innodb_use_native_aio = 0
innodb_file_per_table
max_connections=50
max_user_connections=25
wait_timeout=10
interactive_timeout=50
long_query_time=5
#slow_query_log=1
#slow_query_log_file=/var/log/mysql-slow-queries.log
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
but phpmyadmin still error, i can't access it..
404 error..
where i can configured it?
Re: VestaCP + Percona
Posted: Wed Nov 25, 2015 9:08 am
by .MP.
After check httpd config for phpMyAdmin :
/etc/httpd/conf.d/phpMyAdmin.conf
the folder /usr/share/phpMyAdmin not exist.
it because i forget install phpMyAdmin after change MySQL to Percona.
yum install php-mysqlnd phpmyadmin --enablerepo=remi
cp /etc/httpd/conf.d/phpMyAdmin.conf.rpmsave /etc/httpd/conf.d/phpMyAdmin.conf
service httpd restart
now its work perfectly after i install it.
thanks.
[SOLVED]
Re: VestaCP + Percona
Posted: Wed Nov 25, 2015 9:32 am
by skurudo
.MP. wrote:the folder /usr/share/phpMyAdmin not exist.
it because i forget install phpMyAdmin after change MySQL to Percona.
[SOLVED]
Nice! Good solution ;-)