> - Have ONE central server
>
> Agreed
yup :)
> - IB can not do server2.login.server2DB.server2StoredProc BUT instead of
> using triggers / stored procedures to do this we could use TIBEvents to get
> round this.
>
> So assuming we use TIBEvents we could then have IB Server running on the
> master(s) and Local IB running on the slaves as those apps would receive an
> event from TIBEvents and make the change locally. However (Help is not
> clear) TIBEvents allows only 15 events per component. What is an event?? Is
> it:
>
> - UPDATE SomeTable and this relates to all updates OR
> - Ev1: UPDATE Table1, Ev2: UPDATE Table2 etc.
you would, in this case, have 1 central server still, but have all the
clients pointed to it - and the ones that need to know when something
happens would register events, and get told. The rest would just push
data in.
There is a demo of it being used in c:\program
files\borland\delphi5\demos\db\ibdemo
begin
post_event :event;
end
(where :event is the "message" posted in a param to the SP)
That way, you could start a transaction, load your data, then fire this
SP off with a "eventname" of whatever you wanted.
Still only one server tho :)
> No offence taken *smile*. Not sure I understand. I do want to write a solid
> app and it will be well tested etc. etc. However if I can get away with
> doing what I am proposing at the top of this mail and not going MIDAS, nTier
> I would be happier......
You dont need to go nTier here at all - but I also dont think you need
to have a failover database situation either!
Event alerters would allow you to get the MOM-style capabilities without
the expense (IBM's MQSeries is expensive, MS's MSMQ is, well, from
Microsoft....), and also without the expense of polling the DB every few
seconds for new data - the server would tell the client when to pick up
the new data, 'cos the input server would have just called something to
say "OK, I'm done, go tell all the clients to get it now please"
N
--
Nic Wise - Chief SCUD Launcher - Inprise/Borland New Zealand
wk: 09.481.9999 x9753 cell: 021.676.418
em: [EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
