MUServer and SQL Server separate?

Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Account Upgraded | Title Enabled! Mila is offline
    MemberRank
    Jan 2013 Join Date
    325Posts

    MUServer and SQL Server separate?

    Hi all.
    I wanted to know if it is true that if the MuServer and the SQL Server are in two different host slows the server.
    Currently I have two vps: one has the MuServer with Windows Server 2003 R2 SP2 and the other SQL Server 2008 R2 (Developer Edition) on Windows Server 2008 R2 (Datacenter Edition). Both are in the same datacenter and have the same IP range.

    The reason I did this is because the server and the SQL Server together I consume a lot of RAM.

    This has consequences?

    Thanks!
    Last edited by Mila; 22-03-13 at 05:31 PM.


  2. #2

    Re: MUServer and SQL Server separate?

    Hi ,
    the only reason to do this {in my opinion}
    its to have kind of more secured server , since the server hosted on 1 vps and the website on another , but it doesn't matter , u need to host website on Linux to make ur web secure and such stuff, but i recommend you to stay with win server 2003 , its most stable for MuOnline Serverfiles ,

    well you should test out if it uses more RAM or whether not , since u got the server ready there?
    why dont u check on task mngr.

  3. #3
    ^_^ Ooo Yee is offline
    MemberRank
    Jul 2006 Join Date
    814Posts

    Re: MUServer and SQL Server separate?

    Quote Originally Posted by GanjaMUOnline View Post
    Hi ,
    but i recommend you to stay with win server 2003 , its most stable for MuOnline Serverfiles ,
    lies, supports only old files, almost none of current premium files work on such a old software.

  4. #4

    Re: MUServer and SQL Server separate?

    not lies , well use 2003 and use 2008 , tell me the difference.

  5. #5
    RZ's most loyal knight Dios is offline
    ModeratorRank
    Apr 2005 Join Date
    ArgentinaLocation
    5,238Posts

    Re: MUServer and SQL Server separate?

    It's a great idea if you can afford 2 dedicated servers. Wish I could! But we need more than 2 to make it work.

    IMO the best config would be

    VPS - Website
    Dedicated1 - SQL
    Dedicated2 - MuServer (change useless sata2 for any ssd)

    Expensive tho :P

  6. #6
    Enthusiast 1NightOnly is offline
    MemberRank
    May 2012 Join Date
    44Posts

    Re: MUServer and SQL Server separate?

    Quote Originally Posted by Dios View Post
    It's a great idea if you can afford 2 dedicated servers. Wish I could! But we need more than 2 to make it work.

    IMO the best config would be

    VPS - Website
    Dedicated1 - SQL
    Dedicated2 - MuServer (change useless sata2 for any ssd)

    Expensive tho :P
    well if attack dedicated 1
    then all down
    so no point to waste amount of it to against ddos attack.
    Best solution join the dedicate server with ddos protection.

  7. #7
    Developer nevS is offline
    MemberRank
    Aug 2005 Join Date
    GermanyLocation
    531Posts

    Re: MUServer and SQL Server separate?

    Quote Originally Posted by 1NightOnly View Post
    well if attack dedicated 1
    then all down
    so no point to waste amount of it to against ddos attack.
    Best solution join the dedicate server with ddos protection.
    false... best solution is not exposing the database server to the internet.

  8. #8
    Kingdom of Shadows [RCZ]ShadowKing is offline
    MemberRank
    Jul 2007 Join Date
    1,644Posts

    Re: MUServer and SQL Server separate?

    Quote Originally Posted by 1NightOnly View Post
    well if attack dedicated 1
    then all down
    so no point to waste amount of it to against ddos attack.
    Best solution join the dedicate server with ddos protection.
    SQL dedicated server needs only a private link with muserver dedicated => 100% safe. The only way to access it is via dedicated 2. Almost all datacenters allow you to do this.

  9. #9
    Account Upgraded | Title Enabled! boncha is offline
    MemberRank
    Oct 2008 Join Date
    254Posts

    Re: MUServer and SQL Server separate?

    all of you are 50% right and 50% wrong

    im using 2 diffrent VPS on two server in the same hosting area.
    1 is VPS linux - WEB SITE + FORUM + FTP !
    2 is VPS win 2003 - only for the gameservers + MSSQL .

    two of then are protected with 10GB cisco firewall + antiddos .
    + country ip filter that blocks the all country if attack is detected.

    in total is costing me like a 100$ for month.
    the windows server ports are only open for the linux server so he can access mssql database.

  10. #10
    ^_^ Ooo Yee is offline
    MemberRank
    Jul 2006 Join Date
    814Posts

    Re: MUServer and SQL Server separate?

    Quote Originally Posted by boncha View Post
    all of you are 50% right and 50% wrong

    im using 2 diffrent VPS on two server in the same hosting area.
    1 is VPS linux - WEB SITE + FORUM + FTP !
    2 is VPS win 2003 - only for the gameservers + MSSQL .

    two of then are protected with 10GB cisco firewall + antiddos .
    + country ip filter that blocks the all country if attack is detected.

    in total is costing me like a 100$ for month.
    the windows server ports are only open for the linux server so he can access mssql database.
    what hosting is that? share knowledge :)

  11. #11
    RZ's most loyal knight Dios is offline
    ModeratorRank
    Apr 2005 Join Date
    ArgentinaLocation
    5,238Posts

    Re: MUServer and SQL Server separate?

    Quote Originally Posted by boncha View Post
    all of you are 50% right and 50% wrong

    im using 2 diffrent VPS on two server in the same hosting area.
    1 is VPS linux - WEB SITE + FORUM + FTP !
    2 is VPS win 2003 - only for the gameservers + MSSQL .

    two of then are protected with 10GB cisco firewall + antiddos .
    + country ip filter that blocks the all country if attack is detected.

    in total is costing me like a 100$ for month.
    the windows server ports are only open for the linux server so he can access mssql database.
    Also, how many players are you hosting? I would like to see you host 1000+ on a vps :P (I would like to see 200 on a vps! :P)

  12. #12
    DBO Freak xDarKyx is offline
    MemberRank
    Mar 2011 Join Date
    280Posts

    Re: MUServer and SQL Server separate?

    Quote Originally Posted by boncha View Post
    the windows server ports are only open for the linux server so he can access mssql database.
    You probably mean the MSSQL port is only open for the linux VPS.
    If not it would mean that no one could join the server.

  13. #13
    Account Upgraded | Title Enabled! boncha is offline
    MemberRank
    Oct 2008 Join Date
    254Posts

    Re: MUServer and SQL Server separate?

    Quote Originally Posted by Dios View Post
    Also, how many players are you hosting? I would like to see you host 1000+ on a vps :P (I would like to see 200 on a vps! :P)
    its a very strong vps .
    500+ online every day .

    xDarKyx : yea dude

  14. #14
    Proficient Member HappyDay is offline
    MemberRank
    Jan 2012 Join Date
    inline floatLocation
    170Posts

    Re: MUServer and SQL Server separate?

    2 or more servers for 100% safe? DDOS protection? "netstat -b"(show main.exe connection), and tell about protection you provider ;) rly - it can protect you only if it LOIC.

  15. #15
    Valued Member LoveBol is offline
    MemberRank
    Jul 2008 Join Date
    126Posts

    Re: MUServer and SQL Server separate?

    I used 2 Servers, One for SQL and WEB, One for GameServer

    Each Server have 2 NIC and I used one of NIC for Local connect, (NIC TO NIC) and set the IP for local connect SQL



Page 1 of 2 12 LastLast

Advertisement