Disaster Recovery for PostgreSQL
Gold Standard Disaster Recovery
Disaster Recovery on PostgreSQL can be complex, time-consuming, and subject to human error. StandbyMP software simplifies, automates and de-risks standby creation and management to ensure you are always protected.
Supports on-premise, cloud, and hybrid environments
StandbyMP is intuitive, automated and scalable DR for PostgreSQL
SIMPLICITY
Simplify Standby Creation
The Challenge: Setting up reliable Disaster Recovery requires much more than just running a setup streaming command. In the real world, this would involve running separate actions using different command lines, manually editing configuration files, and matching everything up. If you make a single mistake in a config file, you're on your own. And what's worse, you may not know until disaster strikes.
The Solution: StandbyMP delivers standardized, automated and verified standby setup across any supported PostgreSQL version and operating system.
/Dark/Automated%20Fallover.svg)
Work Smarter, not Harder
- Remove complexity and save time with additional functionality such as pre-checks and intuitive workflows.
- Work faster with one-click, multi-cluster actions such as creation, switchover or failover.
- Multiplatform DR enables the management of PostgreSQL, Oracle SE, and SQL Server DR from a central control centre.
/Dark/Continuous%20Protection.svg)
Easier Patching & Maintenance
- Use StandbyMP's one-click Graceful Switchover to seamlessly shift database operations to a standby server with zero-data-loss for patching and maintenance.
- Once maintenance is complete, smoothly switch back to the primary server with just a few clicks, reducing disruption to critical services.
- Graceful Switchovers make server maintenance and patching quick and risk-free.
CONTROL
Fully featured Command Line Interface delivering granular control and convenience
Prefer to work via CLI? The powerful CLI allows you to complete common DR tasks effectively.
API functionality allows you to integrate SttandbyMP into your workflows.
Streaming
Real-time streaming replication
Leverage PostgreSQL's powerful real-time replication functionality to keep a standby cluster continuously up-to-date. Easily import existing streaming configurations to gain compelling monitoring and maintenance functionality through StandbyMP.
- Initialize the standby cluster easily using StandbyMP.
- A replication slot is created on the primary cluster, to which the standby cluster seamlessly connects and initiates a full backup operation via the data stream.
- Once the primary cluster data is synchronized, the standby cluster remains continuously connected and receives all transactions from the primary as soon as they are committed.
Archive mode
Archive mode WAL shipping
Utilize time-tested and reliable Write-Ahead-Log files together with PostgreSQL's Archive Mode settings to keep your standby cluster up to date.
- Initialize the standby cluster easily using StandbyMP.
- A full backup is automatically created, transferred onto standby and restored, bringing the standby into sync with the primary.
- The Archive Interval is set on the primary cluster. Whenever a new WAL segment is ready, or the Interval timeout is reached, a new WAL file is backed up by the primary cluster.
- StandbyMP automatically creates and manages the various associated callbacks, catching the newly-created WAL file, transferring it to the standby, and restoring it. StandbyMP also includes all file management, keeping both systems clean of WAL files that are no longer required.
WAL shipping
Manual file shipping
When you need total control, keep your standby cluster in-sync by manually creating and restoring transactional backups on a set schedule.
- Initialize the standby cluster easily using StandbyMP.
- A full backup is automatically created, transferred onto standby and restored, bringing the standby into sync with the primary.
- Leaving PostgreSQL's own settings alone, StandbyMP instead controls the whole show itself: a manual query is run on a set interval to create WAL backups.
- These are then automatically brought across to the standby cluster, and a manual query is run to restore them. StandbyMP manages all files and network transfers.
VIEW THE FEATURE SHEET
Discover StandbyMP's Gold Standard DR features
- One-click Graceful Switchovers
- Cascading standby support
- Automatic (or guided) Failover
- Reporting from standby
- Real-time monitoring & smart notifications
Automated Failover
The failover assistant enables one-click failover, triggered manually or automatically.
/Dark/Always%20Operational.svg)
Great RPO & RTO
Recover from any event in just a few minutes, with less than 2 minutes of data loss (user configurable).
/Dark/Continual%20Integrity%20Verification.svg)
Graceful Switchovers
Zero-data-loss planned switchovers enable easy patching, maintenance, migrations and testing.
/Dark/Cloud%20Ready.svg)
Cloud Ready
Easy to configure on premise, hybrid, or in the cloud. Supporting public and private clouds.
/Dark/Smart%20Notifications.svg)
Smart Notifications
Realtime monitoring with heartbeat notifications, status alerts, and log gap reports.
/Dark/One%20UI.svg)
MultiPlatform UI
Easily manage DR configurations across PostgreSQL versions, Oracle or SQL Server databases.
StandbyMP Customers
Countries use StandbyMP
Customer renewals
Customer Satisfaction
Key product information
Discover key product information on Dbvisit StandbyMP
-thumb.jpeg?width=732&name=Business%20Continuity%20(new%20brand)-thumb.jpeg)
-thumb-1.jpeg?width=732&name=DR%20in%20The%20Cloud%20(new%20brand)-thumb-1.jpeg)
-thumb.jpeg?width=732&name=Physical%20Replication%20(new%20Brand)-thumb.jpeg)
-thumb-1.jpeg?width=732&name=Video%20-%20RPO%20vs%20RTO%20(new%20brand)-thumb-1.jpeg)
