mongo count distinct

Read full article  | 评论关闭

 

 

db.collection_name.distinct(‘types2′)

Read More

nginx upstream based on URL parameter

Read full article  | 评论关闭

 

 

location / {

if ( $arg_parameterName = “test1″ ) {
proxy_pass http://server1;
}
if ( $arg_parameterName = “test2″ ) {
proxy_pass http://server2;
}
}

Read More

delete old data from elasticsearch

Read full article  | 评论关闭

 

get indices info

curl 'localhost:9200/_cat/indices?v'

delete old data:
curl -v -X DELETE http://localhost:9200/logstash-$day*

Read More

nginx upstream based on http header

Read full article  | 评论关闭

upstream apache {
     server 127.0.0.1:8080;
}

upstream staging {
     server 127.0.0.1:8081;
}

upstream development {
     server 127.0.0.1:8082;
}

# map to different upstream backends based on header
map $http_x_server_select $pool {
     default "apache";
     staging "staging";
     dev "development";
}

server {
     listen 80;
     server_name example.com;
     location / {
          proxy_pass http://$pool;

          #standard proxy settings
          proxy_set_header X-Real-IP $remote_addr;
          proxy_redirect off;
          proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
          proxy_set_header Host $http_host;
          proxy_redirect off;
          proxy_set_header X-Forwarded-Proto $scheme;
          proxy_set_header X-NginX-Proxy true;
          proxy_connect_timeout 600;
          proxy_send_timeout 600;
          proxy_read_timeout 600;
          send_timeout 600;
     }
}

Read More

mongo collection name have -

Read full article  | 评论关闭

 

 

db['construction-places'].count()
42

Read More

BMI 计算公式

Read full article  | 评论关闭

 

EX:70kg÷(1.75×1.75)=22.86

成人的BMI数值:
过轻:低于18.5
正常:18.5-23.9
过重:24-27
肥胖:28-32
非常肥胖, 高于32
bmi 标准

Read More

json 中文显示乱码

Read full article  | 评论关闭

方法一

print res_content.decode(‘raw_unicode_escape’)

 

方法二

print json.dumps(json.loads(result),ensure_ascii=False)

Read More

http cache

Read full article  | 评论关闭

 

 

Last-Modified  &  ETag  (判断是否修改)

Cache-Control & Expires  (缓存多久)

Read More

AWS RDS 跨区域同步

Read full article  | 评论关闭

 

CALL mysql.rds_set_external_master (‘mymasterserver.mydomain.com’, 3306, ‘repl_user’, ‘<password>’, ‘mysql-bin-changelog.000031′, 107, 0);

CALL mysql.rds_start_replication;

 

Read More

redis key 迁移

Read full article  | 评论关闭

 

当slave, migrate 等方法不能用时,直接用dump/restore

redis-cli  -h cn-vpc-redis-session.aftjvu.0001.cnn1.cache.amazonaws.com.cn -n 1 keys “*”  | while read key  ;do redis-cli -h cn-vpc-redis-session.aftjvu.0001.cnn1.cache.amazonaws.com.cn -n 1 –raw dump $key  | head -c-1 | redis-cli -n 0 -x restore  $key  0 ;done

Read More