2021-01-29-TIL

Java Docker MySQL

  • https://www.linkedin.com/pulse/running-java-application-mysql-linked-docker-deepak-sureshkumar/

  • https://dzone.com/articles/mysql-in-java-application-docker

리스코프 치환 원칙

  • https://jaepils.github.io/pattern/2018/07/04/liskov-substitution-principle.html

Java in Nutshell

https://www.amazon.com/Java-Nutshell-Desktop-Quick-Reference/dp/1492037257/ref=sr_1_1?dchild=1&keywords=Java+in+a+Nutshell&qid=1605393888&s=books&sr=1-1

Windows and containers

https://docs.microsoft.com/en-us/virtualization/windowscontainers/about/

Docker commands

https://captcha.tistory.com/49

docker stop $(docker ps -aq) ;
docker rm $(docker ps -aq);docker rmi $(docker images -aq) --force;
docker system prune --force; # 시스템 찌꺼기(DB파일까지) 완전히 삭제
docker system prune --volumes --force;

Transaction Isolation Level

논리적으로 Isolation이 되도록 구현된다.

http://www.yes24.com/Product/Goods/6104230

$ docker start -i mysql-5.7                         
[Entrypoint] MySQL Docker Image 5.7.33-1.1.19
[Entrypoint] Starting MySQL 5.7.33-1.1.19
2021-01-29T02:23:31.259731Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-01-29T02:23:31.264986Z 0 [Note] mysqld (mysqld 5.7.33) starting as process 1 ...
2021-01-29T02:23:31.268758Z 0 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
2021-01-29T02:23:31.268777Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2021-01-29T02:23:31.268805Z 0 [ERROR] Aborting

2021-01-29T02:23:31.268820Z 0 [Note] Binlog end
2021-01-29T02:23:31.270376Z 0 [Note] mysqld: Shutdown complete

https://developpaper.com/please-readsecurity-to-find-out-how-to-run-mysqld-as-root/

NoSQL

  • 채팅서비스를 관계형DB로 구현하면 하루에 1억건에 달하는 채탱메시지를 저장하고, 빠르게 반응하지 못한다.

mysql bulk insert

기술지원으로 먹고산다

Docker rename

https://www.tecmint.com/name-docker-containers/

Docker change port

https://stackoverflow.com/questions/19335444/how-do-i-assign-a-port-mapping-to-an-existing-docker-container

Docker Architecture

  • https://judekim.tistory.com/15

PowerToyz

https://gist.github.com/godrm/c32f3827fe4986f559e32a860f08f525