groupadd mysql
useradd -g mysql mysql -s /sbin/nologin

wget http://devops-files.oss-cn-qingdao.aliyuncs.com/mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz
tar -zxvf mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
ln -s /usr/local/mysql-5.7.23-linux-glibc2.12-x86_64 /usr/local/mysql

mkdir -p /data/mysql
chown -R mysql:mysql /usr/local/mysql
chown -R mysql:mysql /data/mysql

/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --user=mysql --initialize
/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql 2>&1> /dev/null &

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

cd /usr/local/mysql/bin
cp mysql mysqladmin mysqlbinlog mysqld mysqld_safe mysqldump /usr/bin/

vi /usr/local/mysql/support-files/mysql.server # mysqld_pid_file_path=/data/mysql/mysql.pid
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
chkconfig --list

/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --defaults-file=/etc/my.cnf --user=mysql

$ /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql 2>&1 > /dev/null &

$ /etc/init.d/mysqld stop

$ mysqladmin -u'xx' -p'xx' shutdown

$ systemctl stop mysqld
$ service mysqld stop

$ /etc/init.d/mysqld start

$ mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &

$ systemctl start mysqld
$ service mysqld start

#!/bin/bash

# ###########################################################################
# MySQL安装包名字为mysql-5.7.23-el7-x86_64.tar.gz，位置放在/usr/local/
# ###########################################################################

cmd=$2    # start or stop or status or install
inst=$4

service_startup_timeout=30

log_failure_msg() {
    echo " ERROR! $@"
}

log_success_msg() {
    echo " SUCCESS! $@"
}

case `echo "testing\c"`,`echo -n testing` in
    *c*,-n*) echo_n=   echo_c=     ;;
    *c*,*)   echo_n=-n echo_c=     ;;
    *)       echo_n=   echo_c='\c' ;;
esac

wait_for_pid () {
  verb="$1"           # created | removed
  pid="$2"            # process ID of the program operating on the pid-file
  pid_file_path="$3"  # path to the PID file.

  i=0
  avoid_race_condition="by checking again"

  while test $i -ne $service_startup_timeout ; do

    case "$verb" in
      'created')
        # wait for a PID-file to pop into existence.
        test -s "$pid_file_path" && i='' && break
        ;;
      'removed')
        # wait for this PID-file to disappear
        test ! -s "$pid_file_path" && i='' && break
        ;;
      *)
        echo "wait_for_pid () usage: wait_for_pid created|removed pid pid_file_path"
        exit 1
        ;;
    esac

    if test -n "$pid"; then
      if kill -0 "$pid" 2>/dev/null; then
        :
      else
        if test -n "$avoid_race_condition"; then
          avoid_race_condition=""
          continue
        fi

        log_failure_msg "The server quit without updating PID file ($pid_file_path)."
        return 1
      fi
    fi

    echo $echo_n ".$echo_c"
    i=`expr $i + 1`
    sleep 1

  done

  if test -z "$i" ; then
    log_success_msg
    return 0
  else
    log_failure_msg
    return 1
  fi
}

# ############################################################################################
# 支持MySQL版本：5.6/5.7，CentOS 6系统建议安装MySQL 5.6版本；CentOS 7系统建议安装MySQL 5.7版本
# 支持MySQL模式：单机/主从
# #############################################################################################

install_mysql() {

    echo $echo_n "Installing MySQL..."

    local basedir="/usr/local/mysql"
    local datadir="/data/mysql"
    local defaults_file="/etc/my.cnf"
    local sock_file="$datadir/mysql.sock"
    local pid_file="$datadir/mysql.pid"
    local array=(${inst//@/ })
    local port=${array[1]}

    # 创建MySQL用户，指定MySQL所在的用户组
    groupadd mysql >/dev/null 2>&1
    useradd -g mysql mysql -s /sbin/nologin >/dev/null 2>&1

    # 解压MySQL软件包，并对mysql目录授权
    cd /usr/local
    tar -zxvf mysql-5.7.23-el7-x86_64.tar.gz >/dev/null 2>&1
    ln -s mysql-5.7.23-el7-x86_64 mysql
    chown mysql:mysql -R mysql
    chown mysql:mysql -R mysql-5.7.23-el7-x86_64

    # 创建数据目录
    mkdir -p $datadir
    chown mysql:mysql -R $datadir

    # 初始化数据库
    cd /usr/local/mysql/bin
    ./mysqld --defaults-file="$defaults_file" --basedir="$basedir" --datadir="$datadir" --user=mysql --initialize-insecure >/dev/null 2>&1

    # 启动数据库
    ./mysqld_safe --defaults-file="$defaults_file" --pid-file="$pid_file" --user=mysql >/dev/null &
    wait_for_pid created "$!" "$pid_file"; return_value=$?

    # 打开防火墙端口
    firewall-cmd --permanent --zone=public --add-port=3306/tcp >/dev/null 2>&1
    firewall-cmd --reload >/dev/null 2>&1

    cp mysql* /usr/bin >/dev/null 2>&1
    # mv /usr/local/mysql_tool /usr/bin >/dev/null 2>&1
    mysql -S $sock_file mysql -e "SET PASSWORD = 'xx';ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;flush privileges;"
    mysql -S $sock_file mysql -e "SET PASSWORD = 'xx';ALTER USER 'hdm'@'%' PASSWORD EXPIRE NEVER;flush privileges;"
    mysql -S $sock_file mysql -e "SET PASSWORD = 'xx';ALTER USER 'sre'@'%' PASSWORD EXPIRE NEVER;flush privileges;"
    exit $return_value
}

case "$cmd" in
    'install') install_mysql ;;
    'uninstall') mysql_uninstall ;;
    'start') mysql_start ;;
    'stop') mysql_stop ;;
    'restart') mysql_restart ;;
    'config') mysql_config ;;
    'monitor') mysql_monitor ;;
*)
    # usage
    basename=`basename "$0"`
    echo "Usage: $basename -cmd {start|stop|restart|install|uninstall|status|monitor} -inst {instance name} [ MySQL tool options ]"
    exit 1
    ;;
esac
exit 0

$ ssh -p 2222 01510886@10.138.16.192

$ ps -ef | grep mysqld
root      64511  64440  0 10:27 pts/2    00:00:00 grep --color=auto mysqld
root      79355      1  0 Aug31 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/data/mysql/mysql.pid
mysql     79981  79355 99 Aug31 ?        2-01:38:14 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/error.log --pid-file=/data/mysql/mysql.pid --socket=/data/mysql/mysql.sock --port=3306

$ mysql -S /data/mysql/mysql.sock -usre -p'sre@@p$i'
mysql> show processlist;

$ cd /etc/init.d
$ ./mysqld stop/start

$ cd /usr/local/mysql/support-files
$ ./mysql.server stop/start

[root@hop02 mzjh]# ll | grep mysql-bin
-rw-rw----. 1 mysql mysql  1073742013 Sep 12 14:55 mysql-bin.001948
-rw-rw----. 1 mysql mysql  1073742073 Sep 13 11:53 mysql-bin.001949
-rw-rw----. 1 mysql mysql  1073742120 Sep 14 08:39 mysql-bin.001950
-rw-rw----. 1 mysql mysql  1073859355 Sep 15 06:21 mysql-bin.001951
-rw-rw----. 1 mysql mysql  1074054892 Sep 16 06:18 mysql-bin.001952
-rw-rw----. 1 mysql mysql  1075243641 Sep 17 06:18 mysql-bin.001953
-rw-rw----. 1 mysql mysql  1074801420 Sep 18 06:16 mysql-bin.001954
-rw-rw----. 1 mysql mysql  1075257243 Sep 19 06:16 mysql-bin.001955
-rw-rw----. 1 mysql mysql   619405162 Sep 19 13:32 mysql-bin.001956
-rw-rw----. 1 mysql mysql  1072898197 Sep 20 09:44 mysql-bin.001957
-rw-r-----. 1 mysql mysql         190 Sep 19 13:32 mysql-bin.index

curl -s https://packagecloud.io/install/repositories/akopytov/sysbench/script.rpm.sh | sudo bash
sudo yum -y install sysbench

$ vue init webpack vue-test

? Project name (vue-test)
? Project name vue-test
? Project description (A Vue.js project)
? Project description A Vue.js project
? Author (raohui <raohui@haier.com>)
? Author raohui <raohui@haier.com>
? Vue build standalone
? Install vue-router? (Y/n) Y
? Install vue-router? Yes
? Use ESLint to lint your code? (Y/n) n
? Use ESLint to lint your code? No
? Set up unit tests (Y/n) n
? Set up unit tests No
? Setup e2e tests with Nightwatch? (Y/n) n
? Setup e2e tests with Nightwatch? No
? Should we run `npm install` for you after the project has been created? (recom
? Should we run `npm install` for you after the project has been created? (recom
mended) npm

   vue-cli · Generated "vue-test".


# Installing project dependencies ...
# ========================

npm WARN deprecated extract-text-webpack-plugin@3.0.2: Deprecated. Please use https://github.com/webpack-contrib/mini-css-extract-plugin
npm WARN deprecated browserslist@2.11.3: Browserslist 2 could fail on reading Browserslist >3.0 config used in other tools.
npm WARN deprecated bfj-node4@5.3.1: Switch to the `bfj` package for fixes and new features!
npm WARN deprecated flatten@1.0.2: I wrote this module a very long time ago; you should use something else.
npm WARN deprecated browserslist@1.7.7: Browserslist 2 could fail on reading Browserslist >3.0 config used in other tools.

> core-js@2.6.9 postinstall D:\vue\vue-test\node_modules\core-js
> node scripts/postinstall || echo "ignore"

Thank you for using core-js ( https://github.com/zloirock/core-js ) for polyfilling JavaScript standard library!

The project needs your help! Please consider supporting of core-js on Open Collective or Patreon:
> https://opencollective.com/core-js
> https://www.patreon.com/zloirock

Also, the author of core-js ( https://github.com/zloirock ) is looking for a good job -)

> uglifyjs-webpack-plugin@0.4.6 postinstall D:\vue\vue-test\node_modules\webpack\node_modules\uglifyjs-webpack-plugin
> node lib/post_install.js

npm notice created a lockfile as package-lock.json. You should commit this file.
npm WARN ajv-keywords@3.4.1 requires a peer of ajv@^6.9.1 but none is installed. You must install peer dependencies yourself.
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: fsevents@1.2.9 (node_modules\fsevents):
npm WARN notsup SKIPPING OPTIONAL DEPENDENCY: Unsupported platform for fsevents@1.2.9: wanted {"os":"darwin","arch":"any"} (current: {"os":"win32","arch":"x64"})

added 1208 packages from 669 contributors and audited 11766 packages in 196.113s
found 10 vulnerabilities (6 moderate, 4 high)
  run `npm audit fix` to fix them, or `npm audit` for details

# Project initialization finished!
# ========================

To get started:

  cd vue-test
  npm run dev

Documentation can be found at https://vuejs-templates.github.io/webpack

tips:
npm install -g npm （升级npm至最新版本）
npm cache clean --force  (出现报错可清除缓存)

$ cd vue-test
$ npm run dev

> vue-test@1.0.0 dev D:\vue\vue-test
> webpack-dev-server --inline --progress --config build/webpack.dev.conf.js

 13% building modules 26/33 modules 7 active ...ue-test\src\components\HelloWorld.vue{ parser: "babylon" } is deprecated; we now treat it as { parser: "babel" }.
 95% emitting DONE  Compiled successfully in 11954ms14:06:01

 I  Your application is running here: http://localhost:8080

# /bin/bash

if [ $(id -u) != "0" ]; then
errorLog "错误：请用root账户运行此脚本"
exit 1
fi
echo "提升权限..."
if [[ ! `cat /etc/sudoers | grep -v grep | grep haieradmin` ]] ; then
    echo "需要提升权限。。。"
    sed -i '/## Allow root to run any commands anywhere / a\haieradmin ALL=(ALL) NOPASSWD:ALL' /etc/sudoers
    if [[ ! `cat /etc/sudoers | grep -v grep | grep haieradmin` ]] ; then
        echo "权限提升失败..."
    else
        echo "权限提升成功..."
    fi
else
    echo "haieradmin已经是sudoers"
fi

echo "开启22端口访问..."
firewall-cmd --permanent --zone=public --add-port=22/tcp
firewall-cmd --reload

echo "删除hosts.deny..."
sed -i 's/sshd:all/ /g' /etc/hosts.deny

echo "追加hosts.allow..."
if [[ `cat /etc/hosts.allow | grep -v 10.138.*.*` ]]; then
    echo "追加10.138.*.*"
    echo "sshd:10.138.*.*" >> /etc/hosts.allow
fi

mysql -h <host> -P <port> -u <user> -p <password>

$ wget http://devops-files.oss-cn-qingdao.aliyuncs.com/percona-toolkit-3.0.13-el7-x86_64-bundle.tar
$ tar xvf percona-toolkit-3.0.13-el7-x86_64-bundle.tar
$ rpm -ivh percona-toolkit-3.0.13-1.el7.x86_64.rpm

warning: percona-toolkit-3.0.13-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY
error: Failed dependencies:
	perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-3.0.13-1.el7.x86_64
	perl(IO::Socket::SSL) is needed by percona-toolkit-3.0.13-1.el7.x86_64
	perl(Digest::MD5) is needed by percona-toolkit-3.0.13-1.el7.x86_64
	perl(Time::HiRes) is needed by percona-toolkit-3.0.13-1.el7.x86_64
	perl(Term::ReadKey) is needed by percona-toolkit-3.0.13-1.el7.x86_64

$ yum -y install perl-DBD-MySQL
$ yum -y install perl-Digest-MD5
$ yum -y install perl-IO-Socket-SSL
$ yum -y install perl-TermReadKey
$ yum -y install perl-Time-HiRes
$ rpm -ivh percona-toolkit-3.0.13-1.el7.x86_64.rpm

$ pt-archiver --help
Usage: pt-archiver [OPTIONS] --source DSN --where WHERE

脏页率计算公式：innodb_buffer_pool_pages_dirty / innodb_buffer_pool_pages_data * 100%
使用率计算公式：innodb_buffer_pool_pages_data / ( innodb_buffer_pool_pages_data + innodb_buffer_pool_pages_free ) * 100%

# 默认值
innodb_buffer_pool_size 默认值为128M
innodb_buffer_pool_instances 默认值为1
innodb_buffer_pool_chunk_size 默认值为128M

# 计算公式
innodb_buffer_pool_size = innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances * N

# 总缓存大小
select @@innodb_buffer_pool_size/1024/1024;

# 缓存池数量
select @@innodb_buffer_pool_instances;

# 每个缓存池的大小
select @@innodb_buffer_pool_chunk_size/1024/1024;

set global innodb_buffer_pool_size = size_in_bytes;
select @@innodb_buffer_pool_size/1024/1024;
+-------------------------------------+
| @@innodb_buffer_pool_size/1024/1024 |
+-------------------------------------+
|                        128.00000000 |
+-------------------------------------+

Tips:
① innodb_buffer_pool_size 在线修改时，用户的请求将会阻塞，需要在业务低峰期和没有大事务操作时候进行
② 同时要修改配置文件 my.cnf，防止重启后恢复到原来的值

[mysqld]
innodb_buffer_pool_size  = 20480M