北京南站附近的景点/关键词优化公司靠谱推荐

一、知识点分享

  LNMP是指一组通常一起使用来运行动态网站或者服务器的自由软件名称首字母缩写。L指Linux，N指Nginx，M一般指MySQL，也可以指MariaDB，P一般指PHP，也可以指Perl或Python。（本文LNMP=Linux+Nginx+Mysql+Php）
  Zabbix是一个基于WEB界面的提供分布式系统监视以及网络监视功能的企业级的开源解决方案。它能监视各种网络参数，保证服务器系统的安全运营；并提供灵活的通知机制以让系统管理员快速定位/解决存在的各种问题。
  Zabbix proxy是一个可以从一个或多个受监控设备采集监控数据并将信息发送到 Zabbix server 的进程，主要是代表 Zabbix server 工作。 所有收集的数据都在本地缓存，然后传输到 proxy 所属的 Zabbix server。简单来说：用来减轻Zabbix server压力。

二、角色&安装包

• mysql-anzhuang-v40.zip

注意：本文采用mysql-5.7.40版本仅供测试（官方要求使用mysql8.0）

三、步骤

1.节点node4操作【node5相同】

a.引入Zabbix源

rpm -Uvh https://repo.zabbix.com/zabbix/6.0/rhel/7/x86_64/zabbix-release-6.0-4.el7.noarch.rpm
yum clean all

b.安装 Zabbix proxy、Zabbix agent

yum install zabbix-proxy-mysql zabbix-sql-scripts zabbix-selinux-policy zabbix-agent
systemctl enable --now zabbix-agent

c. 安装数据库

数据库安装用到的路径/srv/program，如果没有需要手动创建mkdir /srv/program

[root@node-4 soft]# unzip mysql-anzhuang-v40.zip
[root@node-4 soft]# cd mysql-anzhuang
[root@node-4 mysql-anzhuang]# chmod +x mysql-anzhang-ubuntu.sh
[root@node-4 mysql-anzhuang]# ./mysql-anzhang-ubuntu.sh

d. 创建初始数据库

创建数据库、用户、密码

[root@node-4 mysql-anzhuang]# cd /srv/program/mysql-3307/mysql-5.7
[root@node-4 mysql-5.7]# ./startup.sh
[root@node-4 mysql-5.7]# ./bin/mysql -S mysql.sock
mysql> create database zabbix_proxy character set utf8mb4 collate utf8mb4_bin;
mysql> create user zabbix@localhost identified by 'password';
mysql> grant all privileges on zabbix_proxy.* to zabbix@localhost;
mysql> set global log_bin_trust_function_creators = 1;
mysql> quit;

导入初始架构和数据，系统将提示您输入新创建的密码

cat /usr/share/zabbix-sql-scripts/mysql/proxy.sql | mysql --default-character-set=utf8mb4 -h127.0.0.1 -P3307 -uzabbix -p'你设置的密码' zabbix_proxy

导入数据库架构后禁用log_bin_trust_function_creators选项

[root@node-4 mysql-5.7]# ./bin/mysql -S mysql.sock
mysql> set global log_bin_trust_function_creators = 0;
mysql> quit;

e.修改配置

[root@node-4 mysql-5.7]# vim /etc/zabbix/zabbix_proxy.conf
...
Server=192.168.200.153
Hostname=Zabbix proxy1
DBHost=127.0.0.1
DBName=zabbix_proxy
DBUser=zabbix
DBPassword=Csdn@123.
DBPort=3307
AllowUnsupportedDBVersions=1 # 官方要求必须至少为8.0，若要用5.7需要打开此选项进行覆盖

f.启动 Zabbix proxy

[root@node-4 mysql-5.7]# systemctl enable --now  zabbix-proxy
[root@node-4 mysql-5.7]# netstat -ntlupa |grep zabbix

2.节点node3操作

a.引入Zabbix源、安装依赖

rpm -Uvh https://repo.zabbix.com/zabbix/6.0/rhel/7/x86_64/zabbix-release-6.0-4.el7.noarch.rpm
yum clean all
wget https://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpm
yum -y install mysql80-community-release-el7-5.noarch.rpm
yum -y install gcc-c++ mysql-devel net-snmp-devel libevent-devel
yum -y install zabbix-agent

b.编译安装Zabbix server

[root@node-3 soft]# wget https://cdn.zabbix.com/zabbix/sources/stable/6.0/zabbix-6.0.1.tar.gz
[root@node-3 soft]# tar -xvf zabbix-6.0.14.tar.gz -C /srv/program/
[root@node-3 soft]# cd /srv/program/zabbix-6.0.14/
[root@node-3 zabbix-6.0.14]# ./configure --prefix=/srv/program/zabbix --enable-server  --with-net-snmp --with-mysql --with-libcurl --enable-proxy
[root@node-3 zabbix-6.0.14]# make install

编译可能遇到的错误：
1.misc.c:260:2: 错误：只允许在 C99 模式下使用‘for’循环初始化声明
解决方法：根据提示修改对应文件
vim src/libs/zbxeval/misc.c

将int摘出来即可

（此方法所有C99的for循环错误均使用）

2.configure: error: Not found mysqlclient library

cd /usr/lib64/mysql/
ln -s libmysqlclient.so.18.1.0 libmysqlclient.so
ln -s libmysqlclient_r.so.18.1.0 libmysqlclient_r.so

3.configure: error: Curl library not found

yum install curl-devel -y	

c.rpm安装mysql8

[root@node-3 soft]# wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar
[root@node-3 soft]# mkdir /srv/program/mysql8
[root@node-3 soft]# tar -xf mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar -C /srv/program/mysql8/
[root@node-3 soft]# cd /srv/program/mysql8/
[root@node-3 mysql8]# ls
[root@node-3 mysql8]# rpm -ivh mysql-community-common-8.0.31-1.el7.x86_64.rpm --force --nodeps
[root@node-3 mysql8]# rpm -ivh mysql-community-libs-8.0.31-1.el7.x86_64.rpm --force --nodeps
[root@node-3 mysql8]# rpm -ivh mysql-community-libs-compat-8.0.31-1.el7.x86_64.rpm --force --nodeps
[root@node-3 mysql8]# rpm -ivh mysql-community-client-8.0.31-1.el7.x86_64.rpm --force --nodeps
[root@node-3 mysql8]# rpm -ivh mysql-community-server-8.0.31-1.el7.x86_64.rpm --force --nodeps
[root@node-3 mysql8]# systemctl enable --now  mysqld #启动并开机自启
[root@node-3 mysql8]# systemctl status mysqld
[root@node-3 mysql8]# netstat -anptu |grep mysql
[root@node-3 mysql8]# ps -ef |grep mysql
[root@node-3 mysql8]# cat /var/log/mysqld.log |grep password	#查看密码（如图）
[root@node-3 mysql8]# mysql -uroot -p'.S8G4lIkH.Od'
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxx';
mysql> create database zabbix character set utf8 collate utf8_bin;
mysql> CREATE USER 'zabbix'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Csdn@123.';
mysql> grant all privileges on zabbix.* to zabbix@localhost;
mysql> set global log_bin_trust_function_creators = 1;
mysql> quit

导入数据库架构和数据

[root@node-3 mysql8]# mysql --default-character-set=utf8mb4  -uzabbix -p'Csdn@123.' zabbix < /srv/program/zabbix-6.0.14/database/mysql/schema.sql
[root@node-3 mysql8]# mysql --default-character-set=utf8mb4  -uzabbix -p'Csdn@123.' zabbix < /srv/program/zabbix-6.0.14/database/mysql/images.sql
[root@node-3 mysql8]# mysql --default-character-set=utf8mb4  -uzabbix -p'Csdn@123.' zabbix < /srv/program/zabbix-6.0.14/database/mysql/data.sql
# 导入数据库架构后禁用log_bin_trust_function_creators选项
[root@node-3 mysql8]# mysql -uroot -p'xxxxx'
mysql> set global log_bin_trust_function_creators = 0;
mysql> quit;

关于mysql配置文件的优化（可选）:
修改/etc/my.cnf配置文件：

# 自定义Mysql设置 
[mysql]
prompt="\u@jsshapp \R:\m:\s [\d]> "
no-auto-rehash[mysqld]
port = 3307
mysqlx_port = 33070
datadir=/srv/program//mysql-3307/mysql-data
socket=/var/lib/mysql/mysql.sock
pid-file=/var/run/mysqld/mysqld.pid# 优化设置
character-set-server = utf8mb4
skip_name_resolve = 1
#open_files_limit = 65535
back_log = 1024
max_connections = 100
max_connect_errors = 1000000
table_open_cache = 100
table_definition_cache = 400
table_open_cache_instances = 64
thread_stack = 512K
external-locking = FALSE
max_allowed_packet = 32M
sort_buffer_size = 4M
join_buffer_size = 4M
thread_cache_size = 150
#query_cache_size = 0
#query_cache_type = 0
interactive_timeout = 600
wait_timeout = 600
tmp_table_size = 32M
max_heap_table_size = 32M
slow_query_log = 1
slow_query_log_file = /srv/program//mysql-3307/mysql-data/slow.log
log-error = /srv/program//mysql-3307/mysql-data/error.log
long_query_time = 0.1
#server-id = 167
#log-bin = /srv/program/mysql-7777/mysql-data/mybinlog
sync_binlog = 1
binlog_cache_size = 4M
max_binlog_cache_size = 2G
max_binlog_size = 1G
#expire_logs_days = 28
#master_info_repository = TABLE
#relay_log_info_repository = TABLE
gtid_mode = on
enforce_gtid_consistency = 1
#log_slave_updates
log_replica_updates
#binlog_format = row
relay_log_recovery = 1
relay-log-purge = 1
key_buffer_size = 15M
read_buffer_size = 8M
read_rnd_buffer_size = 4M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
# myisam_repair_threads = 1
lock_wait_timeout = 3600
explicit_defaults_for_timestamp = 1
innodb_thread_concurrency = 0
innodb_sync_spin_loops = 100
innodb_spin_wait_delay = 30transaction_isolation = REPEATABLE-READ
#innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 10000M
innodb_buffer_pool_instances = 8
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_data_file_path = ibdata1:1G:autoextend
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 32M
#innodb_log_file_size = 2G
#innodb_log_files_in_group = 2
innodb_redo_log_capacity = 2G
innodb_max_undo_log_size = 4G
innodb_io_capacity = 4000
innodb_io_capacity_max = 8000
innodb_flush_neighbors = 0
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_purge_threads = 4
innodb_page_cleaners = 4
innodb_open_files = 65535
innodb_max_dirty_pages_pct = 50
innodb_flush_method = O_DIRECT
innodb_lru_scan_depth = 4000
innodb_checksum_algorithm = crc32
#innodb_file_format = Barracuda
#innodb_file_format_max = Barracuda
innodb_lock_wait_timeout = 10
innodb_rollback_on_timeout = 1
innodb_print_all_deadlocks = 1
innodb_file_per_table = 1
innodb_online_alter_log_max_size = 4G
#internal_tmp_disk_storage_engine = InnoDB
innodb_stats_on_metadata = 0innodb_status_file = 1
innodb_status_output = 0
innodb_status_output_locks = 0#performance_schema
performance_schema = 1
performance_schema_instrument = '%=on'#innodb monitor
innodb_monitor_enable="module_innodb"
innodb_monitor_enable="module_server"
innodb_monitor_enable="module_dml"
innodb_monitor_enable="module_ddl"
innodb_monitor_enable="module_trx"
innodb_monitor_enable="module_os"
innodb_monitor_enable="module_purge"
innodb_monitor_enable="module_log"
innodb_monitor_enable="module_lock"
innodb_monitor_enable="module_buffer"
innodb_monitor_enable="module_index"
innodb_monitor_enable="module_ibuf_system"
innodb_monitor_enable="module_buffer_page"
innodb_monitor_enable="module_adaptive_hash"## replication
server_id=1111
#binlog-do-db=xcrx_main
binlog-ignore-db=mysql
log-bin=mysql-bin
binlog_cache_size=4M
binlog_format=mixed
#expire_logs_days=7
#slave_skip_errors=1062
replica_skip_errors=1062#从库需开启以下配置
#relay_log=edu-mysql-relay-bin
#log_slave_updates=1
#read_only=1
####NO_AUTO_CREATE_USER 在mysql8中已经剔除
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ER>>ROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
lower_case_table_names = 1
log_timestamps = SYSTEM
max_connections = 3000
max_user_connections = 2000
max_execution_time = 200000[mysqldump]
quick
max_allowed_packet = 32M

d.安装PHP

#安装源
[root@node-3 mysql-3307]#  yum -y install https://rpms.remirepo.net/enterprise/remi-release-7.rpm
#安装插件
[root@node-3 mysql-3307]# yum -y install yum-utils
[root@node-3 mysql-3307]# yum-config-manager --disable 'remi-php*'
[root@node-3 mysql-3307]# yum-config-manager --enable   remi-php74
[root@node-3 mysql-3307]# yum -y install php php-fpm php-bcmath php-gd php-xml  php-mbstring php-mysqlnd php-ldap
[root@node-3 mysql-3307]#  yum -y install curl-devl libxml2 libxml2-devel 
[root@node-3 mysql-3307]# vim /etc/php.ini
...
date.timezone = Asia/Shanghai  #设置时区
max_execution_time = 300 #最大执行时间,秒
post_max_size = 32M #POST数据最大容量
max_input_time = 300 #服务器接收数据的时间限制
...
:wq
[root@node-3 mysql-3307]# systemctl enable  --now php-fpm

e.安装Nginx部署Web页面

[root@node-3 soft]# useradd nginx
[root@node-3 soft]# yum -y install gcc pcre-devel openssl-devel make zlib-devel 
[root@node-3 soft]# tar -xvf  nginx-1.23.2.tar.gz 
[root@node-3 soft]# cd nginx-1.23.2
[root@node-3 nginx-1.23.2]# ./configure  \
--prefix=/srv/program/nginx \
--user=nginx  \
--group=nginx  \
--with-stream \
--with-threads \
--with-http_ssl_module \
--with-http_sub_module  \
--with-http_realip_module \
--with-http_gzip_static_module  \
--with-http_stub_status_module
[root@node-3 nginx-1.23.2]# make -j8 && make install
[root@node-3 soft]#  cp -r /srv/program/zabbix-6.0.14/ui/* /srv/program/nginx/html/
[root@node-3 soft]# chmod -R +777  /srv/program/nginx/html/
[root@node-3 soft]# vim /srv/program/nginx/conf/nginx.conf
...
http {
...location / {root   html;index  index.php index.html index.htm;}
...location ~ \.php$ {root           html;fastcgi_pass   127.0.0.1:9000;fastcgi_index  index.php;fastcgi_buffers 8 16k;         #缓存php生成的页面内容,8个16kfastcgi_buffer_size 32k;       #缓存php生产的头部信息fastcgi_connect_timeout 300;   #链接php的超时时间fastcgi_send_timeout 300;      #发送请求的超时时间fastcgi_read_timeout 300;　　　　#读取请求的超时时间include        fastcgi.conf;} 
...
}
[root@node-3 soft]#cd /srv/program/nginx/sbin && ./nginx -t		# 检查语法

修改zabbix server 配置文件

[root@node-3 ~]# cd /srv/program/zabbix
[root@node-3 zabbix]# vim etc/zabbix_server.conf  #根据自身环境修改
...
DBPassword=Csdn@123.
DBPort=3307
LogFile=/srv/program/zabbix/zabbix_server.log
...
[root@node-3 zabbix]# vim startup.sh
#!/bin/bash
/srv/program/zabbix/sbin/zabbix_server -c /srv/program/zabbix/etc/zabbix_server.conf
[root@node-3 zabbix]# chmod +x startup.sh
[root@node-3 zabbix]# ./startup.sh
[root@node-3 zabbix]# systemctl enable --now zabbix-agent
[root@node-3 zabbix]# cd ../nginx/
[root@node-3 nginx]# ./sbin/nginx

Web Url：http://192.168.200.153:1998（端口根据自己nginx配置文件设置为准）

默认用户名密码：Admin/zabbix

3.加入Zabbix proxy

Zabbix proxy2添加操作同上

“最近出现”一栏开始显示时间说明对接成功

使用Zabbix proxy采集数据


可以看到最新数据已经有数据了

四、结束语

  本次Zabbix监控安装、proxy使用就到此结束了，后期会给大家带来Zabbix更深层次应用例如：自动发现、监控交换机等等，感谢认真读完，如果觉得还可以，那么给作者点赞、收藏、关注吧！