jenkins自动部署mysql_部署SonarQube代码检测服务以及jenkins实现代码自动测试、自动部署...

1.SonarQube部署前的内核参数等配置以及java环境配置

1)修改内核参数配置，使满足环境要求

[root@sonarqube ~]# vim /etc/sysctl.conf

vm.max_map_count=262144

fs.file-max=65536

[root@sonarqube ~]# sysctl -p #生效修改的内核参数

……

vm.max_map_count = 262144

fs.file-max = 65536

2)修改本机安全策略参数限制

[root@sonarqube ~]# vim /etc/security/limits.conf

……

sonarqube - nofile 65536

sonarqube - nproc 2048

3)配置java环境(至少jdk-8或openjdk-8版本)

[root@sonarqube ~]# ls /usr/local/src/

jdk-8u211-linux-x64.tar.gz

[root@sonarqube src]# tar xvf jdk-8u211-linux-x64.tar.gz

[root@sonarqube src]#ln -sv jdk1.8.0_211 jdk

[root@sonarqube src]#ln -sv jdk

[root@sonarqube src]# ln -sv /usr/local/src/jdk/bin/* /usr/bin

[root@sonarqube src]# vim /etc/profile

……

export export LANG="en_US.utf-8"

export JAVA_HOME=/usr/local/jdk

export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH

export CLASSPATH=$JAVA_HOME/lib:$JAVA_HOME/jre/lib:$JAVA_HOME/lib/tools.jar

[root@sonarqube src]# source /etc/profile #将java环境变量生效

2.数据库准备(sonarqube7.9版本不再支持mysql，以sonarqube6.7为例，并要求至少mysql5.6以上，这里使用mysql5.7版本)

1)官网下载mysql社区版配置yum源仓库的rpm包(下载前需要注册oracle账号)

https://dev.mysql.com/downloads/repo/yum/

2)安装mysql的yum仓库源

[root@sonarqube mysql.repos]# ls

mysql80-community-release-el7-3.noarch.rpm

[root@sonarqube mysql.repos]# rpm -ivh mysql80-community-release-el7-3.noarch.rpm

warning: mysql80-community-release-el7-3.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... ################################# [100%]

Updating / installing...

1:mysql80-community-release-el7-3 ################################# [100%]

3)查看安装的yum仓库源

root@sonarqube yum.repos.d]# ls

CentOS-Base.repo epel.repo mysql-community.repo mysql-community-source.repo

4)查看yum子仓库中被禁用的和启用的mysql版本，默认最新版 MySQL 8.0是开启的(yum安装时也是默认最新版)，其他版本默认禁用

[root@sonarqube yum.repos.d]# yum repolist all | grep mysql

mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community disabled

mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - disabled

mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community disabled

mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community - disabled

mysql-cluster-8.0-community/x86_64 MySQL Cluster 8.0 Community disabled

mysql-cluster-8.0-community-source MySQL Cluster 8.0 Community - disabled

mysql-connectors-community/x86_64 MySQL Connectors Community enabled: 118

mysql-connectors-community-source MySQL Connectors Community - disabled

mysql-tools-community/x86_64 MySQL Tools Community enabled: 95

mysql-tools-community-source MySQL Tools Community - Sourc disabled

mysql-tools-preview/x86_64 MySQL Tools Preview disabled

mysql-tools-preview-source MySQL Tools Preview - Source disabled

mysql55-community/x86_64 MySQL 5.5 Community Server disabled

mysql55-community-source MySQL 5.5 Community Server - disabled

mysql56-community/x86_64 MySQL 5.6 Community Server disabled

mysql56-community-source MySQL 5.6 Community Server - disabled

mysql57-community/x86_64 MySQL 5.7 Community Server disabled

mysql57-community-source MySQL 5.7 Community Server - disabled

mysql80-community/x86_64 MySQL 8.0 Community Server enabled: 129

mysql80-community-source MySQL 8.0 Community Server - disabled

5)yum-config-manager命令依赖于yum-utils.noarch包

[root@sonarqube yum.repos.d]# yum install yum-utils.noarch

6)下载mysql-5.7版本，则需启用子仓库的mysql-5.7版本，并将 MySQL 8.0版子仓库禁用，让yum安装默认下载5.7版本

[root@sonarqube yum.repos.d]# yum-config-manager --enable mysql57-community

[root@sonarqube yum.repos.d]# yum-config-manager --disable mysql80-community

7)再次查看子仓库源，发现mysql-5.7版本子仓库源已启用