|Subject||RE: [firebird-support] Firebird Replication/Cluster with Fail over|
> Hi AllI've been replicating my clients' databases for ten years now. They've never
> We currently are running 3 firebird (v1.5 classic) servers, one
> live , one fail-over and one DR site.
> The fail over gets a restore from a backup made every 2 hours on the
> live server (via Gbak)
> and the DR site gets a copy manually every thur
> This is obviously pretty inadequate, and no where near ideal for our
> company. (and at worse case the data's 2hours out of date if only an
> onsite problem with the main server, alot worse if the whole site is
> we're a 24/7 call centre which needs a replicated fail over DB just
> incase etc (also one at a DR site connected via a rather slow adsl
> connection, but thats another matter possibly..)
> So I'm lookin for any help/idea's from you well clued up types :)
> FB is all pretty new to me and from what i can tell replicaton on it
> is pretty lousy (prove me wrong please!!)
> I've looked at the various options, and they all seem to run via
> triggers and only really replicate update/delete/insert statements.
> And im wary at the problems of sync'ed data should the wan link go
> down to our DR site.
had to hot swap in vein, only tests) but if they ever did they'd be a
maximum of 5 minutes behind. That's likely to be 2 minutes.
- triggers and only really replicate update/delete/insert statements -
what else IS replication? The beauty of this method is the disjointing
associated with the separation of file system methods. You get back to FB
client/server comms. With the core methods of replication, it's very easy to
immediately replicate a corruption and by the time you find out, it's too
IBPhoenix.com has the list of available systems.
> Clustering seemed an option, but it seems from previous posts that
> this isnt much of an option due to the shared memory locks?
> Anyhow ideas/suggestions much appriecated.
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
> Also search the knowledgebases at http://www.ibphoenix.com
> Yahoo! Groups Links