Geunho Kim geunho

🎯

Focusing

Developer : Dec 2013 -

geunho / cnn.sh

Created April 15, 2024 02:31

zookeeper 클라이언트 IP 확인

echo cons | nc localhost 2181

geunho / bash_date_loop.sh

Created October 14, 2022 11:03

시간을 순회하면서 처리해보자

geunho / citus_shard_to_node_map.sql

Created May 23, 2022 01:43

citus shard별 할당된 node 읽기

	SELECT s.shardid id, shardminvalue min, shardmaxvalue MAX, p.nodename
	FROM pg_dist_shard s
	LEFT JOIN pg_dist_shard_placement p
	ON s.shardid = p.shardid
	WHERE logicalrelid = $TABLE_NAME::regclass;

geunho / md5_digest.scala

Created May 10, 2022 12:37

	import rg.apache.commons.codec.digest.DigestUtils

	val origin = "test text"
	val hash = DigestUtils.md5Hex(origin)

	println(hash)

geunho / pg_stat_activity.sql

Created May 2, 2022 09:56

실행중인, blocking된 쿼리 목록 조회

	select pid,
	usename,
	pg_blocking_pids(pid) as blocked_by,
	query as blocked_query
	from pg_stat_activity

geunho / base64_encode_decode.scala

Created April 19, 2022 05:03

	val contents = "문자열 base64 인코딩/디코딩 테스트."
	val encoded = java.util.Base64.getEncoder.encode(contents.getBytes)
	val decoded = java.util.Base64.getDecoder.decode(encoded)
	val result = new String(decoded)
	assert(contents == result)

geunho / string_to_hex.scala

Created July 28, 2021 05:56

def string2hex(str: String): String = str.toSeq.map(_.toInt.toHexString).mkString(" ")

geunho / offset_rewind.sh

Last active September 12, 2021 12:52

kafka consumer group offset rewind

	./kafka-consumer-groups \
	--bootstrap-server $BROKER_LIST \
	--group $CONSUMER_GROUP \
	--topic $TOPIC \
	--reset-offsets \
	--to-datetime 2021-04-20T15:00:00.000 \
	--execute

geunho / find_tips.sh

Created January 26, 2021 01:39

find tips 💫

	# 특정 단어가 포함된 파일 찾기
	find $FILE_PATH_TO_FIND -type f -print \| xargs grep $WORD_TO_FIND

geunho / kubectl_cheat_sheet.sh

Last active March 29, 2023 11:36

kubectl cheat sheet 💫

	# 이미지 확인을 위해 임시로 /bin/bash pod 띄우기
	kubectl run $POD_NAME --rm -i --tty --restart=Never --image=$IMAGE:$TAG --command -- /bin/bash

	# pod 상태 변경시 출력하기 - OOMKill 등 확인시 사용
	kubectl get pod -w

	# pvc 용량 증설 (변경 저장 후 물고있는 pod 재시작해야함)
	kubectl edit pvc $PVC_NAME

	# statefulset pod 재시작