SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 25/07/2016, 11:17 AM   #1
Ankon
Little Clucker
 
Join Date: May 2015
Posts: 37
Reputation: 0
Question SAMP SERVER AND MYSQL QUESTION

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...
__________________
Ankon is offline   Reply With Quote
Old 25/07/2016, 11:19 AM   #2
justjamie
Huge Clucker
 
Join Date: May 2014
Posts: 424
Reputation: 5
Default Re: SAMP SERVER AND MYSQL QUESTION

It is possible to do it from remote access, yes.
justjamie is offline   Reply With Quote
Old 25/07/2016, 11:43 AM   #3
Fantje
Huge Clucker
 
Join Date: Dec 2014
Posts: 393
Reputation: 9
Default Re: SAMP SERVER AND MYSQL QUESTION

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.
__________________
Fantje is offline   Reply With Quote
Old 26/07/2016, 04:20 AM   #4
Ankon
Little Clucker
 
Join Date: May 2015
Posts: 37
Reputation: 0
Default Re: SAMP SERVER AND MYSQL QUESTION

Thanks friends for the valuable answers...
__________________
Ankon is offline   Reply With Quote
Old 26/07/2016, 08:32 AM   #5
Vince
Spam Machine
 
Vince's Avatar
 
Join Date: Sep 2007
Location: Belgium
Posts: 10,066
Reputation: 2660
Default Re: SAMP SERVER AND MYSQL QUESTION

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.
__________________
Vince is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Question for the samp server owners! Tixxt General 10 24/08/2015 06:44 PM
How to run samp server with xampp in Windows (MySQL Server)! VenomMancer Server Support 7 03/02/2015 08:11 PM
Question Regarding Samp Server ads matthew1211 General 3 20/03/2013 10:03 PM
SAMP Server Question! Panormitis Server Support 2 29/12/2010 07:43 AM
MySQL and Server Question [WSM]Deadly_Evil Help Archive 1 05/02/2010 09:34 AM


All times are GMT. The time now is 12:58 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.