Hi Calogero,
I took a short look at your scenario and i think sequoia is not the
right technique for your needs. You want datareplication between client
databases and a centralized db. Sequoia isn't doing replication per
demand ("Client initiated replication request" on your slides)
Sequoia is doing replication for each SQL-INSERT/UPDATE statement. Thats
even better than replication per demand, but getting this feature, you
have to handle some other problems.The main problem i see is connectivity. Your clients must always be connected to the server. cause on both machine a sequioa controller is running. Always does mean always, if there is a minute or so of non connectivity your databases arent in sync anymore. And from personal experience, i can tell you connectivty over the Internet isn't working for sequoia (see #957) So you need a simpler replication solution for your problems (for example dbmirror) or do this stuff by yourself by dumping your tables and transfering them to the clients on demand. HTH Stefan replication request Calogero Provenzano wrote: > Hi all, > > find attached a slide that shows a more detailed scenario: > > 1) Server's Virtual Database contains irrigation data that are periodically > updated by us; server guarantees high availability by means of Sequoia > 2) Every client authenticates with server, connects asynchronously to virtual > database and synchronizes changes using a secure communication channel (i.e. > SSL): a possible use case could be the following: user clicks on a button > located on client GUI and synchronization starts: after updating local > database, user can use new irrigation data in his simulations. > > In this scenario could we use an installation of Sequoia on client PC in > order to synchronize local database with server database using a secure > communication channel. > > Thank you very much in advance! > Best Regards, > Calogero Provenzano > ----- Original Message ----- > From: Calogero Provenzano > To: [email protected] > Sent: Saturday, July 14, 2007 10:32 AM > Subject: Request for info about Sequoia > > > Hi, > > I'm Irriworks' Technical Leader (Irriworks is a small enterprise that > produces and sells software for irrigation sector): we are developing a > client/server application that allows customer to design irrigation systems. > Here a brief description of our product: > > - client: it is a java application developed using RCP technology; we are > currently implementing it and it is designed in order to retrieve data from a > local database. Data are then used by application to design irrigation > system. Another important info: local data are updated connecting to server > > - server: our server is under a design phase now; we think to implement web > services (or another technology that you can suggest us) that allow clients > to retrieve data updates from a virtual database that guarantees high > availability by means of Sequoia > > The question is: is it possible to use another installation of Sequoia on > our cutomers PCs in order to replicate server and client databases as well? > The configuration is a master/slaves one, where the slaves are clients that > connects asynchronously to our server to download updates to store in their > local database. > Feel free to suggest us another solution that allows us to implement > clients/server replication > > Thank you in advance for your collaboration. > Best Regards > > > +----------------------------------------------------------------------+ > | Z1 SecureMail Gateway Info - http://www.zertificon.com | > +----------------------------------------------------------------------+ > | - Die Nachricht war weder verschluesselt noch digital unterschrieben | > +----------------------------------------------------------------------+ > > > > ------------------------------------------------------------------------ > > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia -- Zertificon Solutions GmbH Landsberger Allee 117, 10407 Berlin, Germany GF: Herbert Nebel, Dr. Burkhard Wiegel HRB 94059, AG Berlin-Charlottenburg http://www.zertificon.com https://www.globaltrustpoint.com/[EMAIL PROTECTED] +49 (0)30-5900 300-0 (fax -99) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "Z1 SecureMail" by Zertificon ...the leading server solutions for Secure & Trustable E-Mail Try our Policy controlled S/MIME & OpenPGP & HTTPS Messaging!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
