개발56 [ubuntu] Nginx + Socket.io 설정 server { listen 80; server_name socket.com; server_tokens off; access_log /var/log/nginx/socket.access.log main; error_log /var/log/nginx/socket.error.log; #소켓 전용. location / { proxy_pass http://localhost:2800/; chunked_transfer_encoding off; proxy_buffering off; proxy_set_header Upgrade websocket; proxy_set_header Connection "upgrade"; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for.. 2021. 7. 1. [mysql] 중복글 삭제 #{column2} , #{column3} : 중복 DELETE FROM #{table} WHERE #{column1} IN( SELECT #{column1} FROM (SELECT #{column1} FROM #{table} GROUP BY #{column2} , #{column3} HAVING COUNT(*) > 1) AS tmp ) 2021. 6. 24. [ubuntu] Argument list too long for 문을 이용한 삭제 # cd /tmp # for i in `ls` ; do rm -rf $i ; done 2021. 6. 23. [ubuntu] mysql replication 설정 # vi /etc/mysql/mysql.conf.d/mysqld.cnf #마스터 설정 server-id = 1 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M binlog_do_db = {연결데이터베이스} #슬레이브 SHOW MASTER STATUS; #슬레이브설정 server-id = 2 log_bin = /var/log/mysql/mysql-bin.log relay-log = /var/log/mysql/mysql-relay-bin.log expire_logs_days = 10 max_binlog_size = 100M binlog_do_db = {연결데이터베이스} slave-skip-errors = 1.. 2021. 6. 11. 이전 1 ··· 10 11 12 13 14 다음