Implement failover tests for MariaDB and broker nodes.

[#78603718]