how to make communication between two different server

Discussion in 'Site & Server Administration' started by RinoAlain, Aug 28, 2009.

0
  1. #1
    Hi this is vasanth am working in china in a s/w company.

    how to make communication between 2 different server. in my situtation our office is in 2 different country. i.e China & Swizerland. Data must transfer from china country server to Swizerland country server continously. Normally i will do all my key-in works in china and it will be store in china server DB (want to pass to DB of swizerland server). if internet connection between china sever and swizerland server disconnected means last updated data's must be refelect in DB of swizerland server also.
     
    RinoAlain, Aug 28, 2009 IP
  2. Freewebspace

    Freewebspace Notable Member

    Messages:
    6,213
    Likes Received:
    370
    Best Answers:
    0
    Trophy Points:
    275
    #2
    You can do it via FTP ..between two servers?

    Whether these two servers are windows or Linux??
     
    Freewebspace, Aug 28, 2009 IP
  3. RinoAlain

    RinoAlain Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanks for ur reply.

    it's an windows server. how can i use FTP. what r the thing i need to know for FTP concept
     
    RinoAlain, Aug 29, 2009 IP
  4. Bohra

    Bohra Prominent Member

    Messages:
    12,573
    Likes Received:
    537
    Best Answers:
    0
    Trophy Points:
    310
    #4
    Bohra, Aug 29, 2009 IP
  5. GNetCoder

    GNetCoder Peon

    Messages:
    68
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #5
    If you are passing data between databases, you will want to look into the remote versions of the 'slave' or 'replication' features of your DB software. For MySQL you can look here: MySQL Replication. Be sure to check the security features; It would not be nice to send customer data in the clear to a remote database :)

    You can do FTP, but the question is how recent the 'slave' DB needs to be; In the case of MySQL, you can do a periodic mysqldump, FTP (SFTP or better - SSH) the result to the remote and then load the data to the remote DB.
     
    GNetCoder, Aug 31, 2009 IP
  6. efslms

    efslms Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    hi,

    i'm in need to transfer some files from internet(html links) to ftp server.. can i do that without downloading to local and then uploading.... ;)
     
    efslms, Sep 1, 2009 IP
  7. GNetCoder

    GNetCoder Peon

    Messages:
    68
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #7
    If your FTP server is a linux OS, log in to the terminal and use wget.
     
    GNetCoder, Sep 1, 2009 IP
  8. efslms

    efslms Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    No yaar.. that is yahoo server.. can i able to download thro' some server side script like php...........
     
    efslms, Sep 1, 2009 IP
  9. RinoAlain

    RinoAlain Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Thanks for ur reply Gnetcoder..

    Actually we are plan to use SQL Server 2008 with Replication package for designing. do u have have documents for installing SQL server with Replication concept. Do u have any material
     
    RinoAlain, Sep 3, 2009 IP
  10. GNetCoder

    GNetCoder Peon

    Messages:
    68
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Sorry, I m really not that familiar with SQL server; Maybe someone in the forum has some experience? I did a quick google for 'sql server replication' and came up with some hits; you might start there to look for some relevant info.
     
    GNetCoder, Sep 3, 2009 IP