wadeliu101/proxysql-query-log-demo

ProxySQL Query Log Demo

This is a demo code for fetch query log of mysql from proxysql cluster

Prerequisites

• terraform
• docker and enable kubernetes
• skaffold
• kubectl
• kustomize
• mysql shell

Usage

check current context of kubernetes is docker-desktop

$ kubectl config current-context

initialize terraform module

$ terraform init

launch proxysql cluster and mysql on kubernetes

$ terraform apply -auto-approve

connect to mysql via proxysql

$ mysql -h localhost -P 6033 -u demo --password=demo

deploy code into kubernetes and check log

$ cd query_log
$ skaffold dev

destroy proxysql cluster and mysql from kubernetes

$ terrafrom destroy -auto-approve