Page 2 of 2

Re: Server thoughts for renewal

Posted: Sat Aug 01, 2020 6:50 pm
by KKBlue
We (telcta and I) tossed in a few bucks too! :wub:

Re: Server thoughts for renewal

Posted: Sun Aug 02, 2020 12:42 pm
by FishPants
Ok so we are around $1200 right now which is more than a year at SYS. I will take a look, I think currently even a 6 month commitment there's no setup fees - I might just subscribe to that, and hold the rest until we are comfortable the specs are OK (I am 99.99% sure they will be... it's a forum..) and then I will take whatever is left and pour into into more time on the server.

You folks ok with that? I'll probably sub to the SYS platform today or tomorrow -- we've got a few days of rain here and I'm on "holidays" from work; might as well tinker.

Re: Server thoughts for renewal

Posted: Sun Aug 02, 2020 12:48 pm
by FishPants
So right now SYS also has a server line available with 64gb of RAM for a few hundred dollar uptick (still about $700 cheaper on the year I think from OVH). So we can afford either one really - I'll need to navel gaze a bit and decide which way to go, but I am inclined for the extra few hundred to get double the ram (or in other words the same amount of ram as we currently have).

Re: Server thoughts for renewal

Posted: Sun Aug 02, 2020 12:52 pm
by FishPants
infinitelurker wrote: Thu Jul 30, 2020 7:20 pm I'm a software/devops guy (but for large enterprise apps, never worked with phpBB), and am curious if you could share some of the stats around what is needed to host OO. Database size, compute needed, bandwidth, etc. Are other hosts cheaper (?), but too much of a pain to move to, etc. If it's a pain to gather the info - don't worry, really just curious.

I'm going to kick in some money too (done!), and vote to stay as is, just because I know what it's like in your shoes. Time is money, and tweaking something that ain't broke can bring unforeseen pain. That being said, a little disk access here and there never hurt anybody, but then again, I'm guessing these servers aren't specced out with ssd's?

Thanks for what you do!
The biggest resource hog we have is the database -- we have had years in the past where it would take FOREVER to insert a record, or god forbid you go to edit a post. Lots of MySQL tuning (this wasn't my specialty until I was done with this -- now I am very comfortable in adjusting the performance parameters).

Bandwidth is so surgey because it depends on how many people are online - but I don't think we need the port speed that we have now -- 250mbs should be fine.

Re: Server thoughts for renewal

Posted: Sun Aug 02, 2020 1:02 pm
by Blackhawk
FishPants wrote: Sun Aug 02, 2020 12:48 pm So right now SYS also has a server line available with 64gb of RAM for a few hundred dollar uptick (still about $700 cheaper on the year I think from OVH). So we can afford either one really - I'll need to navel gaze a bit and decide which way to go, but I am inclined for the extra few hundred to get double the ram (or in other words the same amount of ram as we currently have).
Sounds like a plan to me!

Re: Server thoughts for renewal

Posted: Sun Aug 02, 2020 1:08 pm
by Skinypupy
I’m a little concerned that the relativity vectors might not align with the quantum capacities if our spline reticulation exceeds the maximum algorithm thresholds, but I’m sure you’ve factored that into your decision making process.

(Whatever you decide is fine, I’m sure. :))

Re: Server thoughts for renewal

Posted: Sun Aug 02, 2020 1:29 pm
by Blackhawk
Skinypupy wrote: Sun Aug 02, 2020 1:08 pm I’m a little concerned that the relativity vectors might not align with the quantum capacities if our spline reticulation exceeds the maximum algorithm thresholds, but I’m sure you’ve factored that into your decision making process.

(Whatever you decide is fine, I’m sure. :))
Nah, if that happened all he'd really have to do is reroute the EPS conduits through a matter phase inverter to strengthen the annular confinement beam. We'd be fine.

Re: Server thoughts for renewal

Posted: Sun Aug 02, 2020 7:38 pm
by Baroquen
Sounds good. Thanks!

Re: Server thoughts for renewal

Posted: Tue Aug 04, 2020 8:32 pm
by Zarathud
Thanks for all the fish.

:wub:

Re: Server thoughts for renewal

Posted: Wed Aug 05, 2020 1:32 pm
by gbasden
FishPants wrote: Sun Aug 02, 2020 12:48 pm So right now SYS also has a server line available with 64gb of RAM for a few hundred dollar uptick (still about $700 cheaper on the year I think from OVH). So we can afford either one really - I'll need to navel gaze a bit and decide which way to go, but I am inclined for the extra few hundred to get double the ram (or in other words the same amount of ram as we currently have).
Unsurprisingly, I think going with the extra RAM is well worth doing.

Re: Server thoughts for renewal

Posted: Wed Aug 05, 2020 3:19 pm
by Jaymon
The DB is never going to get smaller. Should probably have as much RAM as we can afford. Make sure there is enough overhead to handle usage spikes, those ad hoc queries can really eat up resources.
The throughput can probably shink safely as you pointed out. Not a lot of new members joining.

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 4:24 pm
by FishPants
Ok sorry I've been quiet I was going back and forth with our provider on a couple options, but recently there's been a sale on a line of servers at OVH (Where we host currently) that brings the operating costs down to the So You Start levels, but we maintain bandwidth capabilities, and memory amounts.

Yes that means I still need to migrate, but at least it's going from an OVH to OVH host in my account versus two separate platforms (although so you start is still part of the OVH family, just older hardware).

So for less money than we pay today, we will get a faster server (processor wise) that's also newer -- at the price of the so you start platform I was going to migrate to. This sounds like a win/win to me! I'm going to place the order later this evening so we don't miss out on the inventory, and then start planning/testing migrating.

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 4:26 pm
by TheMix
Whoo hoo!

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 4:34 pm
by Isgrimnur
TheMix wrote: Mon Aug 17, 2020 4:26 pmWhoo hoo!
:horse:

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 5:19 pm
by gbasden
Sounds awesome! Thanks, Fishpants!

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 5:29 pm
by FishPants
Ok and done, you lunatics donated the equivalent of $2457 in Canuck Bucks. The new server, pre-paid for 24 months (Discounts for prepay) came in at $2451.67 including tax.

That's right suckers, I'm keeping that extra six bucks!

The good news is we are renewed for TWO years now, won't need to fundraise until 2022 - and the world will be over by then.

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 5:43 pm
by hentzau
FishPants wrote: Mon Aug 17, 2020 5:29 pm Ok and done, you lunatics donated the equivalent of $2457 in Canuck Bucks. The new server, pre-paid for 24 months (Discounts for prepay) came in at $2451.67 including tax.

That's right suckers, I'm keeping that extra six bucks!

The good news is we are renewed for TWO years now, won't need to fundraise until 2022 - and the world will be over by then.
Go us!

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 6:28 pm
by LordMortis
Thank you!!!!

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 6:42 pm
by infinitelurker
Well done and thank you!

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 7:20 pm
by Skinypupy
FishPants wrote: Mon Aug 17, 2020 5:29 pm Ok and done, you lunatics donated the equivalent of $2457 in Canuck Bucks. The new server, pre-paid for 24 months (Discounts for prepay) came in at $2451.67 including tax.

That's right suckers, I'm keeping that extra six bucks!

The good news is we are renewed for TWO years now, won't need to fundraise until 2022 - and the world will be over by then.
:dance:

Thank you, o wearer of the fishy trousers!

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 8:11 pm
by Carpet_pissr
So I just finished reading this whole thread, and I think the big takeaway here is "annular confinement beam". Feel free to TL;DR that as a sticky to save others time who haven't read it. Source: Blackhawk

Edit: I'm also understanding "annular" to mean "anus-shaped" or "in the shape of an anus" if you aren't into the whole brevity thing. And yes, I am mentally 14 years old thankyouverymuch.

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 8:36 pm
by Anonymous Bosch
Thanks muchly for your trouty-trousered diligence, FP. Image

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 9:05 pm
by Hrdina
FishPants wrote: Mon Aug 17, 2020 5:29 pm Ok and done, you lunatics donated the equivalent of $2457 in Canuck Bucks. The new server, pre-paid for 24 months (Discounts for prepay) came in at $2451.67 including tax.

That's right suckers, I'm keeping that extra six bucks!

The good news is we are renewed for TWO years now, won't need to fundraise until 2022 - and the world will be over by then.
Since I literally just donated yesterday, that extra six bucks might have come from me. You're welcome to it. :D

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 9:25 pm
by AWS260
Hrdina wrote: Mon Aug 17, 2020 9:05 pm
Since I literally just donated yesterday, that extra six bucks might have come from me. You're welcome to it. :D
Clearly, the new server should be named Hrdina!

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 9:26 pm
by Lassr
:clap: :dance: :obscene-drinkingcheers:

Re: Server thoughts for renewal

Posted: Mon Aug 17, 2020 9:35 pm
by Kraken
I regret that I couldn't spare the scratch this year. All of my money is buying illegal drugs from China. I'll freeload until 2022, if humans are still around then, and thank all of you who kept Fishpants in fish pants in the meantime.

Re: Server thoughts for renewal

Posted: Tue Aug 18, 2020 10:21 pm
by Baroquen
Thanks for your time and effort! :clap:

Re: Server thoughts for renewal

Posted: Tue Sep 01, 2020 8:20 pm
by Kelric
FishPants wrote: Mon Aug 17, 2020 5:29 pm Ok and done, you lunatics donated the equivalent of $2457 in Canuck Bucks. The new server, pre-paid for 24 months (Discounts for prepay) came in at $2451.67 including tax.

That's right suckers, I'm keeping that extra six bucks!

The good news is we are renewed for TWO years now, won't need to fundraise until 2022 - and the world will be over by then.
Wow, your math is terrible. That is only $5.33. :roll:

Re: Server thoughts for renewal

Posted: Wed Sep 02, 2020 9:13 am
by FishPants
Ok so an update - The server was received a couple weeks back, and I managed to install my own version of Centos 8 on it (OVH has templates with their own kernel, but their kernel updates are always behind a LOT and they only have Centos 7 currently). I did a test restore of the site, and I'm really glad I had the overlap time this month because it was a bit of a bear. When I restored the site it wouldn't let me login, so I restored it about 10 different ways only to find out that the PHP version was different which hashes passwords different. Anyways it's fixed, was able to recover and login.

This week will be more testing, more wiping and retesting to make sure I have this down pat and that the server remains resilient on reboot etc without the OVH crap on it. So far so good! As an FYI the restore speed on the server is around 1-1.5 hours for the OO site to be recovered, so whenever we cut over that's about the duration of the downtime (beats the 2 days back when I first tried this before learning to tune MySQL/MariaDB).

Progress!

Re: Server thoughts for renewal

Posted: Wed Sep 02, 2020 9:22 am
by stessier
Yay - thanks again for all you do!

Re: Server thoughts for renewal

Posted: Wed Sep 02, 2020 9:25 am
by FishPants
stessier wrote: Wed Sep 02, 2020 9:22 am Yay - thanks again for all you do!
No problem, without a deadline/gun to my head I actually enjoy this kind of stuff - it's a nice break from my daily routine.

Re: Server thoughts for renewal

Posted: Wed Sep 02, 2020 9:31 am
by stessier
FishPants wrote: Wed Sep 02, 2020 9:25 am
stessier wrote: Wed Sep 02, 2020 9:22 am Yay - thanks again for all you do!
No problem, without a deadline/gun to my head I actually enjoy this kind of stuff - it's a nice break from my daily routine.
The difference between a Job and a Hobby. Well, that and the pay... :)

Re: Server thoughts for renewal

Posted: Thu Sep 03, 2020 3:16 pm
by LordMortis
:wub:

Re: Server thoughts for renewal

Posted: Sat Sep 05, 2020 12:45 am
by Kraken
I do not understand your words, but you made it go, and we are happy when it goes. We are going to have to keep you.