Subject Re: [firebird-support] Load balancing
Author Elmar Haneke
Yann RIVIERE schrieb:

> Is anyone have made a load balancing solution between two or more firebird
> motors under linux who access to a unique gdb file on an nfs share??

Im shure that noone has done this and noone will do this successfully
for two reasons:

1. FireBird does not support "Peer-to-Peer" Networking on a single
Database. If You intend to do so you should use SQLite od MS-Access
instead of an Server-based Database as FireBird.

2. "Load Balancing" implys that there is to much DB-traffic to be
handled by an single Server. There is no hope to handle this if a part
of the traffic is moved to the NFS deamon which certainly has to
transport more data. On DB-applications the Bottleneck usually is the
harddisk-performance

I would assume that there is no (serious) server-based database which
does "Load Balancing" this way.

If you intend to have multiple servers for load balancing you will
have multiple copies of your data, one for each server envolved.

Elmar