vlambda博客
学习文章列表

CREATE TABLE `short_link` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_key` (`key`), KEY `idx_created_at` (`created_at`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ROW_FORMAT=DYNAMIC COMMENT='短链接';

local host = os.getenv("APP_URL")local db_host = os.getenv("DATABASE_HOST")local db_port = os.getenv("DATABASE_PORT")local db_database = os.getenv("DATABASE")local db_user = os.getenv("DATABASE_USERNAME")local db_password = os.getenv("DATABASE_PASSWORD")local expire = os.getenv("CACHE_EXPIRED_MINUTES") if host == nil then host = "http://127.0.0.1"end if db_host == nil or db_database == nil or db_user == nil or db_password == nil then ngx.redirect(host, ngx.HTTP_MOVED_PERMANENTLY)end if db_port == nil then db_port = 3306end if expire == nil then expire = 15end local uri = ngx.var.request_uri if not uri or uri == "/" then ngx.redirect(host, ngx.HTTP_MOVED_PERMANENTLY)end local links = ngx.shared.linkslocal redirect, flags, err = links:get(uri) if not redirect or redirect == nil then local mysql = require "resty.mysql" local db, err = mysql:new() if not db then ngx.redirect(host, ngx.HTTP_MOVED_PERMANENTLY) end  db:set_timeout(1000)  local ok, err, errno, sqlstate = db:connect{ host = db_host, port = db_port, database = db_database, user = db_user, password = db_password, max_packet_size = 1024 * 1024 }  if not ok then db:close() ngx.redirect(host, ngx.HTTP_MOVED_PERMANENTLY) end  sql = "SELECT value FROM short_link WHERE `key` = " .. "\'" .. uri .. "\'" .. " AND deleted_at IS NULL ORDER BY created_at DESC LIMIT 1"  local res, err, errno, sqlstate = db:query(sql) if not res or next(res) == nil then db:close() ngx.redirect(host, ngx.HTTP_MOVED_PERMANENTLY) end  local result = res[1]["value"]  if(type(result) ~= "string") then db:close() ngx.redirect(host, ngx.HTTP_MOVED_PERMANENTLY) end  if string.match(result, "^https-://[%w+%.]+[/%w+]+.*") ~= nil then redirect = result elseif string.match(result, "^%w[%w+%.]+.*") ~= nil then redirect = "http://" .. result else redirect = host .. "/" .. result end  local ok, err = links:set(uri, redirect, 60 * expire) if not ok then db:close() ngx.redirect(host, ngx.HTTP_MOVED_PERMANENTLY) end  db:close()end ngx.redirect(redirect, ngx.HTTP_MOVED_PERMANENTLY)

user nobody;worker_processes 2; error_log /var/log/nginx/error.log warn;pid /var/run/nginx.pid; env APP_URL;env DATABASE;env DATABASE_HOST;env DATABASE_PORT;env DATABASE_USERNAME;env DATABASE_PASSWORD;env CACHE_EXPIRED_MINUTES; events { worker_connections 1024;} http { include mime.types; default_type application/octet-stream;  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;  keepalive_timeout 65; server_names_hash_bucket_size 64;  lua_shared_dict links 128m; # 用于分配缓存大小  gzip on; gzip_disable "msie6";  include /etc/nginx/conf.d/*.conf;}

server { listen 80; listen [::]:80; server_name xxx.com; access_log /var/log/nginx/shortlink.access.log; error_log /var/log/nginx/shortlink.error.log;  resolver local=on ipv6=off; # 读取/etc/resolve.conf中默认dns地址 resolver_timeout 5s;  location / { default_type text/plain; content_by_lua_file /usr/local/openresty/lualib/shortlink.lua; }  location = /robots.txt { return 200 "User-Agent: *\nDisallow: "; }  location = /probe { return 200 ""; }  #error_page 404 /404.html; error_page 500 502 503 504 /50x.html; location = /50x.html { root /usr/local/openresty/nginx/html; }  location ~ /\.ht { deny all; }}

version: '3'services: mysql: container_name: local-mysql image: mysql:8.0.20 ports: - "3306:3306" volumes: - $PWD/conf/mysql/conf.d:/etc/mysql/conf.d:ro - $PWD/data/mysql:/var/lib/mysql environment: MYSQL_ROOT_PASSWORD: root MYSQL_DATABASE: app MYSQL_USERNAME: test MYSQL_PASSWORD: test TZ: Asia/Shanghai networks: - local openresty: container_name: local-openresty image: openresty/openresty:centos ports: - "80:80" volumes: - $PWD/log/openresty:/var/log/nginx - $PWD/scripts/openresty/shortlink.lua:/usr/local/openresty/lualib/shortlink.lua - $PWD/scripts/openresty/nginx.conf:/usr/local/openresty/nginx/conf/nginx.conf:ro - $PWD/scripts/openresty/shortlink.conf:/etc/nginx/conf.d/shortlink.conf:ro entrypoint: - /usr/bin/openresty - -g - daemon off; environment: TZ: Asia/Shanghai APP_URL: http://127.0.0.1 DATABASE_HOST: mysql DATABASE_PORT: 3306 DATABASE: fusion DATABASE_USERNAME: root DATABASE_PASSWORD: root CACHE_EXPIRED_MINUTES: 15 depends_on: - mysql networks: - localnetworks: local:

apiVersion: v1kind: ConfigMapmetadata: name: cm-shortlink-proxy annotations: configVersion: CONFIG_VERSION namespace: APP_ENVdata: nginx.conf: | (填入上面准备好的 nginx 配置)  shortlink.conf: | (填入上面准备好的 vhost 配置)  shortlink.lua: | (填入上面编写好的 lua 脚本)

apiVersion: apps/v1kind: Deploymentmetadata: name: dp-shortlink-proxy labels: app: shortlink-proxy namespace: APP_ENVspec: replicas: 1 selector: matchLabels: app: shortlink-proxy template: metadata: annotations: configVersion: CONFIG_VERSION service.shortlink.version: SHORTLINK_VERSION labels: app: shortlink-proxy spec: imagePullSecrets: - name: registry-key containers: - name: shortlink-proxy image: SHORTLINK_IMAGE_REPOSITORY:SHORTLINK_VERSION imagePullPolicy: IfNotPresent env: - name: APP_FRONTEND_URL value: "https://APP_FRONTEND_SERVER_NAME" - name: DATABASE_HOST valueFrom: secretKeyRef: name: APP_ENV-database-secret key: host - name: DATABASE_PORT value: "DB_PORT" - name: DATABASE value: "DB_DATABASE" - name: DATABASE_USERNAME valueFrom: secretKeyRef: name: APP_ENV-database-secret key: username - name: DATABASE_PASSWORD valueFrom: secretKeyRef: name: APP_ENV-database-secret key: password - name: CACHE_EXPIRED_MINUTES value: "SHORTLINK_CACHE_TIMEOUT" ports: - name: shortlink-svc containerPort: 80 volumeMounts: - name: shortlink-proxy-logs mountPath: /usr/local/nginx/logs - name: shortlink-proxy-conf mountPath: /usr/local/openresty/nginx/conf/nginx.conf subPath: nginx.conf - name: shortlink-proxy-conf mountPath: /etc/nginx/conf.d/shortlink.conf subPath: shortlink.conf - name: shortlink-proxy-conf mountPath: /usr/local/openresty/lualib/shortlink.lua subPath: shortlink.lua resources: requests: cpu: 100m memory: 300Mi limits: cpu: 2000m memory: 2000Mi command: ["/usr/bin/openresty"] args: ["-g", "daemon off;"] readinessProbe: httpGet: path: /probe port: 80 initialDelaySeconds: 10 periodSeconds: 10 volumes: - name: shortlink-proxy-logs emptyDir: {} - name: shortlink-proxy-conf configMap: name: cm-shortlink-proxy

apiVersion: v1kind: Servicemetadata: name: svc-shortlink-proxy annotations: service.shortlink.protocol: http labels: app: shortlink-proxy namespace: APP_ENVspec: type: LoadBalancer ports: - name: shortlink-svc port: 80 protocol: TCP targetPort: shortlink-svc selector: app: shortlink-proxy

apiVersion: v1kind: Secretmetadata: name: APP_ENV-database-secrettype: OpaquestringData: host: DB_HOST username: DB_USERNAME password: DB_PASSWORD

function generate_unique_short_keys(string $string, int $short_len = 6) : array{ $base_chars = [ 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '0', '1', '2', '3', '4', '5', '6', '7', '8', '9' ]; $short_arr = []; $md5_arr = str_split(md5($string), 8); foreach ($md5_arr as $md5_str) { $hex = hexdec($md5_str) &amp; 0x3fffffff; $short_str = null; for ($i = 0; $i < $short_len; $i++) { $index = 0x0000003d &amp; $hex; $short_str .= $base_chars[$index]; $hex = $hex >> intval(30 / $short_len); } array_push($short_arr, $short_str); } return $short_arr;}