Subject Re: [firebird-support] Re: Clustering
Author Martijn Tonies

> > > I understand that Firebird doesn't have any built-in clustering.
> > >
> > > Can anyone recommend any tools to be able to cluster Firebird?
> > >
> > > Any real-life experiences?
> >
> > Please define "clustering" - do you mean one service taking
> > over of another after the it has failed? (crashed)
> >
> > Or do you mean two services on two machines using the
> > same physical datafiles?
> Errr...anything that will allow us to scale!!
> I'm a beginner at all this, but I would say that we are looking to
> run database on a cluster of machines in such a way that they all
> **share** the load. This, I am assuming, will also provide failover
> for free - if one of them crashes, the others will carry on.

As far as I know, Firebird does not support this.

The easiest way to get some scaling is by using the
Firebird classic server and throw as many CPUs
against it as you can, add lots of memory and you
should be fine for a lot of users.

Failover shall have to be handled differently.

> Any ideas on how to implement this with Firebird, and what tools
> would help?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions