Page 1 of 1
Pros vs. cons of using online database instead of local
Posted: Thu May 24, 2018 12:45 am
by Delaide
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).
Re: Pros vs. cons of using online database instead of local
Posted: Thu May 24, 2018 3:50 am
by demolish
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)
Re: Pros vs. cons of using online database instead of local
Posted: Thu Jun 21, 2018 4:25 am
by Delaide
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?
Re: Pros vs. cons of using online database instead of local
Posted: Thu Jun 21, 2018 8:41 am
by whasf
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.