Set up Firebird with shared storage?

Question

I am new to firebird and confused with SuperServer SuperClassic thing.

But what i wonder is how should i set up this scenario on Linux?

My system will be 50:50 read : write with transaction. What kind of server should i choose? SC, SS or mix?

Thank you!

One database can only be accessed by a single database server. SuperClassic, SuperServer is irrelevant here as it only defines how the server process internally works. Databases should never be stored on a shared filesystem. — a_horse_with_no_name, May 17 '14 at 8:50

Mariuz · Accepted Answer · 2014-03-12 12:04:27Z

2

If you have more than one cpu on the server you need to use Super Classic

Also we need more info on the arhitecture that you want to create I would avoid point 2 (firebird doesn't work on shared nfs)

answered Mar 12 '14 at 12:04

Mariuz

1312 bronze badges

Thank you for the suggestion on Super Classic, @Mariuz What do you suggest to setup a shared storage for Firebird? I'm still wonder in case it's not going to work on shared NFS. (I've done successfully with PostgreSQL before) – Worajedt S Apr 17 '14 at 6:07
1

@WorajedtS: using a single shared storage for multiple database instances is certainly not possible in Postgres (and I don't think it's possible in Firebird either) so I don't understand what exactly you want to do. Of course you can store the database files on a SAN (although it's probably not a good idea) but that can still be accessed only by a single server process. – a_horse_with_no_name May 17 '14 at 8:47

add a comment |

1 Answer 1