一、安装mysql
1. 安装必备组件
yum install –y autoconf automake imake libxml2-devel expat-devel cmake gcc gcc-c++ libaio libaio-devel bzr bison libtool ncurses5-devel
2.下载mysql源码包
cd /usr/local
wget -c http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.14-linux-glibc2.5-x86_64.tar.gz/from/http://cdn.mysql.com/ -O mysql-5.6.14-linux-glibc2.5-x86_64.tar.gz
tar zxvf mysql-5.6.14-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.6.14-linux-glibc2.5-x86_64 mysql
mkdir -p /home/data/mysql_data
mkdir -p /home/data/mysql_log
mkdir -p /home/data/log-bin
groupadd mysql
useradd mysql -g mysql -M -s /sbin/nologin
chown -R mysql.mysql /home/data/mysql* /home/data/log-bin
chown -R mysql.mysql /usr/local/mysql
vim /etc/my.cnf #修改mysql配置文件,改成如下内容
--------------------------------------------------------------------------
[mysqld]
explicit_defaults_for_timestamp=true
# GENERAL #
user = mysql
default-storage-engine = InnoDB
socket = /home/data/mysql_data/mysql.sock
pid-file = /home/data/mysql_data/mysql.pid
port = 3306
# MyISAM #
key_buffer_size = 1344M
myisam_recover = FORCE,BACKUP
# SAFETY #
max_allowed_packet = 16M
max_connect_errors = 1000000
skip_name_resolve
# DATA STORAGE #
datadir = /home/data/mysql_data/
long_query_time = 1
# BINARY LOGGING #
log-bin = /home/data/log-bin/mysql-bin
expire-logs-days = 14
sync-binlog = 1
server-id = 1
max_binlog_size = 500M
# REPLICATION #
relay-log = /home/data/log-bin/relay-bin
slave-net-timeout = 60
# CACHES AND LIMITS #
tmp_table_size = 32M
max_heap_table_size = 32M
max_connections = 500
thread_cache_size = 50
open_files_limit = 65535
table_definition_cache = 4096
table_open_cache = 4096
# INNODB #
innodb_data_file_path = ibdata1:128M;ibdata2:10M:autoextend
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_lock_wait_timeout = 50
innodb_log_file_size = 256M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
innodb_thread_concurrency = 8
innodb_buffer_pool_size = 8G
# LOGGING #
log-error = /home/data/mysql_log/mysql-error.log
log-queries-not-using-indexes = 1
slow-query-log = 1
long_query_time = 1
slow-query-log-file = /home/data/mysql_log/mysql-slow.log
--------------------------------------------------------------------------
cp -af /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
vim /etc/init.d/mysqld #修改如下内容
--------------------------------------------------------------------------
basedir=/usr/local/mysql
datadir=/home/data/mysql_data
--------------------------------------------------------------------------
chmod a+x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
chkconfig --list |grep mysqld
rm -f /usr/local/mysql/my.cnf
cp /etc/my.cnf /usr/local/mysql/
chown -R mysql.mysql /usr/local/mysql
cd /usr/local/mysql
./scripts/mysql_install_db --user=mysql --defaults-file=/etc/my.cnf
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
ln -s /home/data/mysql_data/mysql.sock /tmp/mysql.sock
service mysqld start
mysql -uroot -p
--------------------------------------------------------------------------
Mysql> delete from mysql.user where user='';
Mysql> update mysql.user set password=PASSWORD(‘xxxxxxxx’) where user='root';
Mysql>flush privileges;
--------------------------------------------------------------------------
二、安装php
cd /usr/local
wget http://cn2.php.net/get/php-5.5.38.tar.gz/from/this/mirror
mv mirror php-5.5.38.tar.gz
yum install gcc make gd-devel libjpeg-devel libpng-devel libxml2-devel bzip2-devel curl curl-devel libcurl-devel -y
tar zxvf php-5.5.38.tar.gz
cd php-5.5.38
./configure
--enable-bcmath
--prefix=/usr/local/php-5.5.38 --with-config-file-path=/usr/local/php-5.5.38/etc
--with-bz2 --with-curl --enable-ftp --enable-sockets
--disable-ipv6
--with-gd
--with-jpeg-dir=/usr/local
--with-png-dir=/usr/local
--with-freetype-dir=/usr/local
--enable-gd-native-ttf --with-iconv-dir=/usr/local
--enable-mbstring --enable-calendar
--with-gettext --with-libxml-dir=/usr/local
--with-zlib --with-pdo-mysql=mysqlnd
--with-mysqli=mysqlnd --with-mysql=mysqlnd --enable-dom
--enable-xml --enable-fpm --with-libdir=lib64
make && make install
cp /usr/local/php-5.5.38/php.ini-production /usr/local/php-5.5.38/etc/php.ini
cp /usr/local/php-5.5.38/etc/php-fpm.conf.default /usr/local/php-5.5.38/etc/php-fpm.conf
ln -s /usr/local/php-5.5.38/sbin/php-fpm /usr/bin/php-fpm
配置PHP参数值,如配置不合理,可能会导致zabbix无法正常启动
vim /usr/local/php-5.5.38/etc/php.ini #下面几个参数修改成如下内容,或按需要配置
------------------------------------------------------------------------
max_execution_time = 300
memory_limit = 128M
post_max_size = 16M
upload_max_filesize = 2M
max_input_time = 300
date.timezone = PRC
------------------------------------------------------------------------
#启动php-fpm
php-fpm
netstat -ntpl |grep 9000
三、安装nginx
vim /etc/yum.repos.d/nginx.repo
-----------------------------------------------------------------
[nginx]
name=nginx repo
baseurl=http://nginx.org/packages/centos/6/$basearch/
gpgcheck=0
enabled=1
-----------------------------------------------------------------
yum install nginx -y
mkdir -p /usr/local/website/testphp
vim /usr/local/website/testphp/info.php
-----------------------------------------------------------------
<?php
phpinfo();
?>
-----------------------------------------------------------------
vim /etc/nginx/conf.d/test.conf
-----------------------------------------------------------------
server {
listen 80;
server_name www.testttls.com;
access_log /var/log/nginx/testphp.com.access.log main;
index index.php index.html index.html;
root /usr/local/website/testphp;
location / {
try_files $uri $uri/ /index.php?$args;
}
location ~ .*\.(php)?$ {
expires -1s;
try_files $uri =404;
fastcgi_split_path_info ^(.+\.php)(/.+)$;
include fastcgi_params;
fastcgi_param PATH_INFO $fastcgi_path_info;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_pass 127.0.0.1:9000;
}
}
-----------------------------------------------------------------
service nginx start
#启动服务后在本地windows 电脑 hosts 文件中 绑定服务器IP 和www.testttls.com域名,然后在浏览器中打开www.testttls.com/info.php 出现如下页面则php安装成功
四、安装zabbix-server
cd /usr/local
在该网站下载需要的zabbix 版本http://www.zabbix.com/download
上传到/usr/local 目录下
tar zxvf zabbix-3.2.4.tar.gz
cd zabbix-3.2.4
./configure --prefix=/usr/local/zabbix-3.2.4/ --enable-server --enable-agent --with-mysql=/usr/local/mysql/bin/mysql_config --with-net-snmp --with-libcurl --with-libxml2
make && make install
添加zabbix 运行用户组
groupadd zabbix
useradd zabbix -g zabbix
注:zabbix-server 共需要导入3个源码包中的sql文件,而搭建proxy 则只需要导入一个sql
#创建zabbix 数据库
mysql -uroot -pxxxx
mysql> create database zabbix default charset utf8;
Query OK, 1 row affected (0.00 sec)
mysql> quit
# mysql -uroot -pxxxx zabbix < /usr/local/zabbix-3.2.4/database/mysql/schema.sql
# mysql -uroot -pxxx zabbix < /usr/local/zabbix-3.2.4/database/mysql/images.sql
# mysql -uroot -pxxx zabbix < /usr/local/zabbix-3.2.4/database/mysql/data.sql
#配置zabbix 服务器
mkdir -p /etc/zabbix
cp /usr/local/zabbix-3.2.4/conf/zabbix_server.conf /etc/zabbix
vim /etc/zabbix/zabbix_server.conf
------------------------------------------------------------------------
DBName=zabbix
DBUser=root
DBPassword=XXXXX
DBPort=3306
------------------------------------------------------------------------
echo "/usr/local/mysql/lib" >> /etc/ld.so.conf
ldconfig
/usr/local/zabbix-3.2.4/sbin/zabbix_server -c /etc/zabbix/zabbix_server.conf
/usr/local/zabbix-3.2.4/sbin/zabbix_agentd
#配置zabbix web
mkdir -p /home/data/zabbix/zabbix
cp -rp /usr/local/zabbix-3.2.4/frontends/php/* /home/data/zabbix/zabbix
vim /etc/nginx/conf.d/zabbix.conf
------------------------------------------------------------------------
server {
listen 80;
server_name zabbix.prd.xjh.com;
access_log /var/log/nginx/zabbix.prd.xjh.com.access.log main;
index index.php index.html index.html;
root /home/data/zabbix;
location / {
try_files $uri $uri/ /index.php?$args;
}
location ~ .*\.(php)?$ {
expires -1s;
try_files $uri =404;
fastcgi_split_path_info ^(.+\.php)(/.+)$;
include fastcgi_params;
fastcgi_param PATH_INFO $fastcgi_path_info;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_pass 127.0.0.1:9000;
}
}
------------------------------------------------------------------------
cp /home/data/zabbix/zabbix/conf/zabbix.conf.php.example /home/data/zabbix/zabbix/conf/zabbix.conf.php
vim /home/data/zabbix/zabbix/conf/zabbix.conf.php
------------------------------------------------------------------------
<?php
// Zabbix GUI configuration file.
global $DB;
$DB['TYPE'] = 'MYSQL';
$DB['SERVER'] = 'localhost';
$DB['PORT'] = '0';
$DB['DATABASE'] = 'zabbix';
$DB['USER'] = 'root';
$DB['PASSWORD'] = 'xxxxx';
// Schema name. Used for IBM DB2 and PostgreSQL.
$DB['SCHEMA'] = '';
$ZBX_SERVER = 'localhost';
$ZBX_SERVER_PORT = '10051';
$ZBX_SERVER_NAME = 'zabbix-server';
$IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;
------------------------------------------------------------------------
#绑定hosts之后,打开浏览器访问
运维网声明
1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网 享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com