mariadb lock

 http://blog.itpub.net/29773961/viewspace-2145185/

https://www.cnblogs.com/digdeep/p/4892953.html

https://www.twblogs.net/a/5c7faad4bd9eee35fc13486f

https://www.delftstack.com/zh-tw/howto/mysql/waiting-for-table-metadata-lock/

python webssh

# webssh office

https://pypi.org/project/webssh/

+---------+     http     +--------+    ssh    +-----------+
| browser | <==========> | webssh | <=======> | ssh server|
+---------+   websocket  +--------+    ssh    +-----------+

#  webssh and nginx

#https://www.s0nnet.com/archives/conf-webssh

#http://blog.51sec.org/2020/07/python-development-installation-on.html#point2

#https://xyz.cinc.biz/2021/05/nginx-reverse-proxy-websocket.html

# websocket

https://ithelp.ithome.com.tw/articles/10249282

# trouble

# cross domain https://github.com/huashengdun/webssh/issues/98

wssh --origin="*" --debug 

nginx ssh proxy

 主要是要會用 nginx stream module

------------------------------------------------------------

https://blog.csdn.net/carefree2005/article/details/121229818

一、stream模块简介

  stream模块一般用于TCP/UDP数据流的代理和负载均衡，通过stream模块我们可以代理转发tcp报文。ngx_stream_core_module模块从1.9.0版开始提供。默认情况下，此模块不是构建的，应该使用–with stream配置参数启用它，即我们需要使用./configure --with-stream的方式在编译的时候将stream模块添加进去。stream模块用法和http模块差不多，语法也基本相同。

二、使用场景说明

  stream主要有两个可用场景。一是实现流量的代理转发，这里所说的代理转发是只某些端口服务是有源IP地址限制的，例如mysql账户一般是限制了源地址为应用服务器，nginx可能同时是WEB应用服务器，开发人员需要验证一些数据库数据问题，但是账户源地址有限制，此时通过nginx进行数据流转发就可以实现开发终端到mysql的访问。二是实现流量的负载均衡，我们有多个tcp或者udp端口服务（比如DNS），通过stream模块我们可以实现数据流的负载均衡，支持负载均衡算法包括轮询、最小连接数、ip_hash等。

------------------------------------------------------------

# stream module install

https://alpine.pkgs.org/3.16/alpine-main-aarch64/nginx-mod-stream-1.22.0-r1.apk.html

# stream moduele

--ref: https://www.reddit.com/r/selfhosted/comments/eqvi05/reverse_proxy_ssh_connection_with_nginx/

stream { upstream ssh { server localhost:22; } server { listen 80; proxy_pass ssh; } }

----------

https://blog.csdn.net/C3399/article/details/124469967

# ssh tunnel

https://johnliu55.tw/ssh-tunnel.html

https://xenby.com/b/269-%E6%95%99%E5%AD%B8-%E9%80%8F%E9%81%8E-ssh-tunnel-%E5%B0%87%E4%BC%BA%E6%9C%8D%E5%99%A8%E5%85%A7%E9%83%A8%E6%9C%8D%E5%8B%99%E7%B6%81%E5%AE%9A%E5%88%B0%E6%9C%AC%E6%A9%9F%E9%9B%BB%E8%85%A6%E4%B8%8A

# ref

https://iter01.com/68023.html

python alchmsql

 1. learning:

https://sites.google.com/site/sqlalchemynote/home/wu-jian--guan-lian-jiao-xue

2. https://docs.sqlalchemy.org/en/14/orm/query.html

3. https://www.codegrepper.com/code-examples/assembly/sqlalchemy+datetime+range+filter

docker volume

 Good https://phoenixnap.com/kb/nfs-docker-volumes

example

sudo docker volume create --driver local --opt type=nfs --opt o=addr=172.30.1.1,rw --opt device=:/remote_nfs_dir my-docker-nfs

[andychung@TPDT-AMR-01045 system-jupyterLab]$ sudo docker volume ls

local     my-docker-nfs

# structure

https://docs.docker.com/storage/volumes/

python time

 https://blog.goodjack.tw/2020/04/create-datetime-with-timezone-via-python3-without-pytz.html

https://www.programiz.com/python-programming/datetime/timestamp-datetime

https://www.adamsmith.haus/python/examples/5639/datetime-get-the-year,-month,-and-day-of-a-%60datetime%60

https://docs.python.org/zh-tw/3.8/library/datetime.html

python post data or json data

 good disc: https://stackoverflow.com/questions/9733638/how-to-post-json-data-with-python-requests

good disc2: https://stackoverflow.com/questions/26685248/difference-between-data-and-json-parameters-in-python-requests-package

good disc3: https://stackoverflow.com/questions/9733638/how-to-post-json-data-with-python-requests

office api: https://reqbin.com/code/python/m2g4va4a/python-requests-post-json-example