Server Specs, SQL Questions

I have a few questions regarding Mu Online private servers.
1. In most of the tutorials on this forum, I have seen that people use Microsoft SQL Server. Would it possible to substitute that for MySQL, or is MSSQL the only solution?
2. What kind of server specs are needed to support a large userbase Mu Online private server? How important is clock speed, number of cores, RAM, and hard drive speed? How does each contribute to the server performance? Lastly, regarding the number of cores, are private servers multi-threaded, or is it only a single-thread application?

As time goes by, and if you're server getting more characters, you need to have memory [disk] to accommodate all of this, and also, to prevent lag, the speed of your internet and server [ pc ] must be also in priority. This is my own understanding, correct me if im wrong =]

Quote:

---

Originally Posted by Chippu

As time goes by, and if you're server getting more characters, you need to have memory [disk] to accommodate all of this, and also, to prevent lag, the speed of your internet and server [ pc ] must be also in priority. This is my own understanding, correct me if im wrong =]

---

How about SQL/clock speed/number of cores?
Internet speed is not an issue, it will be a dedicated server.

In my opinion (and experience after 6 years) its very important how many cores, ram, etc. But the most important aspect for us were disks. Sata disks could not keep up with us. ATM we are running 2x300gb 15.000rpm disks that seem to be able to handle the load quite nicely. How many players do you have? If you are recently opening a server just use normal sata until you see they are not enough. If you have over 1000 online then you'll need raptors or scsi.

ATM using:

Dual Processor Quad Core Xeon 5620 - 2.40GHz (8x2.40GHz | 2x12MB cache W/HT)
12.288Mb (12GB DDR3 1333 MHz)
2x 300GB SA-SCSI 15.000 RPM
100Mb download/100Mb upload

Ram usage is near 4gb and cpu usage is between 15% to 30%

10/10mb will do just fine, we are using 3mb/3mb max so the 100mb is just for show off IMO. Most good hosting services will give you the 100mb upgrade for free.

Quote:

---

Originally Posted by Dios

In my opinion (and experience after 6 years) its very important how many cores, ram, etc. But the most important aspect for us were disks. Sata disks could not keep up with us. ATM we are running 2x300gb 15.000rpm disks that seem to be able to handle the load quite nicely. How many players do you have? If you are recently opening a server just use normal sata until you see they are not enough. If you have over 1000 online then you'll need raptors or scsi.

ATM using:

Dual Processor Quad Core Xeon 5620 - 2.40GHz (8x2.40GHz | 2x12MB cache W/HT)
12.288Mb (12GB DDR3 1333 MHz)
2x 300GB SA-SCSI 15.000 RPM
100Mb download/100Mb upload

Ram usage is near 4gb and cpu usage is between 15% to 30%

10/10mb will do just fine, we are using 3mb/3mb max so the 100mb is just for show off IMO. Most good hosting services will give you the 100mb upgrade for free.

---

what is using so much HDD power? just the database?

Quote:

---

Originally Posted by Dios

In my opinion (and experience after 6 years) its very important how many cores, ram, etc. But the most important aspect for us were disks. Sata disks could not keep up with us. ATM we are running 2x300gb 15.000rpm disks that seem to be able to handle the load quite nicely. How many players do you have? If you are recently opening a server just use normal sata until you see they are not enough. If you have over 1000 online then you'll need raptors or scsi.

ATM using:

Dual Processor Quad Core Xeon 5620 - 2.40GHz (8x2.40GHz | 2x12MB cache W/HT)
12.288Mb (12GB DDR3 1333 MHz)
2x 300GB SA-SCSI 15.000 RPM
100Mb download/100Mb upload

Ram usage is near 4gb and cpu usage is between 15% to 30%

10/10mb will do just fine, we are using 3mb/3mb max so the 100mb is just for show off IMO. Most good hosting services will give you the 100mb upgrade for free.

---

Regarding the number of cores, is Mu multi-threaded, or does it utilize only a single core? Based on this, would 8 cores like yours do better than a Sandy Bridge 3.4 ghz with 4 cores, or would the Sandy Bridge, with a faster clock speed, do better?

Also, what's the deal with bandwidth? How much per month?

Quote:

---

Originally Posted by spezi

what is using so much HDD power? just the database?

---

1300 online + SQL all the time + 5 subs that make a shit load of logs + 10 dataservers + other programs + website + advanced logs we use + everything.

Quote:

---

Originally Posted by poiuyt580

Also, what's the deal with bandwidth? How much per month?

---

I have 2 hostings, one for website (and client) and one for server. The client, website (not scripts), images, etc uses 3tb to 15tb (when client is updated). Dedicated server uses a lot less, see image.

http://www.subimelafoto.com.ar/images/237report.png

Quote:

---

Originally Posted by Dios

1300 online + SQL all the time + 5 subs that make a shit load of logs + 10 dataservers + other programs + website + advanced logs we use + everything.




I have 2 hostings, one for website (and client) and one for server. The client, website (not scripts), images, etc uses 3tb to 15tb (when client is updated). Dedicated server uses a lot less, see image.

http://www.subimelafoto.com.ar/images/237report.png

---

Oh, so it's not a lot. Also, could you answer my questions regarding processor and SQL?

You can config that as you like or need. If you want you can assign x cores to x process. The possibilities are infinite.

Quote:

---

Originally Posted by Dios

You can config that as you like or need. If you want you can assign x cores to x process. The possibilities are infinite.

---

No, I'm asking whether or not Mu will utilize all the cores available, or only a single core - is clock speed or number of cores more important?
Also, can I use MySQL instead of MSSQL?

it depends on how you set the affinity of the process, you have at least 3 database process+2 gameserver+exdb+joinserver+CS+misc app+...
so its better to have more cores than 2-4 cores with bigger speed
Mu processes dont require too much speed ...it all depends on how many users do you have

max 50 users s6 server=dual core CPU 4000+ 200gb hdd sata/ata 10mb connection 2gb ram(minimum)
max 100 users s6 server =dual core Cpu 6000+ 200gb hdd 10000Rpm if all logs are on 10mb connection 4-8 GB ram
and so on..
as u can see the only important variables are hdd rpm and ram

How about MySQL instead of MSSQL?

There is a single guide making ur server MySql , normally MuOnline needs just MSSQL , so if u want mysql u have to work abit more to make ur dbs work

Quote:

---

Originally Posted by karLi

There is a single guide making ur server MySql , normally MuOnline needs just MSSQL , so if u want mysql u have to work abit more to make ur dbs work

---

Can you link me to the guide?

---------- Post added at 01:13 PM ---------- Previous post was at 01:06 PM ----------

Never mind, found them:
http://forum.ragezone.com/f196/mu-se...tabase-526143/
http://forum.ragezone.com/f196/setti...server-225269/

i can't Download the MSQL server 2000 please give me the Link.

Quote:

---

Originally Posted by ForeverMU

i can't Download the MSQL server 2000 please give me the Link.

---

SQLEVAL.exe | Game Front

good this thread cause im not needed to open another..my question:

How many players can keep online a home server?

Server specifications:
AMD Phenom II X4 955 Quad Core, 3200MHz
8 gb ddr 2 RAM
500 GB HDD

and my internet connection tested with speedtest.net on different location on world shows like this:

Bucharest(my city)
Ping 2 ms DOWN 83,89 mbs UP 73,37 mbs

Budapest
Ping 23 ms DOWN 14,63 mbs UP 0.24 mbs

Madrid
Ping 114 ms DOWN 2,71 mbs UP 0,27 mbs

Rome
Ping 66 ms DOWN 2,87 mbs UP 0,25 mbs

New York
Ping 122 ms DOWN 2,32 mbs UP 0,23 mbs

Malaesya
Ping 312 ms DOWN 1,60 mbs UP 0,22 mbs

what is between network card integrated TOE(TCP/IP Offload Engine) and normal one?

i wonder does all the server network card integrated with TOE.

Quote:

---

Originally Posted by X-Myth

good this thread cause im not needed to open another..my question:

How many players can keep online a home server?

Server specifications:
AMD Phenom II X4 955 Quad Core, 3200MHz
8 gb ddr 2 RAM
500 GB HDD

and my internet connection tested with speedtest.net on different location on world shows like this:

Bucharest(my city)
Ping 2 ms DOWN 83,89 mbs UP 73,37 mbs

Budapest
Ping 23 ms DOWN 14,63 mbs UP 0.24 mbs

Madrid
Ping 114 ms DOWN 2,71 mbs UP 0,27 mbs

Rome
Ping 66 ms DOWN 2,87 mbs UP 0,25 mbs

New York
Ping 122 ms DOWN 2,32 mbs UP 0,23 mbs

Malaesya
Ping 312 ms DOWN 1,60 mbs UP 0,22 mbs

---

You might thinking about upgrading your internet, cus that upload speed will make your players laag a lot.

There is sql sp3 and sp4 . which 1 can be work for making a server .. I was starting to make one :D <--- newbie :)