That architecture could work with one of the two options off the top of my head:
- Use two different MQTT Servers - one for the primary system, another for the backup system.
- Use different Sparkplug IDs (i.e. different Group or Edge Node IDs) for the primary and backup systems.