December 27, 2002 at 12:15 am
Hi
I have a problem with a failover setup. The client is in the middle of some database operation and the failover happens will the transaction be rolled back or will everything go normal without the client knowing anything abnormal has happened. If the transaction is rolled back for failover what would be the error no that should be trapped.
I appreciate your help in advance.
Thx
Joe
ok
ok
December 27, 2002 at 4:52 am
When the cluster fails all user connections are reset while the failover happens test for connection first. Yes the transaction will be rolled back if it wasn't commited.
Wes
December 27, 2002 at 9:23 am
If you're coding a failure aware client, bear in mind that a big database with full recovery can take a while to come back online. Also remember that every client will be disconnected at the same time an will try to reconnect at the same time. (e.g. code a random delay between reconnect sattempts for the clients *and* seed the random number generator from a machine specific thing, such as the MAC address or IP number.)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply