Navigation

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

    Load-Balance servers monitor issue

    Routing and Multi WAN
    1
    1
    1069
    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.
    • D
      drivard last edited by

      Hi,

      I am trying to setup pfsense as a load-balancer, it is not the first time I configure it but this time I want more than a simple port health check.
      Here is the setup:

      WAN: 10.255.2.15
      LAN: 192.168.1.0/24
      DHCP: 192.168.1.100/192.168.1.200

      mysql-db1 -> 192.168.1.21
      mysql-db2 -> 192.168.1.22
      mysql-db3 -> 192.168.1.23

      What I am trying to accomplish a load-balancer that load-balance port 3306 but monitors port 80 to check the mysql health, but I can't figure this out. I have mysql servers that have an Apache server running and if you request the root http://192.168.1.21/ it will execute a PHP script and in this script I made some MySQL health check. the apache servers return the perfect answer at the moment if I call them in the browser.

      So I configured a new monitor with type HTTP with path / and host: empty because I am unsure of what to put there, but I tried the WAN ip, I tried a VIP but still I am having some issues.  Then I configured a pool with my 3 servers, the port I specified was 3306 and the monitor is my newly created http monitor. Then I created my virtual server that point to my WAN ip and port 3306.

      How can I accomplsih this setup?

      1 Reply Last reply Reply Quote 0
      • First post
        Last post

      Products

      • Platform Overview
      • TNSR
      • pfSense
      • Appliances

      Services

      • Training
      • Professional Services

      Support

      • Subscription Plans
      • Contact Support
      • Product Lifecycle
      • Documentation

      News

      • Media Coverage
      • Press
      • Events

      Resources

      • Blog
      • FAQ
      • Find a Partner
      • Resource Library
      • Security Information

      Company

      • About Us
      • Careers
      • Partners
      • Contact Us
      • Legal
      Our Mission

      We provide leading-edge network security at a fair price - regardless of organizational size or network sophistication. We believe that an open-source security model offers disruptive pricing along with the agility required to quickly address emerging threats.

      Subscribe to our Newsletter

      Product information, software announcements, and special offers. See our newsletter archive to sign up for future newsletters and to read past announcements.

      © 2021 Rubicon Communications, LLC | Privacy Policy