Is it possible to set up the highly available sequencer integration for SQL against a database with redundancy? If so, how?
This page shows how to setup an ha sequencer:
https://www.canton.io/docs/stable/user-manual/usermanual/ha.html#sequencer
It is important that all sequencer nodes use the same underlying DB. The DB can be replicated, though.
To avoid issues with stale reads, the sequencer nodes will wait until a transaction has been committed to all DB replicas, if necessary.
If you need help setting up a replicated DB please let me know which DB you intend to use (Postgres / Oracle).