# Database Failover Sticky Mode

**URL:** <https://forum.inductiveautomation.com/t/database-failover-sticky-mode/110557>\
**Category:** Ignition\
**Created:** [September 11, 2025, 10:05pm UTC](https://forum.inductiveautomation.com/t/database-failover-sticky-mode/110557 "2025-09-11T22:05:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Suuuuu](https://avatars.discourse-cdn.com/v4/letter/s/7ea924/32.png) [@Suuuuu](https://forum.inductiveautomation.com/u/Suuuuu)\
**Post date:** [September 11, 2025, 10:05pm UTC](https://forum.inductiveautomation.com/t/database-failover-sticky-mode/110557/1 "2025-09-11T22:05:45Z")

</div>

On my gateway, I have set up two database A and B, B is the failover database of A. After configuring B as the failover database and choose STICKY mode in A’s configuration page, I did a test.

after shutting down A, the query did get switch to B. But after bringing A back, didn’t restart gateway, didn’t restart B, the query got switched back to A automatically, even with STICKY mode.

The query I used is from python script, not named query.

Does anyone know why the STICKY mode doesn’t work?

 ![{50A9E726-B401-45B9-BACA-63B7E3AEA2C5}](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/c/8cd214c50d0aa8fd86ba433dc97b182ef4bb7a51.png)