Our Pentaho+ experts will setup Postgres high availability for fail over and recovery process. Our Architect will understand the requirements and based on it will arrive blueprint for implementation. The blueprint gives an overview of the enterprise layers, the components, inter dependencies and communication interface.
suggest and recommend the best architecture suited for the customer. Provide the sizing requirements required for the hardware based on current and future requirements. Provide solution based on the RTO requirement and how quickly the system can fail over and available for customers
- Configure Postgres Master and Standby Node
- Data Replication to Master and Standby Node using streaming replication
- Watchdog setup for monitoring heart beat of the server status
- Fail over & recovery setup
- Setting up connection parameters and timeout settings to reduce overhead on the servers
- Incremental Backup configuration
- Troubleshoot the failed node and reinstate to the original state after the issue is resolved
Highlights
- Increasing Business Continuity, lowering the risk of interruption
- Attach failed node to live cluster with less downtime
- Continous archiving in Standy Node to avoid data loss
- Disaster recovery in case of outage to manage business continuity