Skip to content

Instantly share code, notes, and snippets.

yijia yijia2413

Block or report user

Report or block yijia2413

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@yijia2413
yijia2413 / getip.sh
Created May 28, 2020
get ip address
View getip.sh
#!/bin/bash
set -ex
ip route get 8.8.8.8 | head -1 | awk '{print $7}'
@yijia2413
yijia2413 / csvlogger.py
Created May 7, 2020
set up csv logger in python
View csvlogger.py
import logging
def setup_csv_logger(log_file, name='csv', level=logging.INFO):
handler = logging.FileHandler(log_file)
handler.setFormatter(
logging.Formatter('%(asctime)s,%(message)s',
datefmt='%Y-%m-%d:%H:%M:%S')
)
csvlogger = logging.getLogger(name)
csvlogger.setLevel(level)
@yijia2413
yijia2413 / k8s_op.sh
Last active Oct 31, 2019
k8s operations
View k8s_op.sh
# start proxy allow remote access
kubectl proxy --address=0.0.0.0 --port=80 --accept-hosts='^*$'
# port forward
kubectl --address 0.0.0.0 port-forward redis-test1-xxxx 6379:6379
# check pod startup issue
kubectl describe pod [my-pod-name] -n [kube-system](namespace)
# show all pods
View docker-commands.md

delete volumes not in use

docker volume rm $(docker volume ls -qf dangling=true)
View options.sh
# 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
yijia2413 / insert.sh
Created Apr 22, 2019
MySQL insert duplicate key
View insert.sh
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
yijia2413 / tz.sh
Last active Apr 19, 2019
chang timezone
View tz.sh
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
View log.py
logging.basicConfig(filename=logname,
filemode='a',
format='%(asctime)s,%(msecs)d %(name)s %(levelname)s %(message)s',
datefmt='%H:%M:%S',
level=logging.DEBUG)
logging.basicConfig(format='%(asctime)s,%(msecs)d %(levelname)-8s [%(filename)s:%(lineno)d] %(message)s',
datefmt='%d-%m-%Y:%H:%M:%S',
level=logging.DEBUG)
View README.md

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:
    
View createt_tb.sql
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')),
You can’t perform that action at this time.