Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2005
    Posts
    3

    Question Unanswered: Database Synchronizations

    Hi,

    recently we implemented Microsoft Dynamics and a customized Retail System of whihc having separate database files respectively and both resides on HP ML570 Xeon Dual, 300GB with 2GB RAM. All the remote and local users access this server for data.

    Due to heavy transaction input to the server from remote users using CITRIX are facing tremendous slow in output and frequently hangs. What we have deiced now is to separate the databases to two servers in order to balance the load to office and remote users. But accodring to the development of software it is mandatory to synchronize both databases. Is this possible to do with proper ODBC setup and what's the percentage of performance we can gain from this change.

    Thanks and best regards,

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    Hi,
    do you separate server (in the same location), and later sync the db. And the remote user access a server and the local user another?

    Why not make a cluster server? (this is a perfect work load balance)

  3. #3
    Join Date
    Aug 2004
    Location
    Calgary, Alberta
    Posts
    106
    You should be able to accomplish this synchronization with transactional replication. My understanding is that you have two instances which you need to synchronize, correct?

    Even if you did cluster them, you would still have 2 instances?

    Peace,
    -Kilka
    There is nothing more helpless and irresponsible than a man in the depths of an ether binge. -HST

  4. #4
    Join Date
    Apr 2005
    Posts
    3
    Hi,

    Thanks for your reply. We are intending to keep two servers. Is it possible to synchronize the server on hourly basis as it have interconnected data which requries updating of office users to remote users database?

    best regards,

  5. #5
    Join Date
    Apr 2005
    Posts
    3
    Hi kilka,

    Thanks for your update. Yes we have two instances which need to synchronize. Will it be possible to handle even with clustering? What if we keep two servers?

    best regards,

  6. #6
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    transactional replication can be near instantaneous. i am not sure if Great Pains or whatever they are calling it now supports this. I would check with your over priced implimentation consultant.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  7. #7
    Join Date
    Aug 2004
    Location
    Calgary, Alberta
    Posts
    106
    Hey Imthiyaz,

    Like Thrasymachus said, transactional replication can be near instantaneous. Do you know if you're application can tolerate a couple seconds of latency. Also, you meantioned that there are office users and remote users?

    peace,
    -kilka
    There is nothing more helpless and irresponsible than a man in the depths of an ether binge. -HST

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •