Can I use High Availability of SQL Anywhere, with a single copy of db files, shared between server on a NAS? I need something like this to prevent hard failures with on downtime of my site. |
When the
Even if you set the server name to something different you then get:
since the file is locked by the first server process. If you're looking for a fail-over solution, you might want to take a look at database mirroring. Thank you Ben, in mirroring if something had commited it's in all databases of "environment"? Ben, maybe Veritas Cluster Server does what I'm thinking... Please, look at this: http://dcx.sybase.com/index.html#1101en/dbadmin_en11/da-highavailability-s-3835111.html Comment Text Removed
3
@Zote: The "mirroring mode" you choose determines how aggressively SQL Anywhere will behave during the commit: guarantee that the commit is performed on the mirror before responding to the client, or don't bother waiting for an acknowledgment, or [something even sloppier]. I've never met anyone who's used anything other than Door Number One, called "synchronous". See "Choosing a database mirroring mode" in the Help. |