The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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.

asked 16 Nov '09, 16:39

Zote's gravatar image

Zote
1.7k364050
accept rate: 43%

edited 12 Dec '09, 09:09

Breck%20Carter's gravatar image

Breck Carter
26.6k418575824


When the .db file is already open by a server process, attempting to start another with the same database file gives the following error:

A database server with that name has already started

Even if you set the server name to something different you then get:

Resource temporarily unavailable

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.

permanent link

answered 16 Nov '09, 17:02

Ben%20S's gravatar image

Ben S
23316
accept rate: 50%

edited 16 Nov '09, 18:07

Thank you Ben, in mirroring if something had commited it's in all databases of "environment"?

(16 Nov '09, 17:27) Zote

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

(16 Nov '09, 17:49) Zote
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.

(16 Nov '09, 18:38) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×137
×37
×10
×2

question asked: 16 Nov '09, 16:39

question was seen: 1,421 times

last updated: 12 Dec '09, 09:09