Subject | Re: [firebird-support] 2 servers acessing one database |
---|---|
Author | Mark Rotteveel |
Post date | 2015-12-16T19:30:57Z |
On Wed, 16 Dec 2015 08:41:11 -0500, "DougC doug@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
The major problem is not only shared access to the file (although that can
give some problems), the larger problem is that the lockfiles aren't shared
across machines, which means you will be corrupting the database left and
right.
If a shared storage would provide the right locking and visibility
guarantees, and if Firebird would be able to use lockfiles on a shared
storge, it would actually work (that is - if I understood it correctly -
how one of the first Interbase versions worked). However unless access to
that shared storage is fast, performance would probably be worse than using
a single instance. And if the shared storage doesn't provide the right
locking and visibility guarantees, it will corrupt your database.
So short answer: it won't work.
Mark
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> No, it is not. Two firebird server instances cannot access the sameOn the same physical machine it can: that is how Classic Server works.
> database regardless of where it is located.
The major problem is not only shared access to the file (although that can
give some problems), the larger problem is that the lockfiles aren't shared
across machines, which means you will be corrupting the database left and
right.
If a shared storage would provide the right locking and visibility
guarantees, and if Firebird would be able to use lockfiles on a shared
storge, it would actually work (that is - if I understood it correctly -
how one of the first Interbase versions worked). However unless access to
that shared storage is fast, performance would probably be worse than using
a single instance. And if the shared storage doesn't provide the right
locking and visibility guarantees, it will corrupt your database.
So short answer: it won't work.
Mark