4 ms·
> If your database is ACID, you can pull the power on the server from the wall and have it instantly turn off w/o data loss. Yes -- all except the ongoing tran
by lutusp 12y ago
> If your database is ACID, you can pull the power on the server from the wall and have it instantly turn off w/o data loss.
Yes -- all except the ongoing transactions at the users' workstations. That by itself could represent a serious synchronization problem. For a serious business, an emergency power system might represent a better choice.
- dllthomas 12y agoIf you've not pulled the plug on your users' workstations, the clients should be perfectly capable of retrying the broken transactions when the database comes back up. There can, of course, be constraints that make this impossible, but sloppy coding making it impossible is more common.