|
You last visited: Today at 05:50
Advertisement
Merging 2 VPS & Website SQL connection related questions
Discussion on Merging 2 VPS & Website SQL connection related questions within the SRO Private Server forum part of the Silkroad Online category.
01/05/2016, 15:33
|
#1
|
elite*gold: 0
Join Date: Sep 2015
Posts: 150
Received Thanks: 6
|
Merging 2 VPS & Website SQL connection related questions
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?!
|
|
|
01/07/2016, 16:07
|
#2
|
elite*gold: 0
Join Date: Sep 2015
Posts: 150
Received Thanks: 6
|
Nobody knows?
|
|
|
01/07/2016, 17:23
|
#3
|
elite*gold: 71
Join Date: Mar 2011
Posts: 1,594
Received Thanks: 1,099
|
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"
|
|
|
01/08/2016, 20:20
|
#4
|
elite*gold: 0
Join Date: Sep 2015
Posts: 150
Received Thanks: 6
|
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.
|
|
|
01/11/2016, 03:48
|
#5
|
elite*gold: 0
Join Date: Apr 2015
Posts: 1,444
Received Thanks: 1,371
|
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.
|
|
|
01/13/2016, 17:01
|
#6
|
elite*gold: 0
Join Date: Sep 2015
Posts: 150
Received Thanks: 6
|
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
|
|
|
01/13/2016, 17:29
|
#7
|
elite*gold: 0
Join Date: Jan 2016
Posts: 81
Received Thanks: 15
|
well as my exp, you will have to open many ports,which that will expose you [ easy hacking]..
|
|
|
01/15/2016, 01:37
|
#8
|
elite*gold: 0
Join Date: Mar 2012
Posts: 70
Received Thanks: 21
|
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 )
|
|
|
01/15/2016, 07:59
|
#9
|
elite*gold: 1537
Join Date: Sep 2006
Posts: 1,085
Received Thanks: 2,346
|
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 ?
|
|
|
01/15/2016, 16:06
|
#10
|
elite*gold: 0
Join Date: Mar 2012
Posts: 70
Received Thanks: 21
|
Quote:
Originally Posted by androw3349
huh ?
|
Isro files! Huh!
|
|
|
01/15/2016, 18:25
|
#11
|
elite*gold: 0
Join Date: Sep 2015
Posts: 150
Received Thanks: 6
|
Quote:
Originally Posted by androw3349
huh ?
|
So
You made 2 VPS from your dedicated here ?
|
|
|
01/15/2016, 18:25
|
#12
|
elite*gold: 0
Join Date: Jan 2016
Posts: 81
Received Thanks: 15
|
Quote:
Originally Posted by zagorodnov
Isro files! Huh!
|
sure mr brain
|
|
|
01/15/2016, 20:54
|
#13
|
elite*gold: 0
Join Date: Mar 2012
Posts: 70
Received Thanks: 21
|
Quote:
Originally Posted by Supportlar
sure mr brain
|
|
|
|
04/12/2022, 02:24
|
#14
|
elite*gold: 56
Join Date: Sep 2020
Posts: 43
Received Thanks: 25
|
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
|
|
|
Similar Threads
|
Website connection problem
11/16/2015 - SRO Private Server - 6 Replies
I try to setup a website for vsro, with wamp on my pc IP everything working
and when others trying to connect to my ip it's not working.. and also when i upload the website files to any Free Host it's shows a blank white screen...how to fix it? ty.
|
[Selling] Website related to Riot Points selling. (If you sell RP and want a website come here)
10/11/2014 - League of Legends Trading - 3 Replies
You have a referral bot that makes RP and you sell it to people?
You buy RP and want to resell it to people for bitcoin/crypto-coins?
I have a website for you. It's hosted + domain lasting for 10 months + almost completely designed and complete.
http://rpforbtc.com/
|
All times are GMT +2. The time now is 05:50.
|
|