mysql5.7_sourcecode_install_onOEL7.2_managedbysystemd
1 描述
OEL7.2 x64默认使用最小化安装。 在此基础上安装MySQL 5.7.22 source code.
十多年的大英网站建设经验，针对设计、前端、开发、售后、文案、推广等六对一服务，响应快，48小时及时工作处理。网络营销推广的优势是能够根据用户设备显示端的尺寸不同，自动调整大英建站的显示方式，使网站能够适用不同显示终端，在浏览器中调整网站的宽度，无论在任何一种浏览器上浏览网站，都能展现优雅布局与设计，从而大程度地提升浏览体验。创新互联从事“大英网站设计”,“大英网站推广”以来，每个客户项目都认真落实执行。
(mysql-8.0.11 cmake要用的版本至少为2.8.12,而OEL7.2 cmake版本为2.8.11,如需用光盘中的cmake，需要升级系统版本)
mysql服务启动关闭由systemd来管理，编译时启用参数-DWITH_SYSTEMD=1
2 操作环境
2.1 OS info
OEL7.2 x64
2.2 Other
必备软件包：
cmake
make
gcc-c++
boost(You
can download it when execute cmake with -DDOWNLOAD_BOOST=1
-DWITH_BOOST=
ncurses-devel
perl
bison
3 过程设计
shell>yum -q -y install cmake make gcc-c++ ncurses-devel perl bison
# Preconfiguration setup
shell> groupadd mysql
shell> useradd -r -g mysql -s /bin/false mysql
# Beginning of source-build specific instructions
shell> tar zxvf mysql-VERSION.tar.gz
shell> cd mysql-VERSION
shell> mkdir bld
shell> cd bld
##### shell> cmake .. -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/
##### shell> cmake .. -DWITH_BOOST=/usr/local/boost_1_59_0
shell> cmake .. -DWITH_BOOST=/usr/local/boost_1_59_0-DWITH_SYSTEMD=1
shell> make -j 4
shell> make install
# End of source-build specific instructions
# Postinstallation setup
shell> cd /usr/local/mysql
shell> bin/mysqld --initialize --user=mysql
##### shell> bin/mysql_install_db --user=mysql --basedir=/opt/mysql/mysql --datadir=/opt/mysql/mysql/data
shell> cp /usr/local/mysql/usr/lib/systemd/system/mysqld* /usr/lib/systemd/system/
shell>systemctl daemon-reload
shell>systemctl enable mysqld.service
shell>mkdir /var/run/mysqld/
shell>chown mysql:mysql /var/run/mysqld/
shell>systemctl restart mysqld.service
4 详细步骤操作
shell> cmake .. -DWITH_BOOST=/usr/local/boost_1_59_0-DWITH_SYSTEMD=1
安装编译过程略
# Postinstallation setup
[root@localhost bld]# cd /usr/local/mysql/
[root@localhost mysql]# bin/mysqld --initialize --user=mysql
2018-05-02T19:06:52.849013Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-02T19:06:56.156730Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-05-02T19:06:56.428913Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-05-02T19:06:56.531465Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: fb8f5e7d-4e3b-11e8-bd58-000c29a3197b.
2018-05-02T19:06:56.540768Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-05-02T19:06:56.542462Z 1 [Note] A temporary password is generated for root@localhost: 4E-d,-hnvhtk
[root@localhost mysql]# bin/mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[root@localhost mysql]# cp /usr/local/mysql/usr/lib/systemd/system/mysqld* /usr/lib/systemd/system/
[root@localhost mysql]# systemctl daemon-reload
[root@localhost mysql]# systemctl enable mysqld.service
Created symlink from /etc/systemd/system/multi-user.target.wants/mysqld.service to /usr/lib/systemd/system/mysqld.service.
[root@localhost mysql]# mkdir /var/run/mysqld/
[root@localhost mysql]# chown -R mysql /var/run/mysqld/
[root@localhost mysql]# systemctl restart mysqld.service
[root@localhost mysql]# bin/mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
[root@localhost mysql]# ps -ef |grep mysql
mysql 21993 1 0 03:10 ? 00:00:00 /usr/local/mysql/bin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
root 22024 2427 0 03:14 pts/0 00:00:00 grep --color=auto mysql
[root@localhost mysql]# systemctl stop mysqld.service
5 个人总结
a．make -j
-j [N], --jobs[=N] Allow N jobs at once; infinite jobs with no arg.
我没有在-j后面加数字限制job数。结果编译两次都导致系统报outofmemory错误。数值与cpu个数等值效果最好。
b．cmake编译时可选的参数，请参考https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
c.如系统已经连接外网,boost可以在cmake的时候打开下载参数-DDOWNLOAD_BOOST=1
d．systemd调用文件
cmake时启用了systemd参数 -DWITH_SYSTEMD=1 ， 则会生成相应的可以由systemd调用的mysqld.service文件。文件内容如下:
[root@localhost system]# ls /usr/local/mysql/usr/lib/systemd/system/
mysqld.service mysqld@.service
[root@localhost system]# grep -v ^# mysqld.service |grep -v ^$
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
Type=forking
PIDFile=/var/run/mysqld/mysqld.pid
TimeoutSec=0
PermissionsStartOnly=true
ExecStartPre=/usr/local/mysql/bin/mysqld_pre_systemd
ExecStart=/usr/local/mysql/bin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS
EnvironmentFile=-/etc/sysconfig/mysql
LimitNOFILE = 5000
Restart=on-failure
RestartPreventExitStatus=1
PrivateTmp=false
[root@localhost system]# grep -v ^# mysqld@.service |grep -v ^$
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
Type=forking
PIDFile=/var/run/mysqld/mysqld-%i.pid
TimeoutSec=0
PermissionsStartOnly=true
ExecStartPre=/usr/local/mysql/bin/mysqld_pre_systemd %I
ExecStart=/usr/local/mysql/bin/mysqld --defaults-group-suffix=@%I --daemonize --pid-file=/var/run/mysqld/mysqld-%i.pid $MYSQLD_OPTS
EnvironmentFile=-/etc/sysconfig/mysql
LimitNOFILE = 5000
Restart=on-failure
RestartPreventExitStatus=1
PrivateTmp=false
[root@localhost system]#
将mysqld.service与mysqld@.service copy到操作系统/usr/lib/systemd/system/目录中，然后reload daemon。
注意pid-file的目录/var/run/mysqld/需要存在且目录权限为mysql，否则会启动报错。系统重启后/var/run/mysqld目录会自动消失，建议将pid-file文件放置在mysql用户长久目录下。
6 资料参考引用
https://dev.mysql.com/doc/refman/5.7/en/source-installation.html
https://dev.mysql.com/doc/refman/5.7/en/using-systemd.html
当前名称：mysql5.7_sourcecode_install_onOEL7.2_managedbysystemd
当前链接：http://shouzuofang.com/article/jsgcho.html