For Oracle, CA CloudMinder recommends Data Guard, Oracle’s standby database solution, to support disaster recovery. For PostgreSQL, CA CloudMinder recommends Streaming Replication, PostgreSQL’s standby database solution to support disaster recovery.
With this approach, the primary site owns the master database and the DR site owns the standby database. Data is replicated from master to standby until a failure occurs. At that time, the standby database is promoted to a master database for use by the DR site.
During normal operation, the standby database can only be written using the replication stream. It cannot be directly written by the applications at the DR site. For this reason, certain operations at the DR site, such as software installation, require that the application being installed connect to the master database at the primary site. For PostgreSQL, CA CloudMinder recommends Streaming Replication, PostgreSQL’s standby database solution to support disaster recovery.
|
Copyright © 2014 CA Technologies.
All rights reserved.
|
|