Two way sync possible with server interal and in dmz?

[André Schild]

Hello,

this question had been asked 5 years ago here https://sourceforge.net/p/symmetricds/discussion/739236/thread/72a5fb89/

Is the answer still valid?

Basically we have a internal MsSql server and one replica in the DMZ.
The connection from the internal network to the DMZ is allowed.
The connection from the DMZ to the internal network is NOT allowed.

The database in the DMZ is 90% readonly, but 10% write which should make it back into the internal DB.

Will this work with SymmetricDS?

Thanks

[vilpan]

Should work just fine if you place both engines (a single engine works with a single database) in the intranet (possibly on the same machine and in the same process).

     Intranet                                       DMZ
                       _____________________ 
.----------------.    |___|___|___|___|___|_|    _.-----._  
|  SymmetricDS   |    |_|___|___|___|___|___|  .-         -.
|----------------|    |___|___|JDBC___|___|_|  |-_       _-|
| mainDB engine  |---------------------------->|  ~-----~  |
| replica engine |    |___|___|___|___|___|_|  |  replica  |
'----------------'    |_|___|___|___|___|___|  `._       _.'
         |            |___|___|___|___|___|_|     "-----"   
         |JDBC         _____________________ 
         v            |___|___|___|___|___|_|
     _.-----._        |_|___|___|___|___|___|
   .-         -.      |___|___|___|___|___|_|
   |-_       _-|       _____________________ 
   |  ~-----~  |      |___|___|___|___|___|_|
   |  MS SQL   |      |_|___|___|___|___|___|
   `._       _.'      |___|___|___|___|___|_|
      "-----"   

You may also find this article useful http://www.jumpmind.com/blog/multi-homed-vs-remote-nodes .

[André Schild]

Thanks a lot.
Will give it a try.