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?
- Single shared storage that store database file on SAN
- 4 firebird VPSes connect to the shared storage via NFS
- a load balancer vps ( any suggestion?)
My system will be 50:50 read : write with transaction. What kind of server should i choose? SC, SS or mix?
Thank you!
Best Answer
If you have more than one cpu on the server you need to use Super Classic
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/qsg25-classic-or-super.html
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)