question abot sql web and the server
Hello.
i host a pt on my pc [dont tell me you will have lags because my pc strong enough for host a pt] and a website i wonder if i should rent a host for my web i mean when i have alot of people in my web its will slow abit my server?i use vertrigo server for that
and if i choosed to rent a host for my website i use php scripts for ranks so its will connect to my sql server wich i created in my pc and not in host?
thanks
Re: question abot sql web and the server
Connection to your SQL server vs. speed of game server is the problem.
To connect to SQL from another server, you have to open ports for SQL communication, and store your SQL access password on a remote system... which is a security risk.
If you run the web, SQL, Login and Game servers all from one machine, each will detriment the performance of the other... a greater problem than the web hitting game performance, is the game taking so much out of the system that clan pages stop being served up, and new players can't register.
The design of the system is such that you should be able to host 1 web server, 1 login server, 1 SQL database server and 1 game server all behind a router, occupying 4 different physical systems, providing game services to players on the other side of the router without lag.
Doubling up services on hardware, Game and Login, SQL and Web works best for a 2 PC system.
If you really are going to have an off-site web server, you may want to consider setting up a VPN between the two systems, so that you can open the encrypted VPN port, not directly open SQL ports... then the Web server has to sign in via the VPN before it can access the SQL... and even if the SQL authentication in your PHP scripts leaks, people still have to hack into the VPN before they can use that.
Having the SQL server outside your LAN is not a good idea, because of the time it would take to pass data across a WAN, however fast your internet connection, it isn't going to be like a gigabit Ethernet or IEEE1394 connection locally. (the speed of light cannot be broken by the current known laws of physics)
Re: question abot sql web and the server
kk i get you but.
lets be realistics i will not hold over 100 members lol i guess i will have around 50 and my pc is really really strong couldnt find a better dedi host then my pc..
so your advice is to use 2 pcs one for the server and one for the website and connect the sql between then by open ports and VPN?must be sure becausei dont want my players do be disapoint
thanks
Re: question abot sql web and the server
If you have an old PC laying around, or can get your hands on a second hand one, it should be sufficient for SQL and Web. If they are your side of the router, you don't need VPN.
For 100 users... there should not be a problem using the one PC for everything... at most, people may have clan problems logging on mid Bless Siege.
Re: question abot sql web and the server
lol when i will pass the 100 users online i will rent a better host i am talking with you around 30-70 then ill let my pc do the job for both of them =]
Re: question abot sql web and the server
Fair call... it's all a matter of judgement, and as you say, as performance drops off, you can add hardware to the system... whether that be local or remote.
Re: question abot sql web and the server
Re: question abot sql web and the server
Quote:
I've already told you this, but you didn't listen and bragged about your PC being "very gooood". Yeah right.
didnt saw you posted answer to my thread..
and bobsbol said i can hold it without lags if its around 50 people
Quote:
"very gooood". Yeah right
and yes when you invest 1500$ on a computer you would have a nice pc =]
Re: question abot sql web and the server
The PC isn't the issue Gregoory is taking... it's the internet connection... In my experience a dedicated business line for server access is almost as expensive as renting a Dedi, but it's the only other way to ensure your latency is entirely your own.
Home and small business internet packages are shared, and what the other users on your line do will be as important as (probably more so than) what you do... Gregoory said this, I said this, others have said it to you too...
But you want to start things off with a system at your fingertips, not a remote one, that's your call and I see no problem with it.
What is frustrating is that you keep asking questions about how to ensure you don't have lag... when your basic starting premise (which you are unshakable on) is that you have a system with random external lag imposed upon you.
I presume you are trying to minimise internal lag, and learn. Learning is why we are all here. Having a system that is right in the first place will help when you need to change to a Dedi... but random lag will happen that you can't fix with your existing setup.
Those with experience are asking the question, "what is the point?" since you are (as we say) "trying to run before you have learned to crawl." More like, you are trying to make the perfect F1 GP car, when you have no access to a road, let alone a race track, and are determined that you are going to run it across fields.
@Gregoory: Imri is learning... mistakes are a powerful learning mechanism. He is determined to do it his way, and I suspect he will have his system working, and see that it works really well, and that the results are still unimpressive... but the more important result, may just be that he learns something. :wink:
An old riddle recited from memory:-
Quote:
Q: "What is often ask for, sometimes given and seldom accepted?"
A: "Advise" (highlight to read)