Very basic and experimental watcher for ProxySQL: https://github.com/sysown/proxysql
Watcher monitors changes to specific Etcd prefix and populates those changes to ProxySQL.
For now a lot of values are hardcoded.
Use at your own risk!
Create k8s configmap percona-config:
kind: ConfigMap
apiVersion: v1
metadata:
name: percona-config
data:
mysql-root-password: "JdUDnZyTsL"
discovery-service: "etcd-client:2379"
cluster-name: "k8scluster"
xtrabackup-password: "p9jwtcv3WX"
mysql-proxy-user: "proxyuser"
mysql-proxy-password: "XTg1o9g8aP"
Create proxysql-watcher replication controller: kubectl create -f proxysql-watcher.yaml
Run tests (using sysbench):
sysbench --num-threads=4 --max-time=20 --test=oltp --db-ps-mode=disable
--mysql-user='proxyuser' --mysql-password='XTg1o9g8aP' --oltp-table-size=10000
--mysql-host=pxc-service --mysql-port=3306 prepare
sysbench --num-threads=4 --max-time=20 --test=oltp --db-ps-mode=disable
--mysql-user='proxyuser' --mysql-password='XTg1o9g8aP' --oltp-table-size=10000
--mysql-host=pxc-service --mysql-port=3306 run
Watcher monitors prefix in Etcd, where Percona nodes store their status. After
the node is created and started, watcher configures permissions for
mysql-proxy-user and adds new server to ProxySQL.
I've included monkey.py which is able to randomly destroy pods. Use it on
your own risk!
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent