MUServer and SQL Server separate?

[Mila]

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!

 

[KarLi]

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.

 

[Ooo Yee]

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.

 

[KarLi]

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

 

[Dios]

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

 

[1NightOnly]

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

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.

 

[nevS]

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.

 

[[RCZ]ShadowKing]

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.

 

[boncha]

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.

 

[Ooo Yee]

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

 

[Dios]

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 (I would like to see 200 on a vps! )

 

[xDarKyx]

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.

 

[boncha]

Also, how many players are you hosting? I would like to see you host 1000+ on a vps (I would like to see 200 on a vps! )

its a very strong vps .
500+ online every day .

xDarKyx : yea dude

 

[HappyDay]

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.

 

[LoveBol]

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

 

[hntri]

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!

That ok.

In mssql server : you only run titanserver( in config file add ip of muserver)
In muserver u only run : bor connect, gamesserver ( config ip of mssql )

Solution for u :
- I have web for muserver it have 2 part ( 1 only run in your server and save all yr information of yr db. 1 run in hosting only a templa)

Solution :
-mssql server : mssql + base server source web
-mu server : bor, gameserrver.
- hosting : client web source ( becare check that hosting ,which can not local hack like shell,....)

If u want to setup. I will do it for u.

 

[Locomoto]

I don't recommend running a server between 2 machines. There will be gaps in network latency & the cost to run both machines will be expensive.

 

[hntri]

I don't recommend running a server between 2 machines. There will be gaps in network latency & the cost to run both machines will be expensive.

No problem with it,man.
If 2 server in sảme datacenter. The network, which tranfer server to server less 1000mbs (local Lan)

- and if u wanna open 2-3 or 10 muserver, u only need mssql server or 1 database. That is best solution for u

About website:
- the host or yr vps ,which support anti-ddos is very expensive.

U need 1 solution about that.
If u put website in muserver, they ddos yr wweb --> server u die
If u use web with 2 part of wweb, they dont know yr ipserver,... They only ddos in hosting --web die ,yr server is not problem

 

[theguyontherun]

Hey there; having sql and mu on different servers will only slow you down if you have lag between the sql and mu. If they are within the same network it wont matter as the comm. between the 2 wont suffer much. If they are across the web then you may increase the lag.

If you are doing this simply because of more security; then all you have to do is lock down all unused ports put sql on a non-standard port; change mu ports as well. Set your firewall to stop fragmented packets and make sure to keep an eye on fake/malicious packets. Also, monitor your network traffic and dont be afraid to block ip ranges, if you block a few good apples along with a lot of bad apples; the rest of the server population will gain in the end and you will get more traffic.