Pros vs. cons of using online database instead of local

Any discussion not related to the other forum topics
Post Reply
Delaide
Posts: 434
Joined: Sat Jun 14, 2014 8:58 am

Pros vs. cons of using online database instead of local

Post by Delaide » Thu May 24, 2018 12:45 am

Wondering if anyone here has any thoughts on the pros and cons of using a mysql database hosting site rather than run the database locally (I run my own server, privately, for me only at home, but thinking about when I am on the go, so I do not need to replicate my database each time).

User avatar
demolish
Developer
Posts: 262
Joined: Thu Jul 26, 2012 7:12 am

Re: Pros vs. cons of using online database instead of local

Post by demolish » Thu May 24, 2018 3:50 am

not sure what you mean
the players don't access the database directly, the server processes do (even then assuming it's all local you don't need to change anything)
<Giblet[NewBrain]> kj with this first step would be fine on my shit
Click here for a guide on scripting missions.

Delaide
Posts: 434
Joined: Sat Jun 14, 2014 8:58 am

Re: Pros vs. cons of using online database instead of local

Post by Delaide » Thu Jun 21, 2018 4:25 am

Honestly, more curious about it so that I can keep a database I can link my server to from anywhere, then I do not need to worry about localsql. Not sure if it is worthwhile though (then I do not need to dump database every time I want to play on a different computer). So instead of mysql_host: 127.0.0.1, I can point it at (whatever my online data base provider ip is). But is it worth it to skip the whole SQL dump/import to a new system?

User avatar
whasf
Site Admin
Posts: 1233
Joined: Thu Jul 19, 2012 9:11 pm

Re: Pros vs. cons of using online database instead of local

Post by whasf » Thu Jun 21, 2018 8:41 am

You'd have to worry about lag for queries and security. Considering how much the servers hit the db, I don't recommend having the database on the other side of a WAN connection.
-- Whasf

Post Reply