Protecting your database is one of the most critical functions that a system administrator needs to consider. The first level of protection is the venerable backup. You can do backups during downtime, or using continuous operations mode. For smaller users of non-critical databases, periodic backups may do everything you need.
However, for many users, the need for a higher level of protection is obvious. Do you have enough downtime available to perform a complete backup every night? Is your database small enough to back up easily using standard backup techniques? Can you afford to lose a day’s worth of database changes if a failure occurred? If you cannot say YES to all of these questions, then the Double-Take Availability data replication solution is for you.
Double-Take is a fully-automated continuous backup solution for servers. In the event of hardware failure or other disaster, Double-Take Availability provides for immediate failover to a secondary server, keeping your downtime at a minimum. Double-Take captures changes on the protected server in real time, and it replicates those data changes to the target server in the exact order that it was written to the source server, ensuring that your Pervasive PSQL database will always be a “crash consistent” database copy, which helps to maintain data integrity.
When you are ready to buy and install your Double-Take license, you need to make sure that your installer is familiar with the special needs of Pervasive databases to ensure that it gets configured correctly.
Double-Take Availability provides Continuous Data Protection (CDP) for your Pervasive data environment, replicating database changes as they are made from the primary server to the secondary server, even with dissimilar servers and virtual machines! (The operating systems must be the same, however.) Using Double-Take, you can configure your database server to stream database changes to a secondary server in near-real-time. While this solution does not support an Active/Active configuration (you would need to implement DataExchange for that), this product is substantially easier to implement and maintain than DataExchange, and you cannot beat the protection for the price!
Pricing for this solution starts around $2000/server, depending on exact OS version and other factors.