Actually, the telecom standard is 99.999% uptime which is referred to as a "Five-Nines" system and we have had this for over a decade with Firebird, running 24/7/365.
Our transaction count is quite high, if you consider the number of databases being queried in parallel to perform the various tasks, we are orders of magnitude higher than 10 million transactions a day on the OLTP systems alone. Consider this, all of our OLTP systems are real time - consider how upset you would be if you had to wait for dialtone when you picked up your phone due to a slow query. That is correct, the very act of picking up your handset sets off a series of queries that range from who is managing the local line-pair down to if you have messages waiting. We use a combination of techniques, which allows us to load balance and add/remove systems/databases from the clusters. You can put together a five nines system with Firebird, spanning multiple databases, multiple servers, multiple pops with full failover redundancy. This is a matter of proper design and implementation. We are doing this with firebird 1.5 and a series of custom c/c++ multi-tier software. We are currently testing the same solution using Firebird 2.5 with the database acting as it's own middle tier. This problem can be dealt with by the developer, although I am partial to the 64 bit transaction id's, I do not see this as something that the developers need to spend a great deal of time on. regards Dalton On 3 January 2012 14:10, Adriano dos Santos Fernandes <[email protected]> wrote: > Just throwing another thing: Isn't some form of journaling expected to > appear in Firebird, as I've heard in the past? > > If yes, the journal could be used to consolidade old transaction in one > and implement the thing about adjusting the transaction number and > making it overlap as I said previously, without needing to scan the > whole database. > > > Adriano > > > ------------------------------------------------------------------------------ > Write once. Port to many. > Get the SDK and tools to simplify cross-platform app development. Create > new or port existing apps to sell to consumers worldwide. Explore the > Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join > http://p.sf.net/sfu/intel-appdev > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel ------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
