Merging 2 VPS & Website SQL connection related questions

Kardil · 01/05/2016, 15:33

Hey guys i've two questions and i hope someone can give obvious and detailed answers for them ..

1- Is there a way to merge ( or smth like that ) 2 VPS ? I mean making a server that stands on 2 VPS ( to handle player's count without any lags ) .. or working on 2 GS how exactly can i do that?

2- I've searched on the best ways to be sure that my website is secured and i found that its files should be on another vps .. so now how would it connect to my game's sql DB?!

Kardil · 01/07/2016, 16:07

Nobody knows?

AceSpace · 01/07/2016, 17:23

1) For 2 GS, use Certgen "google it" and configure the cert for 2 GS and 1 agent.
On 1st machine, run all the files normally, and on the second machine copy the same server files and change the IP of the machines such as SR_GameServer, MachineManager then open them normally on the second machine without needing to modify anything other than the IP. Make sure you have allowed all the ports to the second VPS.

2) You basically enable 1433 to that VPS ONLY! Use Scope in firewall (Remote) and connect to it by the following (EXAMPLE):
Hostname: IPADDRESS of the server which has the database in
ID: sa
Pass: 1234
Database: SRO_VT_SHARD
and that's it.

NOTE: you need to use the IP instead of hostname inside the cert for 2 GS to connect well. Otherwise the second VPS will get "DB connection failed"

Kardil · 01/08/2016, 20:20

Thanks alot for being obvious , just 1 note ..
what if i want to run them ( 2 GS ) on the same machine should i use VMware , or there is a better solution ? because i saw some people don't use VMware , then i tried but GS telling me that it's already executed .. sorry for being newbish that's why iam posting for help.

~~Goofie~~ · 01/11/2016, 03:48

You need 2 separated dedicated servers in order to make VPS servers work with each shudder.

You cannot use 2 vps servers(from same machine) in order to make 2x gs or agent setup, I tested and it's not working.

You can:
Use 1 dedicated and make 1 VPS, but that's also tricky to get it running you need to have knowledge on how the files work in the first place.

Kardil · 01/13/2016, 17:01

You said that i can't make 2 GS on the same machine ok .. but 1 dedicated and making 1 vps so they are the same machine !

Then how would it work .. you said tricky btw I know how files work

But i don't have the machine now to try .. so tell what to do if you won't mind .. thanks

~~Supportlar~~ · 01/13/2016, 17:29

well as my exp, you will have to open many ports,which that will expose you [ easy hacking]..

zagorodnov · 01/15/2016, 01:37

Quote:

Originally Posted by Supportlar

well as my exp, you will have to open many ports,which that will expose you [ easy hacking]..

Use your brain and ssh tunnels to secure your server )

MeGaMaX · 01/15/2016, 07:59

Quote:

Originally Posted by Goofie

You need 2 separated dedicated servers in order to make VPS servers work with each shudder.

You cannot use 2 vps servers(from same machine) in order to make 2x gs or agent setup, I tested and it's not working.

You can:
Use 1 dedicated and make 1 VPS, but that's also tricky to get it running you need to have knowledge on how the files work in the first place.

huh ?

zagorodnov · 01/15/2016, 16:06

Quote:

Originally Posted by androw3349

huh ?

Isro files! Huh!

Kardil · 01/15/2016, 18:25

Quote:

Originally Posted by androw3349

huh ?

So
You made 2 VPS from your dedicated here ?

~~Supportlar~~ · 01/15/2016, 18:25

Quote:

Originally Posted by zagorodnov

Isro files! Huh!

sure mr brain

zagorodnov · 01/15/2016, 20:54

Quote:

Originally Posted by Supportlar

sure mr brain

rytiskun · 04/12/2022, 02:24

Quote:

Originally Posted by AceSpace

1) For 2 GS, use Certgen "google it" and configure the cert for 2 GS and 1 agent.
On 1st machine, run all the files normally, and on the second machine copy the same server files and change the IP of the machines such as SR_GameServer, MachineManager then open them normally on the second machine without needing to modify anything other than the IP. Make sure you have allowed all the ports to the second VPS.

2) You basically enable 1433 to that VPS ONLY! Use Scope in firewall (Remote) and connect to it by the following (EXAMPLE):
Hostname: IPADDRESS of the server which has the database in
ID: sa
Pass: 1234
Database: SRO_VT_SHARD
and that's it.

NOTE: you need to use the IP instead of hostname inside the cert for 2 GS to connect well. Otherwise the second VPS will get "DB connection failed"

This Mf, Bless You been fcking arround for 3 hours and had SQLEXPRESS in certification which caused 2nd machine to fail to connect lol. LOVE YOU <3