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

    Failover script alternar link no MYSQL

    Scheduled Pinned Locked Moved Routing and Multi WAN
    1 Posts 1 Posters 168 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.
    • I
      Iconne
      last edited by

      Bom Dia pessoal, tenho um ambiente com um Failover (2 ips fixos dedicados fibra) configurado e funciona corretamente, porém tenho uma aplicação externa que se conecta através de ip wan, logo quando um dos links cai, ela não alterna sozinha.
      Preciso criar um script para gravar nessa base my sql a informação de que o link caiu.
      A idéia seria que quando o link A cair, o pfsense / script grave automaticamente na tabela do my sql que o link A caiu e alternar para o Link B.
      Imaginei Link A = 0, Link B = 1, por exemplo, ele gravando 0 ou 1 alternamos nessa tabela do banco resolveríamos o problema.
      Alguém tem alguma sugestão?
      Obrigado pessoal

      /////

      Good morning guys, I have an environment with a Failover (2 fixed ips dedicated fiber) working and working correctly, however I have an external application that connects via ip wan, so when one of the links goes down, it does not switch on its own.
      I need to create a script to record on that basis my sql the information that the link fell.
      The idea would be that when link A goes down, the pfsense / script automatically writes to my sql table that link A went down and switch to Link B.
      I imagined Link A = 0, Link B = 1, for example, by recording 0 or 1 we alternate in this table of the bank we would solve the problem.
      Does anyone have any suggestions?
      Thank you guys

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