Forum Discussion

bob3's avatar
bob3
Icon for Altocumulus rankAltocumulus
Mar 15, 2023

iRule Help for Web front end and Backend Database server traffic to failover at same time

Hello, I am looking to create an iRule for Web front end and Backend Database server traffic to failover at same time.  The current topology is 2 Front end web servers and 2 back end database server...
application delivery
Paulius's avatar
Paulius
Icon for MVP rankMVP
Mar 16, 2023

What is the mechanism on the database server that makes it so web1 has to speak with db1 and web2 has to speak with db2? Typically you don't have a hard link between web and db servers because of the obvious downside such as yours. I'm not aware of how to do this with priority group activation but if you created 2 pools for web and 2 for db you could have the following logic.

*** Web irule ***
if pool-web1 active members <= 0 forward traffic to pool-web2 else forward to pool-web1

*** DB irule ***
if pool-db1 active members <= 0 and pool-web1 active member <=0 forward to pool-db2 else forward to pool-db1

  • bob3's avatar
    bob3
    Icon for Altocumulus rankAltocumulus
    Mar 16, 2023

    Paulius,

    Thank you for your feedback.  The two database servers do sync there data together.  However, in normal operations certain users, clients, and devices access the data directly to the database server.  So in the event of a Web failure we want those users and clients to be directed to the 02 web and 02 database server.  Yes, it's a different approach on the server topology, unfortnately we are at the mercy of the application/database owners.  Hope that clears you question up.