yijia2413

delete volumes not in use

docker volume rm $(docker volume ls -qf dangling=true)

yijia2413

# copy from https://coolshell.cn/articles/8619.html

#!/bin/bash
# Bash Menu Script Example
 
PS3='Please enter your choice: '
options=("Option 1" "Option 2" "Option 3" "Quit")
select opt in "${options[@]}"
do
    case $opt in

yijia2413

insert into proc_runtime (vm, procname) values ('100', 'wechat.exe') on duplicate key update vm = values(vm), procname = values(procname), day_runtime =day_runtime +  values(day_runtime)

yijia2413

Config Ingress Nginx

• mandatory.yml, do not use hostNetwork, # hostNetwork: true
• cloud-generic.yml, add externalIPs

  kind: Service
  apiVersion: v1
  metadata:
    name: ingress-nginx
    namespace: ingress-nginx
    labels:
  

yijia2413

# start proxy allow remote access
kubectl proxy --address=0.0.0.0 --port=80 --accept-hosts='^*$'

# check pod startup issue
kubectl describe pod [my-pod-name] -n [kube-system](namespace)

# show all pods
kubectl get pods --all-namespaces

# delete pod and restart again

yijia2413

ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime

# for linux
ENV TZ=Asia/Shanghai
RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone

# for alpine
RUN apk add --no-cache tzdata
ENV TZ Asia/Shanghai

yijia2413

a = [('a', 'etwrfb', 'casdf'), ('1', 2, '35235')]
res = '\n'.join(','.join(map(str, i)) for i in a)

# 'a,etwrfb,casdf\n1,2,35235'

yijia2413

CREATE TABLE if not exists `test` (
        `id`                BIGINT(20) NOT NULL AUTO_INCREMENT,
        `result`            VARCHAR(128),
         `update_time`           DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,        
         KEY id (id)) 
         ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1    
         PARTITION BY RANGE ( TO_DAYS(update_time) ) (    
         -- PARTITION BY hash (TO_DAYS(update_time)) partitions 31;
                PARTITION p_first VALUES LESS THAN (TO_DAYS('2019-01-07 00:00:00')),
                PARTITION p20190107 VALUES LESS THAN (TO_DAYS('2019-01-08 00:00:00')),

yijia2413

# COPY FROM https://stackoverflow.com/questions/32658679/how-to-create-a-mysql-connection-pool-or-any-better-way-to-initialize-the-multip

#!/usr/bin/python
# -*- coding: utf-8 -*-
import time
import mysql.connector.pooling


dbconfig = {
    "host":"127.0.0.1",

yijia2413

[Unit]
Description=containerd container runtime
Documentation=https://containerd.io
After=network.target

[Service]
ExecStartPre=/sbin/modprobe overlay
ExecStart=/usr/bin/docker-containerd
KillMode=process
Delegate=yes