simulate-mysql-op's Introduction

simulate-mysql-op

Simulate Operations Including Create, Update and Delete to MySQL Server

database_initial

Initial MySQL database, create db_world database.

concurrency_op

Operate the database in parallel, including create, update and delete.

Demo

Just a demo to show how to use it.

MYSQL_USR_NAME=root
MYSQL_USR_PASSWD=$(kubectl get secret --namespace infra bitnami-mysql -o jsonpath="{.data.mysql-root-password}" | base64 -d)
MYSQL_SERVER_URL=bitnami-mysql-primary.infra.svc.cluster.local
MYSQL_SERVER_PORT=3306

INIT_IMAGE_NAME=registry.jingtao.fun/simulate-mysql-op/database_initial
INIT_IMAGE_ARG=test_v2

OP_IMAGE_NAME=registry.jingtao.fun/simulate-mysql-op/concurrency_op
OP_IMAGE_ARG=test_v2

cd database_initial
docker build -t ${INIT_IMAGE_NAME}:${INIT_IMAGE_ARG} ./
docker push ${INIT_IMAGE_NAME}:${INIT_IMAGE_ARG}
cd -

minikube kubectl --profile playground -- \
  delete pod simulate-mysql-initial -n infra --ignore-not-found=false

minikube kubectl --profile playground -- \
  run simulate-mysql-initial \
  --image ${INIT_IMAGE_NAME}:${INIT_IMAGE_ARG} \
  --restart=Never \
  --namespace=infra \
  --env MYSQL_USR_NAME=${MYSQL_USR_NAME} \
  --env MYSQL_USR_PASSWD=${MYSQL_USR_PASSWD} \
  --env MYSQL_SERVER_URL=${MYSQL_SERVER_URL} \
  --env MYSQL_SERVER_PORT=${MYSQL_SERVER_PORT} 

cd concurrency_op
docker build -t ${OP_IMAGE_NAME}:${OP_IMAGE_ARG} ./
docker push ${OP_IMAGE_NAME}:${OP_IMAGE_ARG}
cd -

minikube kubectl --profile playground -- \
  delete pod simulate-mysql-op -n infra --ignore-not-found=false

minikube kubectl --profile playground -- \
  run simulate-mysql-op \
  --image ${OP_IMAGE_NAME}:${OP_IMAGE_ARG} \
  --restart=Never \
  --namespace=infra \
  --env MYSQL_USR_NAME=${MYSQL_USR_NAME} \
  --env MYSQL_USR_PASSWD=${MYSQL_USR_PASSWD} \
  --env MYSQL_SERVER_URL=${MYSQL_SERVER_URL} \
  --env MYSQL_SERVER_PORT=${MYSQL_SERVER_PORT} \
  6 60
# 6 coroutines operate in parallel for 60 seconds

Recommend Projects