search

jberkus / pgReplicationTutorial

This repository contains files for the PostgreSQL Binary Replication tutorial.
49 stars 15 forks source link

What if... #7

Open blaggacao opened 6 years ago

blaggacao commented 6 years ago

...someone would try to do a sleak and compliant postgres query loadbalancer in lua for haproxy?

https://www.arpalert.org/haproxy-lua.html

I mean is this not the natural thing to do to replace bgbouncer / pgpool and all the other tools?

Nice side effect: haproxy happens to be the lb of choice of many orchestration frameworks under the hood, like rancher and I believe docker swarm and kubernetes also work atop of haproxy or can be configured that way...

Not sure if this is insane or just nobody has asked this question, so far...

blaggacao commented 6 years ago

Someone has already played arround with postgres and lua: https://github.com/norman/lua-postgres

blaggacao commented 6 years ago

postgres marries haproxy -> haprosql :smile:

blaggacao commented 6 years ago

/cc @CyberDem0n @alexeyklyukin @feikesteenbergen

blaggacao commented 6 years ago

@jirutka, You might be probably the expert on this having contributed repmgr package to alpine linux and having some lua repos on your github...

CyberDem0n commented 6 years ago

@blaggacao do I understand correctly that you want to parse sql statements and route them to the primary or replica, depending on what kind of statement you've got?

blaggacao commented 6 years ago

@CyberDem0n That's been more or less the idea... :smile: Additionally to something that does connection pooling directly on a haproxy...

blaggacao commented 6 years ago

... once there, failover would only be a stone's throw away.