LANP KEEPALIVED集群(三)。
(w3 )源代码安装mysql
#具体请参见目录中的安装binary文件
安装#mysql并将MySQL压缩和解压缩到/usr/local
tarzxvfmysqladvance d99 Come Come Everybody5.6. 2399 Come Come Everybody Linuxglibc 2.599 Come Come Everybody x86Nintendo 64.tar.gz99 Come Come Everybody上,/UAR/local/
cd /usr/local
ln99 Come Come EverybodyMySQLadvance d99 Come Come Everybody5.6. 2399 Come Come Everybody Linuxglibc 2.599 Come Come Everybody x86Nintendo 64 MySQL
cd mysql
添加mysql用户和组
groupadd mysql
useraddr99 Come Come Everybody gmysqlmysql
#更改相关目录和文件的所有者和所属组
chownMySQL。
chgrpMySQL。
或chownMySQL 3360 MySQL。
#将目录的所有者更改为root,以防止mysql用户删除目录
chown根。
chownrmy sqldata
#安装依赖软件包
yumyoinstallibaiodevel perlmoduleinstall.noarch
使用mysql用户权限初始化数据库
scripts/MySQLinstalldb99 Come Come Everybodyuser=MySQL
将mysql添加为服务
CP supportfiles/MySQL.server/etc/init ./mysqld
chkconfigadd mysqld
将MySQL bin目录添加到PATH环境变量中
在/etc/profile的末尾添加
path=$ path :/usr/local/MySQL/bin
source/etc /配置文件
#在脚本初始化中,如果直接没有CP/etc/init ./MySQLD,则添加了mysqld脚本
/etc/RC ./init ./mysqld
mysql的启动
/usr/local/MySQL/bin/mysqldsafe
建立软连接
ln99 Come Come Everybody/var/lib/MySQL/MySQL.sock/tmp/MySQL.sock
通过#或/etc/my.cn修改
socket=/tmp/mysql.sock
#更改#MySQL根密码
/usr/local/MySQL adminurootppassword lovesocket=/var/lib/MySQL/MySQL.sock
(! ) nginx相关php
修改nginx.conf配置文件
服务器
listen 80
server_name www.postfix.local;
access_log logs/lanp.log;
location /
root html/lanp;
index index.php index.html;
位置. PHP $
root html/lanp;
fastcgipass 127.0.0.1:9000;
fastcgi_index index.php;
fastcgiparam script文件名称$文档root/$ fastcgiscript名称;
include fastcgi参数;
更改php
CP/usr/local/PHP/etc/PHPfpm.conf.default/usr/local/PHP/etc/PHPfpm.conf
#启动PHPfpm,缺省监视127.0.0.1:9000
/usr/local/PHP/sbin/PHPfpm
#确认是否启动
lsof:9000
netstattnlp grep 9000
如图所示,在“. php”中的所有请求在127.0.0.1:9000中进行处理,并在PHPfpm处理中进行处理
)5) lanp测试
读取mysql user表的内容并停止在网页上显示
# index.php文件的内容
PHP
$con=MySQL_connect('localhost '、' root '、' love ' );
$sql='select user,password from user ';
$ dbselect=MySQL选择db (' MySQL ',$con );
$result=MySQL_query($SQL,$con );
while ($ row=MySQLfetcharray ) $result ) )
echo $ row'用户'. '.$ row' password ';
echo 'br/';
MySQL_close($con;
#显示结果
8,lanp keepalived
(1)源代码安装keepalived
()高可用性测试
转载于:https://blog.51cto.com/1055745601/1659220