[Spread-users] Newbie Questions

[John Robinson]

Hi Eduardo,

You are really talking about designing a distributed transaction
processing sytstem.  I might suggest for starters that you read Gray
and Reuter, "Transaction Procesing: Concepts and Techniques".  I
expect you'll find that you want a proper DBMS running on each system
(server and POS) that can handle distributed two-phase commit.

/jr
---
Eduardo Ferro Aldama wrote:
> Hi everybody!
> 
> I am testing spread toolkit to implement the comunication between
> Tills/PointOfSales systems and a store server for a store system and
> I have some dudes about the functionality and use of spread.
> 
> First some facts about the enviroment:
> - All my tests are develop with spread 3.17.03 using the python wrapper
> (Spread Module 1.5).
> - For this first test I am running all the programs in the same machine.
> 
> 
> The system should not lost any of the PointOfSales sales information. The
> problem is that sometimes the network is down from few minutes to two 
> days or more. I think that I should use SAFE_MESS type of messages,b ut 
> in the test when I send more rapid that the other program can process 
> the information the send call fail (-8 connection closed by spread). I 
> suposse that the spread daemon don't save the messages in a persistent 
> media so I can lost messages....
> 
> -what should do to garantee that all the sales go to the store server???
> (without any losses and in the same order that the clients generate de 
> information)
> -Should I insert into a DB on the client, send to the store server and 
> insert
> in a DB??? (like a persistent Queues)
> -Can the receptor program ack the message after it process it? (to prevent
> power failures between the msg reception and its process)
> - Some hint/docs/ideas about the desing the comunication solution of 
> this kind of systems (N info producers and 1 info receptor/processor)?
> 
> 
> 
> Thanks in advance
> 
> Sorry for my english
> 
> --
> 
> Eduardo Ferro Aldama
> Desarrollo TPVs (Gestión Stock)
> Tlf 91 5142101
> Ext:2101
> 
> /Ce message électronique et tous les fichiers attachés sont 
> confidentiels et destinés exclusivement à l'usage de la personne à 
> laquelle ils sont adressés. Si vous n'êtes pas le destinataire de ce 
> message, merci d'avertir ou de le retourner à son émetteur et détruire 
> ce message électronique et tous les fichiers attachés de votre système 
> informatique. La publication, l'usage, la distribution, l'impression ou 
> la copie non autorisée de ce message et des attachements qu'il contient 
> sont strictement interdits./
> 
> /This e-mail and any attachment are confidential and intended solely for 
> the use of the individual to whom it is addressed. If you are not the 
> intended recipient, please telephone or email the sender and delete this 
> message and any attachment from your system. Unauthorized publication, 
> use, dissemination, forwarding, printing or copying of this e-mail and 
> its associated attachments is strictly prohibited./
> 
> /Este correo electrónico y todos los ficheros adjuntos son 
> confidenciales y destinados exclusivamente al uso de la persona a la 
> cual han sido remitidos. //Si Usted no es el destinatario del mensaje, 
> agradecemos advierta al remitente y elimine el mensaje y sus adjuntos de 
> su sistema. //La publicación, distribución, impresión o copia no 
> autorizada de este mensaje y de sus adjuntos queda estrictamente prohibida./
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Spread-users mailing list
> Spread-users at lists.spread.org
> http://lists.spread.org/mailman/listinfo/spread-users