Bay 12 Games Forum

Please login or register.

Login with username, password and session length
Advanced search  

Author Topic: Self-hosted software recommendations  (Read 1298 times)

Mephisto

  • Bay Watcher
    • View Profile
Self-hosted software recommendations
« on: August 03, 2018, 10:38:34 am »

I'm considering self-hosting my long-form RPG reviews and any other random textual shenanigans I may do. As such, I need to compare loads of software or write something myself.

Thoughts I've had:

- Standard forum software. One thread per review. Reviews consist of several comments, roughly one comment per chapter/other logical breaking point. The community can get involved in between the review comments.
- GeekList-style. That list was chosen at random but makes for a good example. The basic premise would be that review updates would be top-level items. Comments relating to that update would be in threads associated with that item. Basically, "Reddit-style" but there's only one subthread per item and ranking doesn't change order. Comment-level conversation would be straightforward but meta or whole-review talk would be fairly hidden all the way at the bottom of the page.
- Write something myself if nothing exists.

So, thoughts? Responses? Insults?
Logged

wierd

  • Bay Watcher
  • I like to eat small children.
    • View Profile
Re: Self-hosted software recommendations
« Reply #1 on: August 03, 2018, 01:45:25 pm »

The issue with hosting a forum is not "Beefiness of computer", but "size of upload pipe."

I can TOTALLY host a website, a SQL server, and a forum (Like simple machines-- exactly the software used right here on this site!!) on a repurposed wifi router. (No, not shitting you.)  The problem is the number of concurrent connections, the bandwidth of sending the served page's data (Images, other content), and pals. (though in honestly, I WOULD pick something marginally beefier than an old router.  I have an old NAS box that would be an ideal candidate. :) It has a gigabit interface, a reasonably fast dual core processor, and 512mb of RAM, with a SATA disk controller.)

You see, your consumer grade internet service is usually *HIGHLY* asymmetrical.  It favors download speeds over upload speeds, and they DO NOT want you hosting a server, of ANY kind.  They often state such in their ToS agreement.  When hosting a server, you want a big, fat upload pipe, and just enough download pipe to reliably get all connecting user's connection messages-- which is the EXACT OPPOSITE asymmetry to what a consumer ISP gives you. (unless you happen to have google fiber, and then you are great!)  For the most part, if they catch you hosting a server, they will first send you a nasty letter, then they will suspend your service and demand you upgrade to "Business tier", which costs a whole lot more, or demand you down the server and never run one again.

Aside from this network asymmetry and ToS issue, there is also the problem of malicious actors.  Remember when hackers compromised the core files of bay12's server a while back, so that it would produce meta data promoting south korean gambling sites on Google's Pagerank aglorithm?

Yeah-- THAT.

You will need to properly secure your SQL server, and will likely need to properly configure the host operating system that you are hosting your forum on. I would suggest linux, because you can run the web daemon and the SQL server daemons under different user accounts, and lock each one down tighter than a nun's knickers, but that's just me.



OR--- you could just pay a nominal fee every month for dedicated hosting for a small forum, and let THEM deal with the bandwidth, availability, and malicious actor problems. :P

Most people that get 'serious' elect for such cloud services these days.  Your mileage may vary, and you might have reasons for self-hosting in an era that is averse to people doing that.  Your call.



As for "Style" of software--- You might be better served by a properly done Wiki.  (You know Wikipedia, right?  Something like that, where each of your reviews has its own page, has a talk page, etc.  Talk page might have a forum embedded.)
« Last Edit: August 03, 2018, 01:51:34 pm by wierd »
Logged

Mephisto

  • Bay Watcher
    • View Profile
Re: Self-hosted software recommendations
« Reply #2 on: August 03, 2018, 02:08:12 pm »

I should mention I didn't mean "thread" in the computing sense but in the forum sense.

I've got a 100MBit pipe. While yes, it's residential, it's been symmetric thus far. As for any ToS issues, AT&T appears to have done away with the whole "no server" bit unless you're one of those retro geeks wanting to run a server on a dialup account. You're not guaranteed a static IP but 1) mine hasn't changed in years and 2) dyndns makes that a non-issue.

As for hardware. You can't get more "serious" than an actual enterprise product from one of the Big Two, can you? Virtualized containers for every discrete task and all that shit. It's in use and has been for a year.

So thanks for treating me like a fucking child. I was hoping to get some suggestions and discussion going related to my actual request, but I guess not.
Logged