This Server, UGH

[Easy 6]

This is not a finger pointing thread, DaFace has been clear that he is hamstrung when this happens... but isn't it just weird AF that it never happens on some random Tuesday?

Nope, its ALWAYS gotta be a Saturday or Sunday

It's simply uncanny...

[penguinz]

Originally Posted by seamonster

I developed a piece of software that uses Sqlite to sync data between multiple different parties for offline replication (this was over two years ago). I load tested this on older hardware knowing that my potential customers might be running on trash. I can tell you that 16 million records worked fine. Shit, you can add up to a billion rows in SQLite if you really know what you're doing...
MySql was a state of the art database with a good query analyzer\engine...Not being able to query or insert into a table that small leads me to believe you've got a problem that's deeper than just COTS. But you've got it all figured out and are king snake here so that's up to you to solve. But if I were in your position (which I don't envy) I wouldn't turn my nose up and act like a prick because somebody said something as simple as "are we solving a hardware problem with more software?".

Comparing Sqlite performance and ancient, or even modern, MySQL is no comparison.

Big issue with these types of community softwares is that table indexes do not get set. Especially when you start adding in mods.

A good indexing could speed things up considerably but you are still running antiquated software. Both the bb software and the backend services.

[DaFace]

Originally Posted by penguinz

Comparing Sqlite performance and ancient, or even modern, MySQL is no comparison.

Big issue with these types of community softwares is that table indexes do not get set. Especially when you start adding in mods.

A good indexing could speed things up considerably but you are still running antiquated software. Both the bb software and the backend services.

vBulletin 3.8 is also just horrifically bad at query efficiency. I just checked for fun, and loading this page executed 39 queries just to give you an idea. Multiply that by 1000 people all mashing the reload button on game days, and it's just a mess. Plus it does all sorts of joins instead of utilizing indexes efficiently.

They've improved a lot of it on newer versions, which, again is why my personal preference would be to rip the bandaid off so we could get on software that's actually designed to work in 2024.

[Monty]

Originally Posted by DaFace

vBulletin 3.8 is also just horrifically bad at query efficiency. I just checked for fun, and loading this page executed 39 queries just to give you an idea. Multiply that by 1000 people all mashing the reload button on game days, and it's just a mess. Plus it does all sorts of joins instead of utilizing indexes efficiently.

They've improved a lot of it on newer versions, which, again is why my personal preference would be to rip the bandaid off so we could get on software that's actually designed to work in 2024.

Considering that the latest version of vBulletin is 6.0.2, that makes perfect sense and should be the goal.

[Pablo]

Originally Posted by scho63

Why the sarcasm for people trying to help?

I've found an accurate representation of everyone in this thread weighing in with their IT expertise:

[seclark]

I coded a dungeons and dragons ripoff in BASIC back in the early 80’s, and I’m retired on disability, if you need anything from me.
sec

[ChiliConCarnage]

Originally Posted by DaFace

Eh, Xenforo or vBulletin 6 are both around $200 for the software and both have migration tools - that's really not the issue. I'd personally rather go with those rather than something open source since they tend to be better supported.

(But again, only one person's opinion matters here.)

Well, I'd think your opinion matters quite a bit since you seem to do quite a bit of the front-end tweaking. $200 isn't bad, would we need a whole new server to slowly migrate too?

I'm not sure how the hosting works but maybe some others could help work on the themes are look of the new forum software if they only needed access to the new server. I know AC would probably have to migrate the data.

Let us know if we should cancel our next trips to Belize in order to donate

edit: I just caught up with the rest of the posts now and it doesn't seem like there is much to be done for now.

[Rausch]

So, I'm assuming we got hacked?
I doubt Austin was pondering the revenue gained from becoming a pr0n site...

[Rausch]

Originally Posted by DaFace

Just to be clear, I'm just here to answer questions. I'm happy to provide a little insight into the issues, but there are no decisions that I'll be making. I'm happy to pontificate about my views on the best new software, but I have no desire to get into it any further than I already am.

The barrier here is largely just Kyle finding time to deal with it, not Kyle figuring out how to do things.

So when I clicked on the ChiefsplanetDowntime link and it...well, had an international flavor, I assume that wasn't just database issues.

I'm no IT specialist but I don't think that's how things work...

[stanleychief]

I'd say switching to SSD or NVMe drives would net the biggest bang for the buck, assuming the server hardware supports them. That would likely at least cut down on the amount of time things would be offline.

I think I asked this a long time ago, but what about moving to a cloud solution like Xenforo cloud and increasing revenue via donations or ads to pay for the costs? It sounds like AC is busy with his day-to-day job and his time is limited a bit. That would shift these outages to being someone else's problem to solve.

[DaFace]

Originally Posted by stanleychief

I'd say switching to SSD or NVMe drives would net the biggest bang for the buck, assuming the server hardware supports them. That would likely at least cut down on the amount of time things would be offline.

I think I asked this a long time ago, but what about moving to a cloud solution like Xenforo cloud and increasing revenue via donations or ads to pay for the costs? It sounds like AC is busy with his day-to-day job and his time is limited a bit. That would shift these outages to being someone else's problem to solve.

I've wondered about Xenforo cloud as well. Our traffic levels would likely be in their Enterprise tier that would require custom pricing (so more than $250/month). Whether our ad revenues would cover it, I don't know.

[BryanBusby]

Originally Posted by Pablo

I've found an accurate representation of everyone in this thread weighing in with their IT expertise:

Please do not put my personal pics online or I will hire a lawyer that's simply unbeliezable.

[Otter]

Originally Posted by DaFace

I've wondered about Xenforo cloud as well. Our traffic levels would likely be in their Enterprise tier that would require custom pricing (so more than $250/month). Whether our ad revenues would cover it, I don't know.

Since this was bumped again, outside of the in memorandum section (which can be re-created easily) why exactly is a merger needed? Are there weirdos coming back and looking up old posts on the regular? And if so, should you care?

This place will fill up so fast just because of the novelty of recreating it new.

And Xenforo pro cloud guys are absolute professionals and Austin would be taking the headache of having to play EMS off his hands.

[Monty]

Originally Posted by Pablo

I've found an accurate representation of everyone in this thread weighing in with their IT expertise:

Cool, we can play Adopt-a-Monkey.

I'm the one on the table on the far right with his head inches from the screen.

[Frazod]

Originally Posted by Pablo

I've found an accurate representation of everyone in this thread weighing in with their IT expertise:

And Kyle's thoughts on all of it.

[DaFace]

Originally Posted by Otter

Since this was bumped again, outside of the in memorandum section (which can be re-created easily) why exactly is a merger needed? Are there weirdos coming back and looking up old posts on the regular? And if so, should you care?

This place will fill up so fast just because of the novelty of recreating it new.

And Xenforo pro cloud guys are absolute professionals and Austin would be taking the headache of having to play EMS off his hands.

Again, I can only speak for myself and my limited understanding. I'd hate to lose the history, but it's not an absolute deal-breaker if we had to. But that said, I don't THINK that it's insurmountable to have both (a new system and migrate threads).