--- In [email protected], "raja_s_patil" <kpr.rspatil@...> wrote: > > hello, > > We have been using Firebird since it became Opensource. We have done many lan > Based projects with it and have enjoyed great success. > > Now we are doing a Big web application where scaling, HA and failover > capabilities are to be implemented. Its a Flex, Spring, myBatis Firebird > stack using Tomcat as Application server. Database is being replicated to > Backup Server with help of Symmetric DS for backup purpose as well to isolate > Interactive application from High Processing/Reporting Application. These > applications are using backup database in Read Only mode. For HA and > scalability we plan to use Tomcat Clustering and HA Proxy for Load balancing. > > Now Only part remaining is Scalability and HA for main database. So far till > date in Lan environments Firebird has proved to be Most Reliable and Highly > Available in very adverse conditions like frequent power outages, we have not > noticed a single event of database corruption. But things are different in > this project, client appointed expert is demanding clustering kind of setup > for database server too. > > So Firebird experts please guide us with possible alternatives for this > scenario. As far as we are concerned we would like to stick to Firebird since > it has conquered our trust.
Firebird HA can be achievied today with replication and using a heartbeat like in the Linux-HA project http://lists.linux-ha.org/pipermail/linux-ha-dev/2010-November/017894.html http://en.wikipedia.org/wiki/Linux-HA Scaling firebird to work on multiple machines and to distribute the load (CPU+IO read/writes) it is possible only if you create a smart proxy that can distribute the reads and writes http://ha-jdbc.github.com/doc.html
