Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Database redundancy in HAproxy with pfsense

    Scheduled Pinned Locked Moved Cache/Proxy
    3 Posts 2 Posters 646 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      asheeshc2
      last edited by

      Im trying to use haproxy for database redundancy. Some details
      1st database server IP address- 192.168.10.18
      2nd database server IP address- 192.168.10.20
      And I created a virtual IP 192.168.10.100 under the lan because these are the Lan IPs
      Now I am using this IP in Haproxy but it doesn’t work
      I can connect directly both the servers
      I tried to apply a NAT rule but it doesn’t work
      Can you please help to understand or do you have Anybook on pfsense ?

      V 1 Reply Last reply Reply Quote 0
      • V
        viragomann @asheeshc2
        last edited by

        @asheeshc2
        Shouldn't this better be realized with a database server cluster?
        At least if you need write access to the database.

        1 Reply Last reply Reply Quote 0
        • stephenw10S stephenw10 moved this topic from General pfSense Questions on
        • A
          asheeshc2
          last edited by

          Resolved, there was an issue in connection limit

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.