版权声明:欢迎转载与交流。https://blog.csdn.net/one2more/article/details/115317437
(二)LNMP环境源码编译安装zabbix-4.0.x——编译安装MySQL
1、软件包列表
序号 | 软件包名称 | 下载地址 |
---|---|---|
01 | boost_1_59_0.tar.gz | https://sourceforge.net/projects/boost/files/boost/1.59.0/ |
02 | mysql-5.7.32.tar.gz | https://downloads.mysql.com/archives/community/ |
2、解压相关软件包
tar -xzf /usr/local/src/boost_1_59_0.tar.gz -C /usr/local/src
tar -xzf /usr/local/src/mysql-5.7.32.tar.gz -C /usr/local/src/
3、安装相关依赖包
yum install -y cmake bison bison-devel ncurses ncurses-devel openssl openssl-devel curl curl-devel
4、编译安装MySQL
cd /usr/local/src/mysql-5.7.32
# 添加mysql组
groupadd mysql
# 创建mysql用户
useradd -M -s /sbin/nologin -r -g mysql mysql
# 安装目录: /opt/mysql
# 数据目录: /opt/mysql/data
# 创建mysql相关目录并修改权限
mkdir -p /opt/mysql/{data,logs,etc}
chown -R mysql:mysql /opt/mysql/{data,logs,etc}
## cmake
cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql \
-DMYSQL_DATADIR=/opt/mysql/data \
-DSYSCONFDIR=/opt/mysql/etc \
-DINSTALL_SCRIPTDIR=/opt/mysql/sbin \
-DSYSTEMD_PID_DIR=/opt/mysql \
-DINSTALL_MYSQLTESTDIR= \
-DWITH_SYSTEMD=on \
-DSYSTEMD_SERVICE_NAME=mysqld \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/opt/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/usr/local/src/boost_1_59_0 \
-DWITH_CURL=system \
-DWITH_SSL=system \
-DWITH_ZLIB=/usr/local/src/zlib-1.2.11
## make && make install
make && make install
5、配置MySQL
# 编辑my.cnf
cat > /opt/mysql/etc/my.cnf <<-EOF
[mysqld]
user = mysql
basedir=/opt/mysql
datadir=/opt/mysql/data
port=3306
socket=/opt/mysql/mysql.sock
pid-file=/opt/mysql/mysqld.pid
character-set-server=utf8
default_storage_engine=InnoDB
log-error=/opt/mysql/logs/mysqld.log
slow_query_log=1
long_query_time=1
slow_query_log_file=/opt/mysql/logs/mysql-slow.log
[mysql]
socket=/opt/mysql/mysql.sock
[client]
socket=/opt/mysql/mysql.sock
EOF
# 配置mysql环境变量
cat > /etc/profile.d/mysql.sh <<-EOF
export PATH=/opt/mysql/bin:\$PATH
EOF
# 使环境变量生效
source /etc/profile.d/mysql.sh
# 链接libmysqlclient.so库,否则启动Zabbix-Server时会报错
cp -f /opt/mysql/lib/libmysqlclient.so.20 /usr/lib64/
# 初始化MySQL数据
/opt/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data
# 更改相关文件权限
chown -R mysql:mysql /opt/mysql
# 配置systemd管理MySQL
cp /opt/mysql/usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/
systemctl daemon-reload
systemctl start mysqld
systemctl status mysqld
systemctl enable mysqld
用文字分享技术,记录成长! 持续更新中! 欢迎留言、评论交流!