← Back to team overview

openerp-community team mailing list archive

Re: Strategy for database replication

 

Hello,

NX is really a great solution, allowing you to use GTK from everywhere. NoMachine even allow a "web companion" that can run a session from browser (easier to deploy). I use it everyday from several access and it is quite as fast as a local install, but my experience showed me that NX protocol become unstable when ping time raise upper than 200ms. Anyway the web interface (that became more reactive in 6.1 version with AJAX) should be usable from everywhere.

In my mind using a synchronous database from several access is easier to implement this way than doing a 2-points sync database that can lead to a split-brain if connection is lost (so blocking each part instead of blocking only one for NX/web access) and will be slow on each request.

Another solution can be to create a satellite database and often sync/import it into main database, but this would need quite more work.

Anyway I have a draft demo version of NX/OERP online (servers are in switzerland). I can provide you access code if you want to run a simple test from China. Just ask me.

Best regards

Nicolas


On 08. 05. 12 18:13, Mario Arias wrote:
+1

Not sure how many users would be connecting from France, but access thru VPN or remote desktops will surely provoke less maintenance problems...

You can measure network comsumption to the OpenERP server on their France location, and then check if you can provide that between offices...

Regards,
-Mario


On Tue, May 8, 2012 at 1:12 AM, Dominique Chabord <dominique.chabord@xxxxxxxxxx <mailto:dominique.chabord@xxxxxxxxxx>> wrote:

    Hello

    Le 08/05/2012 04:20, Eric Caudal a écrit :
    > Hi,
    > I have a customer with implantations in France and China. He
    wants to
    > use the same data for both countries in the same OpenERP database.
    > Nevertheless, Internet connexion is a little bit bumpy from/to
    China so
    > he would like to create a bi-directional replication scheme
    between both
    > countries.

    I would first consider a simple remote desktop like NX instead, and
    locate server and desktops in a datacenter. This is a cheap and secure
    solution I propose on my hosting for distant countries.

    regards

    --
    Dominique Chabord - SISalp
    Logiciel libre pour l'entreprise : Gestion OpenERP et Tryton
    18 avenue Beauregard 74960 Cran Gevrier
    145A rue Alexandre Borrely 83000 Toulon
    tél +33(0)950274960 <tel:%2B33%280%29950274960> fax
    +33(0)955274960 <tel:%2B33%280%29955274960> mob +33(0)622616438
    <tel:%2B33%280%29622616438>
    http://sisalp.fr

    _______________________________________________
    Mailing list: https://launchpad.net/~openerp-community
    <https://launchpad.net/%7Eopenerp-community>
    Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
    <mailto:openerp-community@xxxxxxxxxxxxxxxxxxx>
    Unsubscribe : https://launchpad.net/~openerp-community
    <https://launchpad.net/%7Eopenerp-community>
    More help   : https://help.launchpad.net/ListHelp




_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp


References