Guidelines for managing database replication issues, failover triggers, and schema isolation boundaries.
- Logical Schema Segregation: Enforce database boundaries strictly (
shield_db, cockpit_db, wiki_db).
- Access Credentials: Microservices must only connect using their respective scoped credentials. Direct cross-schema table coupling is prohibited; use read-only views for cross-domain display.
- Promote Standby Node: Initiate standby replication promotion via container orchestration.
- Redirect Gateway traffic: Update internal database connection variables dynamically.
- Verify Integrity: Run consistency checks on logical schemas post-failover.