Here is the configuration that we will have and so … we are thinking about Database synchronisation strategy. Well, maybe you have some advices for me
We are in release 7.1.1, and for the latest environment we have 2 serveurs. In each server we have every webmethods components and a local Database engine.
In the running service mode, some components will be “active” and some other “inactive” (Services stopped or package disabled). On the second server every components inactive will be active and every active will be inactive. That means :
Server 1 : Active --> IS/TN, Broker
Server 2 : Active --> Optimize, IS/PRT, MWS, Task Engine
On each serveur with have to local Database :
Server 1 : DB A (Active), DB B (Inactive)
Server 2 : DB A (Inactive), DB B (Active)
Each database have the same table schema.
The goal is : if server 1 crashed, we switch everything on server 2 and reactivate every inactive components. (Same thing if server 2 crashed).
We have SQL Server 2005.
We know that for switch procedure “inactive” Database must be synchronise with the active database on the other servers.
1/ can we copy every thin from inactive database to active database every X hour (for example)?
2/ Do we have only to copy specific table ?
Thanks for your advices