Re: [Firebird-devel] Firebird Uptime/SLA (was: Firebird Transaction ID limit solution)

[Dalton C. <dal...@gm...>]

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
<adr...@gm...> 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