This is a dedicated watch page for a single video.
You are designing a system that must use an ACID-compliant database to ensure strong transactional consistency . Additionally, the system must be resilient to failures and require minimal manual intervention for recovery or failover when issues occur. What is the most suitable solution?