Skip to content

What if... #7

Open
Open

Description

@blaggacao

...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...

Activity

  1. blaggacao commented on Jan 26, 2018

    @blaggacao
    Author

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

  2. blaggacao commented on Jan 26, 2018

    @blaggacao
    Author

    postgres marries haproxy -> haprosql 😄

  3. blaggacao commented on Jan 26, 2018

    @blaggacao
    Author
  4. blaggacao commented on Jan 30, 2018

    @blaggacao
    Author

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

  5. CyberDem0n commented on Jan 30, 2018

    @CyberDem0n

    @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?

  6. blaggacao commented on Jan 30, 2018

    @blaggacao
    Author

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

  7. blaggacao commented on Jan 30, 2018

    @blaggacao
    Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions