umount /mnt/cdrom/

 umount /mnt/cdrom/ -f 

yum install tcl

./xfs_undelete 2021-03-01 /dev/mapper/centos-data

[mysqldump]
socket=/tmp/mysql.scok
host=127.0.0.1
user=root
password='这里填写你的数据库密码'

#!/bin/bash
DUMP='/usr/local/mysql/bin/mysqldump' #这个路径是mysqldump的路径可以通过 whereis mysqldump 查询
EXTRA_FILE='--defaults-extra-file=/etc/my.cnf' #数据库被指文件路径
BAKUP_DIR="/home/zhdj/sqlback" #备份文件存储路径
 
##bakup test01
$DUMP $EXTRA_FILE sheyangparty > $BAKUP_DIR/sheyangpartyBackUp_$(date +%y%m%d).sql
 
 
##remove history bakup files 10 days ago
cd $BAKUP_DIR/ ; -mtime +10 -exec rm -rf {} \;
echo "remove success"

crontab -e

00 23 * * * /home/backup/bkDatabaseName.sh #文件路径

nginx -V #大写的V将会输出nginx安装的模块以及版本号

yum list nginx #查看yum包
yum install  *** #nginx version: nginx/1.12.1 版本

#load_module /usr/lib64/nginx/modules/ngx_stream_module.so;;
# For more information on configuration, see:
#   * Official English Documentation: http://nginx.org/en/docs/
#   * Official Russian Documentation: http://nginx.org/ru/docs/

user nginx;
worker_processes auto;
error_log /var/log/nginx/error.log;
pid /run/nginx.pid;

# Load dynamic modules. See /usr/share/doc/nginx/README.dynamic.
include /usr/share/nginx/modules/*.conf;

events { 
#   use epoll;
    worker_connections  1024;
}

 stream {
   upstream cloudsocket {
       hash $remote_addr consistent;
       server 10.1.10.245:3306 weight=5 max_fails=3 fail_timeout=30s;
   }  
      server {
      listen 3306;#数据库服务器监听端口
      proxy_connect_timeout 10s;
      proxy_timeout 300s;#设置客户端和代理服务之间的超时时间，如果5分钟内没操作将自动断开。
      proxy_pass cloudsocket;
    }
 }
http {
    log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                      '$status $body_bytes_sent "$http_referer" '
                      '"$http_user_agent" "$http_x_forwarded_for"';

    access_log  /var/log/nginx/access.log  main;

    sendfile            on;
    tcp_nopush          on;
    tcp_nodelay         on;
    keepalive_timeout   65;
    types_hash_max_size 4096;
    client_max_body_size 300m;	
    include             mime.types;
    default_type        application/octet-stream;
    # Load modular configuration files from the /etc/nginx/conf.d directory.
    # See http://nginx.org/en/docs/ngx_core_module.html#include
    # for more information.
    include /etc/nginx/conf.d/*.conf;

    
    server {
        listen       80 default_server;
        listen       [::]:80 default_server;
        server_name  zhdj.yhdjw.gov.cn:680;
        root         /opt/web;

        # Load configuration files for the default server block.
        include /etc/nginx/default.d/*.conf;

	location /service {
               proxy_pass http://127.0.0.1:38080/datawells-admin;
        }
        location /service1 {
	      proxy_pass http://127.0.0.1:38080/datawells-appAdmin;
	}
	 location /develop {
              proxy_pass http://127.0.0.1:8280;
        }
	 location /testAdmin {
              proxy_pass http://127.0.0.1:8903;
        }
	 location /testApp {
              proxy_pass http://127.0.0.1:8180;
        }

        #location /minio {
	#	proxy_pass http://127.0.0.1:9000;
        #}

	location /nacos {
                proxy_pass http://127.0.0.1:8848;
        }

	#location / {
        #	port_in_redirect on;
        #	proxy_redirect off;
        #	proxy_pass http://rabbitbackend;
        #	proxy_set_header X-Real-IP $remote_addr;
        #	proxy_set_header User-Agent $http_user_agent;
        #	proxy_set_header Host $http_host;
        #	proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
	#	proxy_set_header X-Forwarded-Proto $scheme;
	#}

	#location ~* /rabbitmq/api/ {
	#	rewrite ^ $request_uri;
        #	rewrite ^/rabbitmq/api/(.*) /api/$1 break;
       	#	return 400;
        #	proxy_pass http://rabbitbackend$uri;
        #	proxy_buffering                    off;
        #	proxy_set_header Host              $http_host;
        #	proxy_set_header X-Real-IP         $remote_addr;
        #	proxy_set_header X-Forwarded-For   $proxy_add_x_forwarded_for;
        #	proxy_set_header X-Forwarded-Proto $scheme;
	#}

        error_page 404 /404.html;
        location = /404.html {
        }

        error_page 500 502 503 504 /50x.html;
        location = /50x.html {
        }
    }
        server {
        listen       443 ssl;
        #listen       443 ssl http2 default_server;
        #listen       [::]:443 ssl http2 default_server;
        server_name  zhdj.yhdjw.gov.cn:6443;
        root         /opt/web;

        ssl_certificate "/etc/nginx/cert/5667995_zhdj.yhdjw.gov.cn.pem";
        ssl_certificate_key "/etc/nginx/cert/5667995_zhdj.yhdjw.gov.cn.key";
        
	ssl_session_timeout 5m;
    	ssl_ciphers ECDHE-RSA-AES128-GCM-SHA256:ECDHE:ECDH:AES:HIGH:!NULL:!aNULL:!MD5:!ADH:!RC4;
    	#表示使用的加密套件的类型。
    	ssl_protocols TLSv1 TLSv1.1 TLSv1.2; #表示使用的TLS协议的类型。
    	ssl_prefer_server_ciphers on;
	#ssl_session_cache shared:SSL:1m;
        #ssl_session_timeout  10m;
        #ssl_ciphers HIGH:!aNULL:!MD5;
        #ssl_prefer_server_ciphers on;

        # Load configuration files for the default server block.
        include /etc/nginx/default.d/*.conf;

	location /service {
               proxy_pass http://127.0.0.1:38080/datawells-admin;
        }
        location /service1 {
	      proxy_pass http://127.0.0.1:38080/datawells-appAdmin;
	}
	  location /develop {
              proxy_pass http://127.0.0.1:28080/datawells-appAdmin-ex;
        }

        #location /minio {
	#	proxy_pass http://127.0.0.1:9000;
        #}

	location /nacos {
                proxy_pass http://127.0.0.1:8848;
        }


        error_page 404 /404.html;
        location = /404.html {
        }

        error_page 500 502 503 504 /50x.html;
        location = /50x.html {
        }
    }

# Settings for a TLS enabled server.
#
#    server {
#        listen       443 ssl http2;
#        listen       [::]:443 ssl http2;
#        server_name  _;
#        root         /usr/share/nginx/html;
#
#        ssl_certificate "/etc/pki/nginx/server.crt";
#        ssl_certificate_key "/etc/pki/nginx/private/server.key";
#        ssl_session_cache shared:SSL:1m;
#        ssl_session_timeout  10m;
#        ssl_ciphers HIGH:!aNULL:!MD5;
#        ssl_prefer_server_ciphers on;
#
#        # Load configuration files for the default server block.
#        include /etc/nginx/default.d/*.conf;
#
#        error_page 404 /404.html;
#            location = /40x.html {
#        }
#
#        error_page 500 502 503 504 /50x.html;
#            location = /50x.html {
#        }
#    }

}

stream {
   upstream cloudsocket {
       hash $remote_addr consistent;
       server 10.1.10.245:3306 weight=5 max_fails=3 fail_timeout=30s;
   }  
      server {
      listen 3306;#数据库服务器监听端口
      proxy_connect_timeout 10s;
      proxy_timeout 300s;#设置客户端和代理服务之间的超时时间，如果5分钟内没操作将自动断开。
      proxy_pass cloudsocket;
    }
 }

yum install -y epel-release

sysbench ./tests/include/oltp_legacy/oltp.lua ``--mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root  --mysql-db=testdb  --mysql-password=Spton123\!\@\# --oltp-test-mode=complex --oltp-table-size=30000000  --num-threads=100 --mysql-socket=/tmp/mysql.sock  run  >> /home/zhdj/mysysbench20210912.log