IT 기술/코드샘플 (36) 썸네일형 리스트형 war배포, jar배포시 classpath 오류 war br = new BufferedReader(new FileReader(ResourceUtils.getFile("classpath:jasyptKey.txt"))); jar br = new BufferedReader(new InputStreamReader(new ClassPathResource("jasyptKey.txt").getInputStream())); AWS was 죽는거 대비 swap설정 167 sudo dd if=/dev/zero of=/swapfile bs=128M count=32 (4gb) 168 sudo mkswap /swapfile sudo chmod 600 /swapfile 169 sudo swapon /swapfile 170 sudo swapon -s 171 sudo vi /etc/fstab /swapfile swap swap defaults 0 0 172 free sudo swapoff -a (스왑끄기) 깃랩 재시작 시 오류가 날때 sudo /opt/gitlab/embedded/bin/runsvdir-start & mysql group by 옵션 vi /etc/my.cnf ... #socket=/var/lib/mysql/mysql.sock port=13306 datadir=/data/mysql socket=/data/mysql/mysql.sock sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION ... sql mode 추가 로그 백업 스크립트 USER="[RemoteServer userID]" SERVER_IP="192.168.30.5" YD=$(date -d yesterday +%Y-%m-%d) PW="[RemoteServer 비밀번호]" REMOTE_DIR="/home/backup/prod2" SENDING_BO_LOGBACK="/home/hhh/logs/*$YD.*" SAVE_BO_LOGBACK="$REMOTE_DIR/wasLogback" expect mysql 유저생성, 권한 쿼리 create user ''@'%' identified by '!'; create user ''@'%' identified by '#e'; create user ''@'%' identified by '$'; GRANT ALL PRIVILEGES ON *.* TO ''@'%' IDENTIFIED BY '!'; GRANT select, insert, update,delete ON *.* TO ''@'192.168.%' IDENTIFIED BY '#e'; GRANT select, insert, update,delete ON *.* TO ''@'192.168.%' IDENTIFIED BY '$'; flush privileges; TOMCAT 클러스터링 설정 Server.xml 클러스터 설정 추가 [mybatis] INSERT 전에 테이블 존재유무 체크하기 한방쿼리를 원할때 사용 INSERT INTO temp (COL_NM) select '1' from DUAL WHERE EXISTS( SELECT 1 FROM Information_schema.tables WHERE table_name = 'temp') 이전 1 2 3 4 5 다음