Tag Archives: percona

percona mongo db yum install #devops #dba #sysadmin

percona mongo db yum install

https://www.percona.com/doc/percona-server/5.5/installation/yum_repo.html

yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

yum install Percona-Server-MongoDB


Advertisements

in #centos 6.x #percona 5.x #phpmyadmin 4.x reads config file from a new directory #dba #devops #sysadmin

in #centos 6.x #percona 5.x #phpmyadmin 4.x reads its config file from a completely different directory – it is no longer in the phpmyadmin code directory

ACTUAL centos 6 percona 5 phpmyadmin 4 config files are as follows

  • phpMyAdmin httpd – /etc/httpd/conf.d/phpMyAdmin.conf
  • phpMyAdmin conf – /etc/phpMyAdmin/config.inc.php
  • phpMyAdmin code – /usr/share/phpMyAdmin/

See also

mariadb, mysql and percona 5.5 general query and slow query logging

mariadb, mysql and percona 5.5 general query and slow query logging

mysql> select @@general_log;
+---------------+
| @@general_log |
+---------------+
|             1 |
+---------------+


mysql> select @@general_log_file;
+-------------------------------+
| @@general_log_file            |
+-------------------------------+
| /var/lib/mysql/data/query.log |
+-------------------------------+


mysql> select  @@slow_query_log;
+------------------+
| @@slow_query_log |
+------------------+
|                1 |
+------------------+


mysql> select @@slow_query_log_file;
+------------------------------------+
| @@slow_query_log_file              |
+------------------------------------+
| /var/lib/mysql/data/mysql-slow.log |
+------------------------------------+

ubuntu 14.04 (trusty) percona 5 install howto

https://www.percona.com/doc/percona-server/5.5/installation/apt_repo.html

howto switch from mysql 5 to percona 5 on ubuntu 14.04 trusty

remove mysql (if youve already installed it)

# aptitude remove mysql-client-5.5 mysql-client-core-5.5 mysql-workbench

install percona

# apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
# vi /etc/apt/sources.list

  deb http://repo.percona.com/apt trusty main
  dpkg http://repo.percona.com/apt trusty main
  
# aptitude update
# aptitude install percona-server-client-5.5 percona-server-server-5.5