database Separate db,login,game servers

[Deepdishks]

EDIT: Seems like i missed a place to post, please move it into Advanced Help & Support. Thank you.

Hello,

first of all i would like to apologize in advance if there is already a topic somewhere concerning my questions. I was trying to search some info but failed.

Thank you.

Introduction:

I got 4 Supermicro based server machines absolutely for free and now im trying to build something on a more professional level. I know that it would be cheaper to rent a server , and so on , but its not intended to keep it 24/7, please note that I do everything in the interest of learning and it's all just a hobby, I do not intend to open private server and break google charts trying to make money on it, so please , let's wont discuss issues of power consumption , heat producing, noise levels and overall cost of servering at home. Thank you!

Statement of work:

To begin with i want to setup a micro "cluster" in an enterprise-like way. By this i mean to assign every machine to do its job.

• Game server machine #1
  
• Game server machine #2
  
• Database server machine
  
• Login server machine
  

Here are the tech specs:

1. 2x xeon e5450, 32 RAM, 4 old scsi hdds in a raid 10 configuration.
   
2. One more 2x xeon e5450, 32 RAM, 4 old scsi hdds in a raid 10 configuration.
   
3. 775 one cpu socket based supermicro with 8gb of ram
   
4. 771 one cpu socket based supermicro with 8gb of ram
   

In addition i have 3 120gb ssds.

Questions:

1. What are the system requirements of every software part mangos server consists of? (Lets imagine i have 1.000 players on each server online)
   
2. Is it worth to separate db server from game servers? (tho i want to do it anyway, just in the interest of learning)
   
3. Is it worth to put login databases on a db server?
   
4. Is it possible to set up all mangos versions on this configuration? (Mangos 0-3)
   
5. I want to run VMs on game servers, giving 4 cores and 15 ram to each VM, putting every mangos version on each own VM. (Any thoughs?)
   
6. Would they connect to same login server or should i keep 4 different login servers with one login db?
   
7. Im considering to put 2 ssd in raid1 into database server machine, and schedule all of my machines to do a backup on and hdd somewhere( Whats your thoughs? Should i get a DAS/NAS do a backups on, lets say, login server hdd(I have one old 500gb hhd, i think it would be enough for testing purposes)
   
8. I dont need to put ssd in login server machine(small hdd would be ok) if i would have login db on separate machine, do i?
   
9. Would it worth to run VMs on all machines? Lets say esxi
   
10. Is there any way to test it with bots?
    

The way i see it:

I appriciate all your answers and suggestions.

I want to remind you that all this is for the sake of study, especially sql learning.

After achieving success(i really hope i would ) all server machines would be donated to local school.

Sorry for my Enlgish,

Thank you.

scheme.bmp

[Foereaper]

In general, MySQL is the largest resource hog in the big picture with larger loads. While some like to have it on separate machines, you also need to take into consideration network latency when using the network itself for communication between the nodes. The realm server is by far the least resource hungry piece to all of this, something simple as a raspberry pi could in theory handle hundreds of users attempting to log in at once.

Unfortunately, nothing of the above can really be answered with a direct answer. You would simply have to test and see what works out where.

Some specific answers not covered by the above:

4) Yes, at least 0-2, as they use the same realmd and login system. I have not attempted with 3 as well, this someone else would have to answer for you.

6) They would all use the same realmd.

7) Yes, a NAS or any form of consistent and incremental backup system is recommended.

8) No.

10) To some extent, but no. The bots do not use the network layer what so ever, and they are not very well optimized. The resources used by these can not be compared to real player activity.