Implement Etcd Watch in PostgreSQL(github.com)

https://github.com/kingluo/pg_watch_demo

4 comments

This looks pretty awesome!

Is it stretching the definitions of data-plane and control-plane? Data-plane is the reverse proxy users interact with.. maybe it does make sense.

kingluo4 anni fa

Yes, the DP (data plane) in the demo acts as reverse proxy, it routes the downstream http request to the upstream according to the configuration. The CP (control plane) just translates the json configuration to sql and get it executed in the postgresql.

alexnewman4 anni fa

ive been waiting for someone to replace etcd with pg in k8s for realz. there’s been a couple of cool toy projects

kingluo4 anni fa

Yes, it does so in our company. The etcd is somehow heavyweight to be the configuration center. And event more, the postgresql could be deployed in de-centralized cluster just like what etcd does, via some tools (e.g. raft-based failover agents) and configurations (I helped my customers to achieve this goal, but the solution is not open source yet).