Posts: 625
Threads: 38
Joined: Nov 2011
Hello!
Just a quick question for experienced creators of roleplay servers.
What would be the most secure database out there to use for a roleplay server? How secure is MySQL?
Thanks in advance.
Posts: 4,759
Threads: 33
Joined: Dec 2013
Reputation:
0
What does this have to do with roleplay servers? It can be generally refered to any mode as they are all oriented SA:MP servers.
Both SQLite and MySQL are able to handle a lot of information very well. Nonetheless are more secure, it depends on how the information is handled and to who.
File based saving systems are a no-no when it comes to handling lots of information at its least, and the posibilities that can be done with its use are limited to a point where more work than needed is actually needed.
Posts: 4,878
Threads: 85
Joined: Jun 2007
Reputation:
0
SQLite probably is the safest by means of being a local database only, adding no extra external vulnerabilities to the server (attackers having access to the sqlite file would also have access to any other database, or any other files anyways). MySQL servers instead are external servers, with their own weaknesses and security problems, that give attackers extra doors to access the data.
HOWEVER, the mysql server is a serious thing, where security is a major aspect. The samp server itself in comparison is a rusty piece of scrap metal. 99.9% of all mysql server hacks are the result of bad server administration (sql injection, bad password management, poor access point security, leaked user data, etc), whereas samp servers usually get attacked via security holes in the software itself.
So the database server is the least thing to worry about when running a samp server. Seriously. It wont change a thing what kind of database you use, as long as you use it correctly.
