Subject scalability how to?
Author Richard Salt
Does anyone have any suggestions on how to take the guesswork out of scaling/load balancing the number of databases/connections per Firebird server?

We currently have 60 fdb's with a potential of 150 connections being serviced by one Firebird 1.5.1 (nptl) server running on a Linux (Mandrake 10.0) box with 2GB ram. Our delphi apps use ibobjects: the transaction objects are all set to tiCommited and we avoid long transactions. It has been necessary to increase LockMemSize & EventMemSize. It typically works well, but we do occasionally have unexplained crashes.

The number of databases & connections is growing each month and I am mindful of if/when to balance the load onto another physical server.

I have written scripts that log the fbserver's processor and memory useage, but this seems fairly meaningless without knowing the useage patterns of the users. Is there any Firebird monitoring software that might help?

Best Regards
Richard Salt