The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

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.8k422580826


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,444 times

last updated: 12 Dec '09, 09:09