Connecting Two Dedicated Servers To the same Dattabase

Results 1 to 7 of 7
  1. #1
    Enthusiast Mikee is offline
    MemberRank
    Apr 2011 Join Date
    36Posts

    Connecting Two Dedicated Servers To the same Dattabase

    hey friends i was just wondering that is it possible to connect two dedicated pc to the same database.
    i know a3 works on a local host but still..
    i have seen foreign players laggin in indian servers so was just thinking of sumthng new which wud help.
    If any1 has any other suggestion regarding lag reduction it wud be welcomed


  2. #2
    Ŋ cvrdheeraj is offline
    MemberRank
    Jul 2006 Join Date
    IndiaLocation
    1,210Posts

    Re: Connecting Two Dedicated Servers To the same Dattabase

    Quote Originally Posted by Mikee View Post
    hey friends i was just wondering that is it possible to connect two dedicated pc to the same database.
    i know a3 works on a local host but still..
    i have seen foreign players laggin in indian servers so was just thinking of sumthng new which wud help.
    If any1 has any other suggestion regarding lag reduction it wud be welcomed
    You will face concurrency issues.

  3. #3
    Noob Prot is offline
    MemberRank
    Jan 2007 Join Date
    Gurgaon, IndiaLocation
    517Posts

    Re: Connecting Two Dedicated Servers To the same Dattabase

    well even if you succeed.. both will be 2 different worlds.. (players wont be able to see each other)
    so as per me.. not worth giving a try!

  4. #4
    Apprentice Newtroj is offline
    MemberRank
    Dec 2009 Join Date
    17Posts

    Re: Connecting Two Dedicated Servers To the same Dattabase

    if you keep zone server in a dedicated, and all other programs in other dedicated, won't help with lag?
    i think u can do this only changing some ips.

    if you want to keep all programs in one dedicated and the database in other dedicated, u must to do some tests...

    i think that the programs like 7770, 8880, 9990, only run on the dedicated with the database because they dont have an ip on the files ".ini", try this or...
    HEX these programs (7770, 8880, 9990) and you will find a "127.0.0.1" ip.

    u probably must find all files ".ini" that have an ip, and verify if you must change this ip... an exemple:
    CharacDBIP=127.0.0.1
    StorageDBIP=127.0.0.1

    probably you must change them... u must test this...

    i dont know if the ODBC must stay on the dedicated that have the database, but i think that ODBC must stay on the dedicated that have your programs of the server, so i think you must change the connectivity of them to ip of your dedicated with the database, u must test this too...

    so if you really want, you have a lot of work.
    Last edited by Newtroj; 07-01-12 at 06:10 AM. Reason: sorry, bad english...

  5. #5
    Noob Prot is offline
    MemberRank
    Jan 2007 Join Date
    Gurgaon, IndiaLocation
    517Posts

    Re: Connecting Two Dedicated Servers To the same Dattabase

    will this resolve the issue?
    his issue is that if the dedicated server is in US then Indian players will face lag and if server is in India then US players will face lag.. so he wants to host the server both in India and US (US players will connect to US server and Indian players will connect to Indian server) and wants both server to act as both are same server and players can interact with each other. (which i dont think is possible for A3's current server files)

  6. #6
    Goodbye chrissdegrece is offline
    MemberRank
    Oct 2009 Join Date
    GreeceLocation
    1,015Posts

    Re: Connecting Two Dedicated Servers To the same Dattabase

    Not possible, game data reside in memory. Frequent saves are done in DB for items, NPCs, EXP etc. But real-time data are kept in memory.

    If he wants better pings then he should host in a "central" country to balance pings between India and other countries. Other solutions are far more expensive especially for A3 which has a very low online players average.

  7. #7
    Ŋ cvrdheeraj is offline
    MemberRank
    Jul 2006 Join Date
    IndiaLocation
    1,210Posts

    Re: Connecting Two Dedicated Servers To the same Dattabase

    Quote Originally Posted by chrissdegrece View Post
    Not possible, game data reside in memory. Frequent saves are done in DB for items, NPCs, EXP etc. But real-time data are kept in memory.

    If he wants better pings then he should host in a "central" country to balance pings between India and other countries. Other solutions are far more expensive especially for A3 which has a very low online players average.
    Agreed. Instead of splitting up the server, It would be better to speak to your ISP and setup a low latency link with any overseas ISP to facilitate least pings possible. You could then relay the data from the players via the overseas server which would save some latency provided the interconnectivity between home and overseas servers are rock solid.



Advertisement