N Tier Architecture for MMORPG

I installed a private ragnarok server with replicated database for my university subject "Distributed System"'s group assignment lol.

Lecturer gave us like $100 Free Azure credit for this assignment and yeah

Transcript

1. N-Tier Architecture for 
 MMORPG Kee Soon Ching Chan Mun Yee Lye Guang Xing
2. INTRODUCTION
3. Massively Multiplayer Online Role-Playing Game able to support large numbers of players simultaneously mostly deployed using client-server architecture may
4. Microsoft Azure Digital Ocean Amazon EC2 Self-Host USD 132/month USD 5/month USD 99.5/month Static IP ~USD120/month Literature Review With lowest specification and same 1TB bandwidth allowance
5. Literature Review Service Microsoft Azure Digital Ocean Description A rock-solid 
 cloud platform for blue- sky thinking Deploy SSD cloud server in less than 55s with dedicated IP and 
 root access Price Expensive Cheapest Server Locations Amsterdam Dublin Hong Kong Singapore United States Europe Scalability Yes Yes Connectivity Slow Normal Ease of Configuration Easy Normal Transparency High High
6. Service Amazon EC2 Self-Host Description Scalable, pay-as-you-go compute capacity in the cloud DIY Price Cheaper Most expensive Server Locations Singapore Sydney Santo Paulo Anywhere Scalability Yes No Connectivity Fast Depend on ISP Ease of Configuration Advance Difficult Transparency High Low Literature Review
7. Microsoft Azure Digital Ocean Amazon EC2 Self-Host A rock-solid 
 cloud platform for blue-sky thinking Deploy SSD cloud server in less than 55s with dedicated IP and root access Scalable, pay-as- you-go compute capacity in the cloud DIY Expensive Cheapest Cheaper Most expensive Amsterdam Dublin Hong Kong Singapore United States Europe Singapore Sydney Santo Paulo Anywhere Yes Yes Yes No Slow Normal Fast Depend on ISP Easy Normal Advance Difficult High High High Low Literature Review
8. PROBLEM STATEMENT
9. Problem Statement We want to host our own game server We want to separate database and application server for better security and performance
10. Normal client-server architecture Server application + Database Client
11. If the server is compromised, user data is compromised as well Server application + Database Client Hack
12. If the server is corrupted/affected, user data is affected as well Server application + Database Client
13. Solution: N-tier architecture Client Server application Database Private network
14. If application server is compromised/affected, user data remains secure Client Server application Database Private network
15. Database can be easily duplicated for backup purpose Client Server application Database Private network
16. Database can only be accessed by application server through private network IP Client Server application Database Private network
17. Installation of game server application Application server git clone https://github.com/HerculesWS/ Hercules.git ~/Hercules apt-get install libmysqlclient-dev
18. Installation of database server Database server apt-get install mysql-server ragnarokdb < item_db.sql! ragnarokdb < logs.sql! ragnarokdb < main.sql! ragnarokdb < mob_db.sql! ragnarokdb < mob_skill_db.sql
19. Endpoints configuration Private network Public IP : 168.63.238.122 Private IP : 10.78.136.57 Private IP : 10.78.114.72 Login port : 6900 Char port : 6121 Map port : 5121 Public network
20. Endpoints configuration Private network GRANT ALL ON ragnarok.* TO sweatshop@'10.78.136.57' IDENTIFIED BY ‘password'! MySQL port : 3306
21. Azure Screenshot (application server)
22. Azure Screenshot (database server)
23. Modify and distribute game client ragnarok.exe clientinfo.xml <address> 168.63.238.122 </address> Edit .exe using hex editor and .xml using text editor
24. Modify and distribute game client ragnarok.exe clientinfo.xml <address> 168.63.238.122 </address> WARNING MODIFYING AND DISTRIBUTING CLIENT FILES ARE ILLEGAL
25. DEMO
26. QUESTIONS?
27. Kee Soon Ching Chan Mun Yee Lye Guang Xing THANK YOU