View source for Setup Nginx PHP FPM Percona Mysql

==Setup Nginx + php-fpm + Percona Mysql==

First we will want to enable the epel repo and percona repos

 rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
 rpm -Uhv http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

===1) Install Percona Mysql===

Lets install Percona56 Server

 yum install Percona-Server-server-56 Percona-Server-client-56

To increase performance of INNODB tables lets create separate namespaces
 
 vim /etc/my.cnf

Now add the following line under [mysqld]

 [mysqld]
 innodb_file_per_table

Lets make sure Percona starts on boot

 chkconfig mysql on

Lets Start Percona Server
 
 /etc/init.d/mysql restart

===2) Install Nginx===

 yum install nginx -y

Let nginx to start on boot

 chkconfig nginx on

Now lets start nginx

 /etc/init.d/nginx start

===3) Install PHP-FPM/PHP-CLI===

Lets install php-fpm with Yum

 yum install php-fpm php-mysql php-mssql

Start php-fpm at boot up

 chkconfig php-fpm on

/etc/init.d/php-fpm start

Lets check and make sure there is no issues with php-fpm
 php-fpm -v
 PHP 5.3.3 (fpm-fcgi) (built: Dec 11 2013 03:17:57)
 Copyright (c) 1997-2012 The PHP Group
 Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies

If you want the default php -v via the command line we can create a symlink

 ln -s /usr/sbin/php-fpm /usr/sbin/php

===4) Configure Nginx to use PHP+FPM===

First thing we need to do is change the cgi.fix_pathinfo

 sed -i 's/;cgi.fix_pathinfo=1/cgi.fix_pathinfo=0/g' /etc/php.ini

If this number is kept as 1, the php interpreter will do its best to process the file that is as near to the requested file as possible. This is a possible security risk. If this number is set to 0, conversely, the interpreter will only process the exact file path—a much safer alternative.

Now restart php-fpm so it takes

 /etc/init.d/php-fpm restart

====PHP+FPM TCP====

By default php-fpm configuration is setup to tcp port 9000, you can verify this by going to /etc/php-fpm.d/www.conf and looking at the line that starts with listen

 vim /etc/php-fpm/www.conf

listen = 127.0.0.1:9000

====PHP+FPM Socket====