Posts: 37
Threads: 9
Joined: May 2015
Reputation:
0
Hey guys just this simple question...
Is it necessary for a mysql database to run on the same machine as the samp server in order for the samp server to work on the database?
Also is it possible to access the database through remote access...?
Please answer...
Posts: 422
Threads: 92
Joined: May 2014
Reputation:
0
It is possible to do it from remote access, yes.
Posts: 393
Threads: 105
Joined: Dec 2014
Reputation:
0
It is possible to have acces trough remote. Just buy a host that includes a mysql database. I doesn't make that much sense if you run the server and mysql DB at the same host.
Posts: 37
Threads: 9
Joined: May 2015
Reputation:
0
Thanks friends for the valuable answers...
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation:
0
While it is generally possible to use an off-site database, this is not recommended because this is incredibly slow compared to a database on the local network. All the data needs to be transmitted over the Internet (which is also less secure). If a query takes 10 milliseconds on a local machine, it can easily take 100 milliseconds on a remote machine because of the ping. That is is a modest ping of 45 milliseconds (back and forth) and is already 10 times slower.
