Author Topic: FORUM DISRUPTION: Server Upgrade  (Read 39840 times)

0 Members and 1 Guest are viewing this topic.

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
FORUM DISRUPTION: Server Upgrade
« on: March 27, 2017, 02:14:58 pm »
 
The following users thanked this post: gnif, dr.diesel, Kean, nugglix, MK14

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #1 on: March 28, 2017, 05:09:52 am »
Please also note that after the server comes back online there will be a period of tuning which will cause various errors and timeouts, I will update this thread when this is completed, there is no need to report these and I apologize in advance for the frustration it will cause.
 
The following users thanked this post: tautech, tpowell1830

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #2 on: March 28, 2017, 08:06:34 am »
The server has been configured to take advantage of the additional RAM, it will be monitored closely over the next few days to see if any additional improvements can be made. There should be no more outages unless noted here prior. Performance feedback is very welcome here.
 
The following users thanked this post: EEVblog, voltsandjolts, nugglix

Offline mrpackethead

  • Super Contributor
  • ***
  • Posts: 2845
  • Country: nz
  • D Size Cell
Re: FORUM DISRUPTION: Server Upgrade
« Reply #3 on: March 28, 2017, 08:20:57 am »
Am getting the 502 bad gateway errors again just a few minutes ago, though the forum is going just fine. 

On a quest to find increasingly complicated ways to blink things
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #4 on: March 28, 2017, 08:21:20 am »
Was supposed to get 16GB RAM, but got 32GB for some reason  ;D

The MySQL queries has jumped fairly dramatically, seems it now able to process many more requests per second  :-+

 
The following users thanked this post: nugglix

Offline The Soulman

  • Frequent Contributor
  • **
  • Posts: 949
  • Country: nl
  • The sky is the limit!
Re: FORUM DISRUPTION: Server Upgrade
« Reply #5 on: March 28, 2017, 08:25:23 am »
Thanks dudes!  :-+
 

Offline FrankBuss

  • Supporter
  • ****
  • Posts: 2365
  • Country: de
    • Frank Buss
Re: FORUM DISRUPTION: Server Upgrade
« Reply #6 on: March 28, 2017, 08:28:23 am »
It feels a lot faster now when opening topics. Before the upgrade sometimes I had to wait a few seconds, couldn't see this now while reading some topics.
So Long, and Thanks for All the Fish
Electronics, hiking, retro-computing, electronic music etc.: https://www.youtube.com/c/FrankBussProgrammer
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #7 on: March 28, 2017, 08:30:04 am »
Seems faster for me too.
Opening topics, opening a reply, and posting a reply.
 

Offline nugglix

  • Regular Contributor
  • *
  • Posts: 209
  • Country: de
Re: FORUM DISRUPTION: Server Upgrade
« Reply #8 on: March 28, 2017, 08:34:31 am »
Thread refresh (F5 in open thread page) is now in the sub-second range.
Clearly some sort of success, I'd say.  :-+

Thanks for the time/money spent!

Hmm... question: do I need to read faster now?   ;)

PS: Posting preview also sub-second response.
 

Offline MrBungle

  • Supporter
  • ****
  • Posts: 75
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #9 on: March 28, 2017, 08:34:41 am »
When you said tomorrow, I figured tomorrow.... also known as Wednesday.
All good, minimal disruption  :-+
Great work guys.
 

Offline boffin

  • Supporter
  • ****
  • Posts: 1027
  • Country: ca
Re: FORUM DISRUPTION: Server Upgrade
« Reply #10 on: March 28, 2017, 08:42:18 am »
After you've run for a couple of days, I highly recommend mysqltuner.pl ; it'll help show bottlenecks (and over-allocations) in your existing my.cnf

 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #11 on: March 28, 2017, 08:42:43 am »
After you've run for a couple of days, I highly recommend mysqltuner.pl ; it'll help show bottlenecks (and over-allocations) in your existing my.cnf

It is the tool of the trade :)
 

Online mikeselectricstuff

  • Super Contributor
  • ***
  • Posts: 13741
  • Country: gb
    • Mike's Electric Stuff
Re: FORUM DISRUPTION: Server Upgrade
« Reply #12 on: March 28, 2017, 09:04:57 am »
The slowness I've been seing over the last week or so seems to have gone away.

Youtube channel:Taking wierd stuff apart. Very apart.
Mike's Electric Stuff: High voltage, vintage electronics etc.
Day Job: Mostly LEDs
 

Online JPortici

  • Super Contributor
  • ***
  • Posts: 3461
  • Country: it
Re: FORUM DISRUPTION: Server Upgrade
« Reply #13 on: March 28, 2017, 09:10:36 am »
Browsing o  tapatalk... super fast :)
 

Offline Muttley Snickers

  • Supporter
  • ****
  • Posts: 2340
  • Country: au
  • Cursed: 679 times
Re: FORUM DISRUPTION: Server Upgrade
« Reply #14 on: March 28, 2017, 09:19:39 am »
In gnif we trust, well done and many thanks.   :-+ :)
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #15 on: March 28, 2017, 09:30:15 am »
The number of update and insert requests seems quite stable over the past month. But the number of select requests has increased markedly. Why is that? It predates todays RAM upgrade. IIRC you re-jigged the MySQL tables. Is the increase simply because MySQL does more selects as a result of the DB work? Does it reflect new selects being generated as a result of a similar load?
Were you RAM constrained before and did that contribute to the record locking for long periods during maintenance? Which lead to the 502's. Just reading what has been reported I don't quite see how more RAM has addressed the problems reported. Were there performance issue at times outside the DB maintenance intervals?

Sorry gnif I don't mean to bombard you with questions it is just that I am not sure of the right question in MySQL speak.

No worries mate. The pickup in qps is coincides with the MyIASM to InnoDB conversion on those final few tables, we are seeing far fewer lock contentions and as such the total server throughput went up. It went up because prior when a table was locked, it would put the next query into a queue, this is fine provided the queue length doesn't blow out, like it started to. In short, we were limited by locking, which throttled throughput.

Once we switched to row level locking, there is no longer (much) lock contention, and as such all these requests now can run concurrently, so this increases our throughput, people get faster response, etc... This explains the jump in queries per second. I also went through and added some indexes to fix some slow queries, SMF developers don't seem to understand the importance of them, this is not the first time I have had to fix queries.

But then we hit I/O issues as we had also increased our IOPS, so instead of seeing as many 502's due to PHP being too busy, we were seeing more slower responses due to the now much increased IO load, which in turn affects the entire server, not just DB requests. Most people throw a SSD in to resolve this, but it is unwarranted in most cases and at best a SSD is a temporary fix. The usually better solution is to throw a bit more ram at the server and cache the indexes and entire working data set, since RAM is orders of a magnitude faster then a SSD, and once the server has warmed up (data is in RAM), it barely touches the disk except for updates/inserts.

Finally since we have more RAM then we expected, I thew some extra to Memcached.
 

Offline rrinker

  • Super Contributor
  • ***
  • Posts: 2046
  • Country: us
Re: FORUM DISRUPTION: Server Upgrade
« Reply #16 on: March 28, 2017, 12:38:25 pm »
 I hadn't really noticed it being slower than normal, and just had a bunch of 502's but that was during the time gnif said it was rebuilding the database after the previous changes - that went away.

 But wow - compared to yesterday, it is flying now. Incredibly smooth and responsive clicking on messages and going through pages.  :-+ :-+ :-+  More RAM, more gooder.

 

Offline timgiles

  • Regular Contributor
  • *
  • Posts: 236
  • Country: se
  • Programmer, DB architect
Re: FORUM DISRUPTION: Server Upgrade
« Reply #17 on: March 28, 2017, 01:33:49 pm »
Yes - buttery smooth today  :)
 

Offline grumpydoc

  • Super Contributor
  • ***
  • Posts: 2905
  • Country: gb
Re: FORUM DISRUPTION: Server Upgrade
« Reply #18 on: March 28, 2017, 01:51:28 pm »
Very noticeable improvement!

 :-+ :-+ :-+
 

Online 2N3055

  • Super Contributor
  • ***
  • Posts: 6600
  • Country: hr
Re: FORUM DISRUPTION: Server Upgrade
« Reply #19 on: March 28, 2017, 09:32:18 pm »
Page loading is different: slight delay and than faster loading.. All in all a bit better.. But biggest difference is when replying.. Posting goes much faster....
 

Offline dr.diesel

  • Super Contributor
  • ***
  • Posts: 2214
  • Country: us
  • Cramming the magic smoke back in...
Re: FORUM DISRUPTION: Server Upgrade
« Reply #20 on: March 28, 2017, 10:19:11 pm »
Serious improvement from the sticks of Indiana as well, big thanks to gnif/Dave.

Offline tautech

  • Super Contributor
  • ***
  • Posts: 28328
  • Country: nz
  • Taupaki Technologies Ltd. Siglent Distributor NZ.
    • Taupaki Technologies Ltd.
Re: FORUM DISRUPTION: Server Upgrade
« Reply #21 on: March 28, 2017, 10:26:20 pm »
Big  :-+ here too.  :)
Avid Rabid Hobbyist
Siglent Youtube channel: https://www.youtube.com/@SiglentVideo/videos
 

Offline mrpackethead

  • Super Contributor
  • ***
  • Posts: 2845
  • Country: nz
  • D Size Cell
Re: FORUM DISRUPTION: Server Upgrade
« Reply #22 on: March 28, 2017, 11:24:50 pm »
Are you serving pages on ipv6 yet?
On a quest to find increasingly complicated ways to blink things
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #23 on: March 29, 2017, 01:57:34 am »
Are you serving pages on ipv6 yet?

Unfortunately not, sadly IPv6 has not been widely deployed by data centers.
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #24 on: March 29, 2017, 03:27:11 am »
The forum is seriously slick from my lab too. So both using the new fixed IP trial setting, and without.
That RAM really did the trick.
BTW, I still don't know what it's going to cost me.
The head of marketing at HostGator (who is a fan BTW) said they'll sort it out after I complained about the ludicrous price that would have cost an extra $240/month to go from the 8GB we had to 32GB we have now. PER MONTH!
« Last Edit: March 29, 2017, 03:30:08 am by EEVblog »
 

Offline FrankBuss

  • Supporter
  • ****
  • Posts: 2365
  • Country: de
    • Frank Buss
Re: FORUM DISRUPTION: Server Upgrade
« Reply #25 on: March 29, 2017, 08:31:03 am »
My hosting provider, 1and1, has full dedicated servers with 32 GB RAM, 12 cores x 2.3 GHz and 2 TB RAID 1 harddisk for $200 per month. Just in case you need some arguments for HostGator :)
So Long, and Thanks for All the Fish
Electronics, hiking, retro-computing, electronic music etc.: https://www.youtube.com/c/FrankBussProgrammer
 

Offline Rerouter

  • Super Contributor
  • ***
  • Posts: 4694
  • Country: au
  • Question Everything... Except This Statement
Re: FORUM DISRUPTION: Server Upgrade
« Reply #26 on: March 29, 2017, 10:09:52 am »
Isn't that the point where you send off ram sticks in the post ?
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #27 on: March 29, 2017, 09:55:29 pm »
My hosting provider, 1and1, has full dedicated servers with 32 GB RAM, 12 cores x 2.3 GHz and 2 TB RAID 1 harddisk for $200 per month. Just in case you need some arguments for HostGator :)

I am paying $130 for E3-1245, 32GB RAM and 2x 480GB SSD... and that is in Australia! Why are HG so expensive?
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #28 on: March 29, 2017, 10:11:18 pm »
My hosting provider, 1and1, has full dedicated servers with 32 GB RAM, 12 cores x 2.3 GHz and 2 TB RAID 1 harddisk for $200 per month. Just in case you need some arguments for HostGator :)
I am paying $130 for E3-1245, 32GB RAM and 2x 480GB SSD... and that is in Australia! Why are HG so expensive?

Because, reasons...
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #29 on: March 29, 2017, 10:20:18 pm »
My hosting provider, 1and1, has full dedicated servers with 32 GB RAM, 12 cores x 2.3 GHz and 2 TB RAID 1 harddisk for $200 per month. Just in case you need some arguments for HostGator :)
I am paying $130 for E3-1245, 32GB RAM and 2x 480GB SSD... and that is in Australia! Why are HG so expensive?

Because, reasons...

I fully know why you use HG, and I support your position on this, just seems odd that they want so much for extra RAM. I have many client's hosted with WebNX in the US, dealings with WebNX have always been prompt, support has always been excellent, etc. We just upgraded a server from 64GB to 128GB of ECC RAM, and it cost an extra $40US per month. I get that HG have a custom hosting infrastructure and offering, the VM setup makes that very clear, but this setup should reduce their running costs, not push them up.
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #30 on: March 29, 2017, 10:23:24 pm »
If I was to move hosts again then I wouldn't choose a US based one. Simple reason, DMCA.

I'd like to use an Australian host, just because, but given that 95% of my audience is elsewhere in the world, I figure that's not the best option.
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #31 on: March 29, 2017, 10:27:36 pm »
If I was to move hosts again then I wouldn't choose a US based one. Simple reason, DMCA.

Ah yeah, I forgot about that fiasco. The issue is that most visitors to this website are US based, the performance is crazy for them with this new setup. It is great for us too, but we see 200-300ms of latency on the initial connection. If you were to go elsewhere I would suggest AU simply to make management a better experience, but I am biased from this point of view. I certainly would not consider any of the EU hosting offerings, the latency to EU from AU is terrible, exceeding 350-400ms. Hosting in China we get decent latency, around 200ms, but support isn't always great.

You could always host in Canada, for the US the latency is still great, for us it is about the same, but I don't know if the DMCA applies there.
« Last Edit: March 29, 2017, 10:29:21 pm by gnif »
 

Offline Fsck

  • Super Contributor
  • ***
  • Posts: 1157
  • Country: ca
  • sleep deprived
Re: FORUM DISRUPTION: Server Upgrade
« Reply #32 on: March 29, 2017, 10:54:31 pm »
Have you considered OVH?
Their pricing is pretty competitive. (if you're in Canada, their pricing actually crushes everyone else due to the exchange rate now.)
"This is a one line proof...if we start sufficiently far to the left."
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #33 on: March 29, 2017, 10:57:44 pm »
Have you considered OVH?
Their pricing is pretty competitive. (if you're in Canada, their pricing actually crushes everyone else due to the exchange rate now.)

I have used OVH in Canada for quite some time, pros are costing and the scale of their network, etc... Cons, support is terrible, takes days often weeks to get an issue resolved. Most of their staff doesn't speak English, so the website auto-translates your tickets to French, which loses a lot. And you get what you pay for, they do not allow you to alter a host after the fact (ie, add RAM or a HDD).

They have just started offering hosting in AU which I have a test server with, so far this seems much better support wise then the CA support, but I suspect this is because the service is still considered experimental.
 

Offline Fsck

  • Super Contributor
  • ***
  • Posts: 1157
  • Country: ca
  • sleep deprived
Re: FORUM DISRUPTION: Server Upgrade
« Reply #34 on: March 29, 2017, 11:38:42 pm »
you do get what you for with OVH though. (cheapest product = cheapest support, since you can't counterfeit hardware)

they're leagues cheaper than anyone else though.
if you want to customize and evolve over time, colo is really much better.

I don't have a lot of experience with hosting, but the dozen or so odd providers I've used that do allow upgrades charge silly monthly price increases for hardware upgrades. If all you want is data transfer, they'll do that for a good price, no problemo but want a single 4GB stick of ram? - that'll be 4$ a month + 30$ installation fee with no option to just outright buy one for them.
"This is a one line proof...if we start sufficiently far to the left."
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #35 on: March 30, 2017, 12:20:14 am »
if you want to customize and evolve over time, colo is really much better.

The problem with collocation is that you now have to support the hardware and have spares on hand, possibly even rent some storage. If you need hands on you pay $100p/h on average. Since the server would not be local, Dave would have to pay for hands on, shipping parts, etc. In the end it is best to keep it simple and rent it. $4 + $30 install is extremely cheap compared with what HG are charging/gouging for.

Also if you had to pay for hands on, that's $100 + say $80-100 for the RAM, lets say $200. Where renting it at $4p/m, would take 50 months (4.16 years) to cost the same (not inc the install fee). Colo only makes sense if you are physically close to the DC to support your gear.
« Last Edit: March 30, 2017, 12:24:38 am by gnif »
 

Offline cw360

  • Newbie
  • Posts: 4
  • Country: us
Re: FORUM DISRUPTION: Server Upgrade
« Reply #36 on: March 30, 2017, 06:17:55 pm »
The head of marketing at HostGator (who is a fan BTW)

Gentlemen,

That guy is me..... At this point I should probably put on the body armor.... Outing yourself as a HostGator employee is typically seen as a risky move.

Dave is correct, I am a fan. I have been watching for years. I am a Marketing guy who plays with electronics on the weekends (arduino, raspberry pi, ham radio, 3d printing). But I should emphasize, much more Marketing than Engineering. The show and the forum have really helped me out with many personal projects. So a much delayed thank you to all of you.

Anyway, I am willing to field questions if you have them. If you throw anything too technical at me, it may take me a bit to find the answer or make sure it’s something we can actually share publicly. 
 
The following users thanked this post: EEVblog, SeanB, rkupka, Kean

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #37 on: March 30, 2017, 06:55:26 pm »
The head of marketing at HostGator (who is a fan BTW)

Gentlemen,

That guy is me..... At this point I should probably put on the body armor.... Outing yourself as a HostGator employee is typically seen as a risky move.

Dave is correct, I am a fan. I have been watching for years. I am a Marketing guy who plays with electronics on the weekends (arduino, raspberry pi, ham radio, 3d printing). But I should emphasize, much more Marketing than Engineering. The show and the forum have really helped me out with many personal projects. So a much delayed thank you to all of you.

Anyway, I am willing to field questions if you have them. If you throw anything too technical at me, it may take me a bit to find the answer or make sure it’s something we can actually share publicly.

Hi, nice to see you on here :)

I can say personally that I get a ton of use out of the website, videos and forum like yourself, and it is what drew me to offer my services as a way to give back. The questions I would like to ask I do not feel is my right to do so, as they are cost related and I will not be so bold to presume to think that Dave would like to see it discussed openly here.

From a technical POV we are pretty well informed and up to speed on how the HG hosting is setup, and I have spent many many hours tuning the server to run on your systems as optimal as possible. Our latest round of updates, both server side software changes and the memory increase have made an enormous difference. So I will make the same offer in return, if HG are interested in how we have this forum responding so well on this setup, please ask away, but note that some details are trade secrets.
 
The following users thanked this post: EEVblog

Offline cw360

  • Newbie
  • Posts: 4
  • Country: us
Re: FORUM DISRUPTION: Server Upgrade
« Reply #38 on: March 30, 2017, 07:26:55 pm »
The head of marketing at HostGator (who is a fan BTW)

Gentlemen,

That guy is me..... At this point I should probably put on the body armor.... Outing yourself as a HostGator employee is typically seen as a risky move.

Dave is correct, I am a fan. I have been watching for years. I am a Marketing guy who plays with electronics on the weekends (arduino, raspberry pi, ham radio, 3d printing). But I should emphasize, much more Marketing than Engineering. The show and the forum have really helped me out with many personal projects. So a much delayed thank you to all of you.

Anyway, I am willing to field questions if you have them. If you throw anything too technical at me, it may take me a bit to find the answer or make sure it’s something we can actually share publicly.

Hi, nice to see you on here :)

I can say personally that I get a ton of use out of the website, videos and forum like yourself, and it is what drew me to offer my services as a way to give back. The questions I would like to ask I do not feel is my right to do so, as they are cost related and I will not be so bold to presume to think that Dave would like to see it discussed openly here.

From a technical POV we are pretty well informed and up to speed on how the HG hosting is setup, and I have spent many many hours tuning the server to run on your systems as optimal as possible. Our latest round of updates, both server side software changes and the memory increase have made an enormous difference. So I will make the same offer in return, if HG are interested in how we have this forum responding so well on this setup, please ask away, but note that some details are trade secrets.

Whew, so far so good. Don't have to go into hiding yet.....

Glad you guys are here for Dave. I have been surprised when large youtubers/social media people (even corporate backed) have signed up for basic hosting (without talking to us) and then get surprised when their audience crushes a shared box. Speaks volumes about this community and Dave's foresight. Granted he is a born engineer turned social media guy, not original social media.

Re: your question: we took care of it.

Just throwing this out there. If you are ever interested in writing up a list of pro-tips, we are always looking for great guest posts on our blog. Would love to do a case study. Great way of getting some SEO love for the community. Not that this forum needs it in the slightest.

BTW, this thing is wicked fast.  :D I love/hate it when customers are faster than we are. lol

Another thing... Any thought to putting an SSL on here? We could probably make that happen......


 

Offline mrpackethead

  • Super Contributor
  • ***
  • Posts: 2845
  • Country: nz
  • D Size Cell
Re: FORUM DISRUPTION: Server Upgrade
« Reply #39 on: March 30, 2017, 09:22:29 pm »
@cw360,

Do you have ipv6 at your site..
On a quest to find increasingly complicated ways to blink things
 

Offline cw360

  • Newbie
  • Posts: 4
  • Country: us
Re: FORUM DISRUPTION: Server Upgrade
« Reply #40 on: March 30, 2017, 10:47:47 pm »
@mrpackethead

Hopefully I did that mention correctly. Had to go talk to the network guys about this one. They are actively educating me on data center architecture. Unfortunately, the official/short answer is: currently no.
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #41 on: March 31, 2017, 12:49:47 am »
The head of marketing at HostGator (who is a fan BTW)
Gentlemen,
That guy is me..... At this point I should probably put on the body armor.... Outing yourself as a HostGator employee is typically seen as a risky move.
Dave is correct, I am a fan. I have been watching for years. I am a Marketing guy who plays with electronics on the weekends (arduino, raspberry pi, ham radio, 3d printing). But I should emphasize, much more Marketing than Engineering. The show and the forum have really helped me out with many personal projects. So a much delayed thank you to all of you.
Anyway, I am willing to field questions if you have them. If you throw anything too technical at me, it may take me a bit to find the answer or make sure it’s something we can actually share publicly.

Big thanks.
FYI to all, HostGator came to the party and massively dropped the rates for the server with the new RAM  :-+
Given how well the new server is now running, and the new low pricing, I'll be sticking with Hostgator.
 
The following users thanked this post: rkupka

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #42 on: March 31, 2017, 12:53:34 am »
Another thing... Any thought to putting an SSL on here? We could probably make that happen......

That's been discussed many times on here.
I'm sure gnif can fill you in the tech details as he has investigated this extensively I believe.
I would like to, as a lot of people have asked for it, but I believe there are some technical hurdles to overcome.
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #43 on: March 31, 2017, 03:10:52 am »
Another thing... Any thought to putting an SSL on here? We could probably make that happen......

That's been discussed many times on here.
I'm sure gnif can fill you in the tech details as he has investigated this extensively I believe.
I would like to, as a lot of people have asked for it, but I believe there are some technical hurdles to overcome.

The technical hurdles are no longer much of an issue anymore, the concern was always with performance. We have three options here

1) use CloudFlare for SSL, but that means we must proxy through them.
2) use letsencrypt.org for a free SSL cert, this involves a little bit of setup on the server to renew the cert before it expires as these have a 3 month expiry.
3) purchase a SSL certificate
 

Offline FrankBuss

  • Supporter
  • ****
  • Posts: 2365
  • Country: de
    • Frank Buss
Re: FORUM DISRUPTION: Server Upgrade
« Reply #44 on: March 31, 2017, 03:22:07 am »
2) use letsencrypt.org for a free SSL cert, this involves a little bit of setup on the server to renew the cert before it expires as these have a 3 month expiry.

Interesting service. It is not much of a problem for this forum, but such a service sounds like the perfect way for the NSA or other 3 letter agencies to get private SSL keys.
So Long, and Thanks for All the Fish
Electronics, hiking, retro-computing, electronic music etc.: https://www.youtube.com/c/FrankBussProgrammer
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #45 on: March 31, 2017, 03:23:16 am »
2) use letsencrypt.org for a free SSL cert, this involves a little bit of setup on the server to renew the cert before it expires as these have a 3 month expiry.

Interesting service. It is not much of a problem for this forum, but such a service sounds like the perfect way for the NSA or other 3 letter agencies to get private SSL keys.

The private key never leaves the server, its a proper CA just has an API to perform automated renewals.
 

Offline CatalinaWOW

  • Super Contributor
  • ***
  • Posts: 5226
  • Country: us
Re: FORUM DISRUPTION: Server Upgrade
« Reply #46 on: March 31, 2017, 03:25:14 am »
Late to the response, but the upgrade has really been noticeable here from a satellite connection.  A few bumps during the transition, but extremely responsive by comparison.  Thanks to all who worked on it, and a big thank you to HostGator for making it affordable for Dave.
 

Offline xrunner

  • Super Contributor
  • ***
  • Posts: 7513
  • Country: us
  • hp>Agilent>Keysight>???
Re: FORUM DISRUPTION: Server Upgrade
« Reply #47 on: March 31, 2017, 03:32:02 am »
No error messages for days - Yay!  :-+
I told my friends I could teach them to be funny, but they all just laughed at me.
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #48 on: March 31, 2017, 04:46:09 am »
Another thing... Any thought to putting an SSL on here? We could probably make that happen......
That's been discussed many times on here.
I'm sure gnif can fill you in the tech details as he has investigated this extensively I believe.
I would like to, as a lot of people have asked for it, but I believe there are some technical hurdles to overcome.
The technical hurdles are no longer much of an issue anymore, the concern was always with performance. We have three options here
1) use CloudFlare for SSL, but that means we must proxy through them.

So if we chose to do that and we disable Cloudflare then the website revokes back to http only?

Quote
2) use letsencrypt.org for a free SSL cert, this involves a little bit of setup on the server to renew the cert before it expires as these have a 3 month expiry.
3) purchase a SSL certificate

Which type do we need?
http://support.hostgator.com/articles/ssl-certificates/acquire-ssl/how-do-i-purchase-an-ssl-and-what-type-is-it



 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #49 on: March 31, 2017, 04:49:25 am »
So if we chose to do that and we disable Cloudflare then the website revokes back to http only?

Only if we do not install a cert on the server.

Which type do we need?
http://support.hostgator.com/articles/ssl-certificates/acquire-ssl/how-do-i-purchase-an-ssl-and-what-type-is-it

For this website since there is no real sensitive information, the cheapest option. You do not need to use HG for this, any certificate authority is fine, personally I have used RapidSSL, and AlphaSSL, but I believe there are better/cheaper options today. To be completely honest though if it was me I would just go for the letsencrypt.org service, it is if anything more secure then a generic SSL cert from other providers as it renews every 3 months, and the setup is quite simple on the server.
 

Offline amspire

  • Super Contributor
  • ***
  • Posts: 3802
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #50 on: March 31, 2017, 04:50:53 am »
2) use letsencrypt.org for a free SSL cert, this involves a little bit of setup on the server to renew the cert before it expires as these have a 3 month expiry.

Interesting service. It is not much of a problem for this forum, but such a service sounds like the perfect way for the NSA or other 3 letter agencies to get private SSL keys.
LetsEncrypt went through a long period of public security auditing before they offered their service, so it is one of the more secure SSL solutions. It is done properly.

There are many hosting companies that support LetsEncrypt, and they will automatically renew every 3 months - so all you have to do is request a free SSL cert in the CPanel, and you have a certificate that will automatically renew for as long as you want.

Most CPanel hosts now let you enter your own key, so I have 3 LetsEncrypt certs I generate every 3 months (single batch file to update all three), and then I manually add the new keys to tye Cpanels.

For companies, I have always just got a commercial one - RapidSSL is something like A$12 a year if you buy from the right reseller.

Digicert is used by the likes of Facebook, so it is not a bad choice for companies.
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #51 on: March 31, 2017, 04:51:54 am »
2) use letsencrypt.org for a free SSL cert, this involves a little bit of setup on the server to renew the cert before it expires as these have a 3 month expiry.

Interesting service. It is not much of a problem for this forum, but such a service sounds like the perfect way for the NSA or other 3 letter agencies to get private SSL keys.
LetsEncrypt went through a long period of public security auditing before they offered their service, so it is one of the more secure SSL solutions. It is done properly.

There are many hosting companies that support LetsEncrypt, and they will automatically renew every 3 months - so all you have to do is request a free SSL cert in the CPanel, and you have a certificate that will automatically renew for as long as you want.

Most CPanel hosts now let you enter your own key, so I have 3 LetsEncrypt certs I generate every 3 months (single batch file to update all three), and then I manually add the new keys to tye Cpanels.

For companies, I have always just got a commercial one - RapidSSL is something like A$12 a year if you buy from the right reseller.

Digicert is used by the likes of Facebook, so it is not a bad choice for companies.

cPanel is not an option here for the renewal process, this server while runs cPanel is not using it for hosting, it's too slow. This is not an issue though as I can setup some custom scripts to handle the renewal.
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #52 on: March 31, 2017, 04:53:15 am »
For this website since there is no real sensitive information, the cheapest option. You do not need to use HG for this, any certificate authority is fine, personally I have used RapidSSL, and AlphaSSL, but I believe there are better/cheaper options today. To be completely honest though if it was me I would just go for the letsencrypt.org service, it is if anything more secure then a generic SSL cert from other providers as it renews every 3 months, and the setup is quite simple on the server.

I like the idea of a new certificate every few months from a "why not" point of view.
How much work is involved in setting this up?
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #53 on: March 31, 2017, 04:53:53 am »
For this website since there is no real sensitive information, the cheapest option. You do not need to use HG for this, any certificate authority is fine, personally I have used RapidSSL, and AlphaSSL, but I believe there are better/cheaper options today. To be completely honest though if it was me I would just go for the letsencrypt.org service, it is if anything more secure then a generic SSL cert from other providers as it renews every 3 months, and the setup is quite simple on the server.

I like the idea of a new certificate every few months from a "why not" point of view.
How much work is involved in setting this up?

About 1/2 hour, nothing huge.
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #54 on: March 31, 2017, 04:55:56 am »
About 1/2 hour, nothing huge.

Make it so when you have some free time!
I can add the SSL certificate to Cloudflare I believe if that's required.
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #55 on: March 31, 2017, 04:57:25 am »
About 1/2 hour, nothing huge.

Make it so when you have some free time!
I can add the SSL certificate to Cloudflare I believe if that's required.

Great, I will later today. In the CF configuration you just tell it to use "Strict" mode, then it enforces the SSL cert your server produces is valid.
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #56 on: March 31, 2017, 05:11:04 am »
About 1/2 hour, nothing huge.

Make it so when you have some free time!
I can add the SSL certificate to Cloudflare I believe if that's required.

Great, I will later today. In the CF configuration you just tell it to use "Strict" mode, then it enforces the SSL cert your server produces is valid.

Great, thanks.
Should start a new thread for this to report issues and discuss. Many nerds may rejoice.
 

Offline amspire

  • Super Contributor
  • ***
  • Posts: 3802
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #57 on: March 31, 2017, 05:15:46 am »
For this website since there is no real sensitive information, the cheapest option. You do not need to use HG for this, any certificate authority is fine, personally I have used RapidSSL, and AlphaSSL, but I believe there are better/cheaper options today. To be completely honest though if it was me I would just go for the letsencrypt.org service, it is if anything more secure then a generic SSL cert from other providers as it renews every 3 months, and the setup is quite simple on the server.

I like the idea of a new certificate every few months from a "why not" point of view.
How much work is involved in setting this up?
The 3 month expiry is a great idea. If someone hacks your site and gets the keys to your commercial 2+ year SSL certificate, they can pretend to be you. You can revoke the certificate, but it is up to the browsers to check to see if certificates are revoked or not. As far as I know, Chrome does not actually check for revoked certs. They have their own system that can accept some revoked certificates.
 

Offline rrinker

  • Super Contributor
  • ***
  • Posts: 2046
  • Country: us
Re: FORUM DISRUPTION: Server Upgrade
« Reply #58 on: March 31, 2017, 01:40:58 pm »
 I'm pretty sure Chrome blocks if the cert is revoked just like other browsers. Just had a customer attempt to replace their SHA-1 certs with SHA-256 and didn't realize that once he requests the existing cert to be re-keyed it revokes the old version of it, and attempting to access the site using this cert with Chrome resulted in a revocation error until it was replaced. Prior to rekeying, the error in Chrome was the one that since it was SHA-1 it wasn't actually secure.


 

Offline jippie

  • Supporter
  • ****
  • Posts: 118
  • Country: nl
Re: FORUM DISRUPTION: Server Upgrade
« Reply #59 on: March 31, 2017, 10:37:52 pm »
Seems the forum is no longer sending HTTP_REFERER, which broke my dynamic avatar  :--

Stopped working probably somewhere between:
31/Mar/2017:13:03:04 +0200
and
31/Mar/2017:14:24:58 +0200
« Last Edit: March 31, 2017, 10:44:33 pm by jippie »
 

Offline amspire

  • Super Contributor
  • ***
  • Posts: 3802
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #60 on: March 31, 2017, 11:05:08 pm »
I'm pretty sure Chrome blocks if the cert is revoked just like other browsers. Just had a customer attempt to replace their SHA-1 certs with SHA-256 and didn't realize that once he requests the existing cert to be re-keyed it revokes the old version of it, and attempting to access the site using this cert with Chrome resulted in a revocation error until it was replaced. Prior to rekeying, the error in Chrome was the one that since it was SHA-1 it wasn't actually secure.
Last I heard, Google had decided not to let browsers check if a cert was revoked, but instead Google runs its own in-house tracking of revoked certs, and somehow Chrome uses this Google service. They did have an optional setting to re-enable revoke cert checking in Chrome, but that seems to have disappeared. This solution often works but not all the time. Google's cert database may be much faster, but it is not necessarily comprehensive or up-to-date.

If Google has gone back to allowing Chrome to directly check for revoked certs, it would be interesting to know.
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #61 on: April 05, 2017, 12:47:44 am »
Big jump in the number of forum sessions:
 

Offline cw360

  • Newbie
  • Posts: 4
  • Country: us
Re: FORUM DISRUPTION: Server Upgrade
« Reply #62 on: April 05, 2017, 12:53:33 am »
Big jump in the number of forum sessions:

Wow. This new traffic from somewhere? Google? I know they like SSLs.....

What do the source reports say?

If it's direct/eevblog.com there might be a self refer issue in the analytics.


Sent from my iPhone using Tapatalk
 

Offline tautech

  • Super Contributor
  • ***
  • Posts: 28328
  • Country: nz
  • Taupaki Technologies Ltd. Siglent Distributor NZ.
    • Taupaki Technologies Ltd.
Re: FORUM DISRUPTION: Server Upgrade
« Reply #63 on: April 05, 2017, 04:01:54 am »
Big jump in the number of forum sessions:

There's been some crazy #'s viewing GK's thread:
https://www.eevblog.com/forum/projects/oscilloscope-pong-for-1-or-2-players/
Avid Rabid Hobbyist
Siglent Youtube channel: https://www.youtube.com/@SiglentVideo/videos
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #64 on: April 05, 2017, 06:39:17 am »
What is the date of the jump?
What is the cycle of the peaks/troughs in the new session level? Weekly?
What is the old/new session length on average?

Like i've said before I'm no network expert but is there a session reuse or maybe it is called persistent sessions. Has that changed?

This coincides with fixing the 502 errors, I suspect CF has been serving tons of cached requests to try to work around the issue, we saw this jump before we turned on SSL.
 

Offline dimkasta

  • Regular Contributor
  • *
  • Posts: 185
  • Country: gr
Re: FORUM DISRUPTION: Server Upgrade
« Reply #65 on: April 05, 2017, 02:19:18 pm »
I have letsencrypt on a couple of small sites for testing. I have no issues with it yet. Through cpanel, or using Laravel's homestead/forge.
You might want to check Taylor Otwell's scripts if you don't want to write them yourself. I think they are available with homestead.
Also, keep an eye on their newsletter. They recently changed their services, and caused disruption on certificate updates for many sites that did not update their scripts in time.

About cloudflare, keep an eye on your webmaster tools too. you might have to fiddle with seo settings or sitemap creation.
Google deindexed all images when we switched to https on one of our sites (without any obvious seo problems)
 

Offline tautech

  • Super Contributor
  • ***
  • Posts: 28328
  • Country: nz
  • Taupaki Technologies Ltd. Siglent Distributor NZ.
    • Taupaki Technologies Ltd.
Re: FORUM DISRUPTION: Server Upgrade
« Reply #66 on: April 06, 2017, 12:24:30 am »
Short period of forum outages that lasted only a minute or two @~12.20 NZ time.
522 error.
Avid Rabid Hobbyist
Siglent Youtube channel: https://www.youtube.com/@SiglentVideo/videos
 

Offline dimkasta

  • Regular Contributor
  • *
  • Posts: 185
  • Country: gr
Re: FORUM DISRUPTION: Server Upgrade
« Reply #67 on: April 06, 2017, 01:06:46 am »
Same here
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #68 on: April 06, 2017, 03:48:19 am »
Short period of forum outages that lasted only a minute or two @~12.20 NZ time.
522 error.

Thanks,

522 is a CloudFlare error, it is when CF can not establish a connection to the server, there has been no server faults or reported network outages on our end, I would guess that there was a temporary down route somewhere between CF and the server.
 
The following users thanked this post: tautech

Offline tautech

  • Super Contributor
  • ***
  • Posts: 28328
  • Country: nz
  • Taupaki Technologies Ltd. Siglent Distributor NZ.
    • Taupaki Technologies Ltd.
Re: FORUM DISRUPTION: Server Upgrade
« Reply #69 on: April 29, 2017, 12:09:29 am »
Gotta say how good the forum's been lately....just brilliant.  :-+

Not an error at all for weeks, just perfect.
Thanks Dave for putting your hand in your pocket and gnif for the grafting and tweaks.  :-/O
« Last Edit: April 29, 2017, 12:35:39 am by tautech »
Avid Rabid Hobbyist
Siglent Youtube channel: https://www.youtube.com/@SiglentVideo/videos
 
The following users thanked this post: SeanB

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #70 on: April 29, 2017, 12:49:18 am »
Gotta say how good the forum's been lately....just brilliant.  :-+

Not an error at all for weeks, just perfect.
Thanks Dave for putting your hand in your pocket and gnif for the grafting and tweaks.  :-/O

Thanks mate, I am glad to hear it :)
 
The following users thanked this post: SeanB, tautech

Offline tautech

  • Super Contributor
  • ***
  • Posts: 28328
  • Country: nz
  • Taupaki Technologies Ltd. Siglent Distributor NZ.
    • Taupaki Technologies Ltd.
Re: FORUM DISRUPTION: Server Upgrade
« Reply #71 on: April 29, 2017, 12:56:03 am »
Gotta say how good the forum's been lately....just brilliant.  :-+

Not an error at all for weeks, just perfect.
Thanks Dave for putting your hand in your pocket and gnif for the grafting and tweaks.  :-/O

Thanks mate, I am glad to hear it :)
Thought I'd mention it as we all have a bitch quick enough when things aren't going right but we're often a bit slow to commend your efforts after all is well. Been meaning to say something for a few days but you know how it gets sometimes..............
Avid Rabid Hobbyist
Siglent Youtube channel: https://www.youtube.com/@SiglentVideo/videos
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #72 on: April 29, 2017, 01:03:36 am »
Gotta say how good the forum's been lately....just brilliant.  :-+
Not an error at all for weeks, just perfect.
Thanks Dave for putting your hand in your pocket and gnif for the grafting and tweaks.  :-/O

I originally did put my hand in my pocket, but then full credit to HostGator who really came to the party and are now offering me the improved server for like half what I was paying before  :clap:
And yes, as always a huge thanks to gnif who spends a lot of time tweaking and maintaing the server for free  :-+

BTW, I did get a 502 yesterday for like 30 seconds.
 
The following users thanked this post: SeanB

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #73 on: April 29, 2017, 01:13:17 am »
Gotta say how good the forum's been lately....just brilliant.  :-+
Not an error at all for weeks, just perfect.
Thanks Dave for putting your hand in your pocket and gnif for the grafting and tweaks.  :-/O

I originally did put my hand in my pocket, but then full credit to HostGator who really came to the party and are now offering me the improved server for like half what I was paying before  :clap:
And yes, as always a huge thanks to gnif who spends a lot of time tweaking and maintaing the server for free  :-+

BTW, I did get a 502 yesterday for like 30 seconds.

No problem mate, do you recall roughly what time it occurred at?
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #74 on: April 29, 2017, 01:24:08 am »
Gotta say how good the forum's been lately....just brilliant.  :-+
Not an error at all for weeks, just perfect.
Thanks Dave for putting your hand in your pocket and gnif for the grafting and tweaks.  :-/O

I originally did put my hand in my pocket, but then full credit to HostGator who really came to the party and are now offering me the improved server for like half what I was paying before  :clap:
And yes, as always a huge thanks to gnif who spends a lot of time tweaking and maintaing the server for free  :-+

BTW, I did get a 502 yesterday for like 30 seconds.

No problem mate, do you recall roughly what time it occurred at?

Yesterday afternoon some time.
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #75 on: April 29, 2017, 01:45:06 am »
Yesterday afternoon some time.

Strange, I only see two errors for any of your IPs over the last two weeks, both of which are some bug in Sendy (see below, heavily redacted for security).

error.log-20170420.gz:2017/04/19 15:07:21 [error] 24952#0: *59443517 FastCGI sent in stderr: "PHP message: PHP Warning:  Cannot modify header information - headers already sent by (output started at redacted) in redacted on line redacted" while reading upstream, client: redacted, server: redacted, request: "GET redacted HTTP/1.1", upstream: "fastcgi://unix:redacted", host: "redacted", referrer: "redacted"
error.log-20170421.gz:2017/04/20 19:32:25 [error] 24953#0: *62660078 FastCGI sent in stderr: "PHP message: PHP Warning:  Cannot modify header information - headers already sent by (output started at redacted) in redacted: eval()'d code on line redacted" while reading upstream, client: redacted, server: redacted, request: "GET redacted HTTP/1.1", upstream: "fastcgi://unix:redacted", host: "redacted", referrer: "redacted"

Both of which are just header warnings, neither of which would have thrown a 502 error.
« Last Edit: April 29, 2017, 01:51:55 am by gnif »
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #76 on: April 29, 2017, 06:52:45 am »
Glitch in the matrix
 

Offline PA0PBZ

  • Super Contributor
  • ***
  • Posts: 5126
  • Country: nl
Re: FORUM DISRUPTION: Server Upgrade
« Reply #77 on: April 29, 2017, 08:12:00 am »
Yes it is working fine now, no more endless waiting for page loads and no more load errors.
I noticed something weird though, probably a forum software glitch? It's the "Local time" in the profiles.
For instance at the moment Gnif's profile says "Local Time:30 April 2017, 05:08:36" and for Dave it says "Local Time:29 April 2017, 18:10:23"
I'm sure you guys are not that far apart  :)
Keyboard error: Press F1 to continue.
 
The following users thanked this post: gnif

Offline RGB255_0_0

  • Frequent Contributor
  • **
  • Posts: 772
  • Country: gb
Your toaster just set fire to an African child over TCP.
 

Offline PA0PBZ

  • Super Contributor
  • ***
  • Posts: 5126
  • Country: nl
Re: FORUM DISRUPTION: Server Upgrade
« Reply #79 on: April 29, 2017, 09:00:47 am »
There is a profile setting in "look and layout" to set a time offset to correct the displayed time to your local time.

Yes I know, and I guessed almost everyone sets this to have the post times correct, but if I check the local time about 3/4 is incorrect. Maybe they just don't care?
Keyboard error: Press F1 to continue.
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #80 on: April 29, 2017, 12:51:32 pm »
Hah, I had not even noticed, I just corrected it! I set it to +11 out of habit without even thinking that the server's timezone is AEST already. Servers I manage generally run on UTC.
« Last Edit: April 29, 2017, 12:53:05 pm by gnif »
 

Offline Brumby

  • Supporter
  • ****
  • Posts: 12297
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #81 on: April 29, 2017, 12:53:11 pm »
... and here was me thinking you were that far ahead of the game.
 

Online Monkeh

  • Super Contributor
  • ***
  • Posts: 7992
  • Country: gb
Re: FORUM DISRUPTION: Server Upgrade
« Reply #82 on: April 30, 2017, 02:49:25 am »
Hah, I had not even noticed, I just corrected it! I set it to +11 out of habit without even thinking that the server's timezone is AEST already. Servers I manage generally run on UTC.

Perhaps this one should run on UTC too. Although that might make a mess of DB log/journaling timestamps during the changover. But one isolated server probably doesn't matter in the grand scheme of things.

Does that mean the time is changed for DST? Does the overlapping timestamps when going back an hour not create a problem?

Timestamps will all actually be stored in Unix time. Everything is actually in UTC (..close enough, anyway) - it just applies an offset for display.

It does cause everyone not in the same timezone to need to change their timezone four times a year on the forum, however, as SMF is, well, Simple.
« Last Edit: April 30, 2017, 02:51:08 am by Monkeh »
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #83 on: April 30, 2017, 02:50:53 am »
Hah, I had not even noticed, I just corrected it! I set it to +11 out of habit without even thinking that the server's timezone is AEST already. Servers I manage generally run on UTC.

Perhaps this one should run on UTC too. Although that might make a mess of DB log/journaling timestamps during the changover. But one isolated server probably doesn't matter in the grand scheme of things.

Does that mean the time is changed for DST? Does the overlapping timestamps when going back an hour not create a problem?

Timestamps will all actually be stored in Unix time. Everything is actually in UTC (..close enough, anyway) - it just applies an offset.

It does cause everyone not in the same timezone to need to change their timezone four times a year on the forum, however..

I wonder how hard it will be to patch SMF to just do it properly... when I get a little time I will investigate.
 

Online Monkeh

  • Super Contributor
  • ***
  • Posts: 7992
  • Country: gb
Re: FORUM DISRUPTION: Server Upgrade
« Reply #84 on: April 30, 2017, 02:56:37 am »
I wonder how hard it will be to patch SMF to just do it properly... when I get a little time I will investigate.

That'd be nice.

A little brief searching suggests they've never implemented it because they don't like 'too many options' (okay, there are a lot of timezones, but SMF is presently as dumb as my microwave..).
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #85 on: April 30, 2017, 02:57:33 am »
I wonder how hard it will be to patch SMF to just do it properly... when I get a little time I will investigate.

That'd be nice.

A little brief searching suggests they've never implemented it because they don't like 'too many options' (okay, there are a lot of timezones, but SMF is presently as dumb as my microwave..).

It should be simple, they have already implemented the time offset stuff, clearly they are using the 'date' function everywhere instead of the 'gmdate' function.
 

Offline tautech

  • Super Contributor
  • ***
  • Posts: 28328
  • Country: nz
  • Taupaki Technologies Ltd. Siglent Distributor NZ.
    • Taupaki Technologies Ltd.
Re: FORUM DISRUPTION: Server Upgrade
« Reply #86 on: April 30, 2017, 03:02:41 am »
Running Win 7 and time linked to some online clock gives zero problems for NZ daylight saving times.
Once you've got your offset from the forum default sorted and set, it works without issue.... does here anyway.
Avid Rabid Hobbyist
Siglent Youtube channel: https://www.youtube.com/@SiglentVideo/videos
 

Online Monkeh

  • Super Contributor
  • ***
  • Posts: 7992
  • Country: gb
Re: FORUM DISRUPTION: Server Upgrade
« Reply #87 on: April 30, 2017, 03:05:33 am »
I wonder how hard it will be to patch SMF to just do it properly... when I get a little time I will investigate.

That'd be nice.

A little brief searching suggests they've never implemented it because they don't like 'too many options' (okay, there are a lot of timezones, but SMF is presently as dumb as my microwave..).

It should be simple, they have already implemented the time offset stuff, clearly they are using the 'date' function everywhere instead of the 'gmdate' function.

The issue appears to be with presenting the full range of options - if you just do a drop-down menu there are 561 options (and 385 unique zones, lots of links) in the tz database. Even cut down it's a long list. Some sort of graphical picker helps there, but requires more work to implement.

Personally I'd be happy with a box and instructions to locate the correct zone.

Running Win 7 and time linked to some online clock gives zero problems for NZ daylight saving times.
Once you've got your offset from the forum default sorted and set, it works without issue.... does here anyway.

DST start/end dates around the world do not align. I get to change it four times a year. This is boring.
 

Offline tautech

  • Super Contributor
  • ***
  • Posts: 28328
  • Country: nz
  • Taupaki Technologies Ltd. Siglent Distributor NZ.
    • Taupaki Technologies Ltd.
Re: FORUM DISRUPTION: Server Upgrade
« Reply #88 on: April 30, 2017, 03:12:01 am »
Running Win 7 and time linked to some online clock gives zero problems for NZ daylight saving times.
Once you've got your offset from the forum default sorted and set, it works without issue.... does here anyway.

DST start/end dates around the world do not align. I get to change it four times a year. This is boring.
Yeah I get that and used to get the same, that's why I mentioned linking of your PC clock to an online source AND having the correct timezone and country set on your PC too. (didn't mention that before.)

Never need to adjust mine for the forums I frequent, the PC just sorts it for me.
Avid Rabid Hobbyist
Siglent Youtube channel: https://www.youtube.com/@SiglentVideo/videos
 

Online Monkeh

  • Super Contributor
  • ***
  • Posts: 7992
  • Country: gb
Re: FORUM DISRUPTION: Server Upgrade
« Reply #89 on: April 30, 2017, 03:19:05 am »
Running Win 7 and time linked to some online clock gives zero problems for NZ daylight saving times.
Once you've got your offset from the forum default sorted and set, it works without issue.... does here anyway.

DST start/end dates around the world do not align. I get to change it four times a year. This is boring.
Yeah I get that and used to get the same, that's why I mentioned linking of your PC clock to an online source AND having the correct timezone and country set on your PC too. (didn't mention that before.)

My clocks are accurate. That does not stop the apparent server time changing.
 

Offline tautech

  • Super Contributor
  • ***
  • Posts: 28328
  • Country: nz
  • Taupaki Technologies Ltd. Siglent Distributor NZ.
    • Taupaki Technologies Ltd.
Re: FORUM DISRUPTION: Server Upgrade
« Reply #90 on: April 30, 2017, 04:49:56 am »
Running Win 7 and time linked to some online clock gives zero problems for NZ daylight saving times.
Once you've got your offset from the forum default sorted and set, it works without issue.... does here anyway.

DST start/end dates around the world do not align. I get to change it four times a year. This is boring.
Yeah I get that and used to get the same, that's why I mentioned linking of your PC clock to an online source AND having the correct timezone and country set on your PC too. (didn't mention that before.)

My clocks are accurate. That does not stop the apparent server time changing.
:o
Gotcha now.
Not seen that, it would piss me off too.
Is it really a SMF issue ? Or something else ?  :-//
Avid Rabid Hobbyist
Siglent Youtube channel: https://www.youtube.com/@SiglentVideo/videos
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #91 on: April 30, 2017, 05:39:31 am »
:o
Gotcha now.
Not seen that, it would piss me off too.
Is it really a SMF issue ? Or something else ?  :-//

Yeah, SMF is reporting the time in the server's timezone, it wouldn't be an issue if the client base was primarily in one area, as most forum user bases are. PHP provides two methods of dealing with the time, 'date' and 'gmdate', where date applies the server's timezone to the date, and gmdate is GMT. This is very common with open source projects like SMF, most programmers hate dealing with timezones due to how crappy they are, things like DST make it an absolute PITA to get it right.

Until you actually start to code time stuff, you don't (well at least I didn't) realize how involved it is, especially when you start to have to handle leap seconds, thankfully the kernel/os/PHP hides most of this from the dev, but it's can still be confusing. I find it is best to store times as UTC timestamps, then apply any offsets required when presenting the information, that way it never matters what the server or application's timezone is configured for.
« Last Edit: April 30, 2017, 05:45:27 am by gnif »
 
The following users thanked this post: tautech

Online Monkeh

  • Super Contributor
  • ***
  • Posts: 7992
  • Country: gb
Re: FORUM DISRUPTION: Server Upgrade
« Reply #92 on: April 30, 2017, 09:49:25 am »
Time quickly gets very complex.

If they're indeed simply using the 'wrong' function to print the time, at least switching to gmdate would restore DST changes to the usual twice a year. Still like to see timezone selection, though.

E: Seems to me the quickest solution is just to go into the admin panel and set the timezone to UTC where it belongs. Pretty sure that was shot down by Dave last time I raised it as he doesn't want to have to set his offset for DST..
« Last Edit: April 30, 2017, 10:10:47 am by Monkeh »
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1675
  • Country: au
Re: FORUM DISRUPTION: Server Upgrade
« Reply #93 on: April 30, 2017, 12:03:24 pm »
E: Seems to me the quickest solution is just to go into the admin panel and set the timezone to UTC where it belongs. Pretty sure that was shot down by Dave last time I raised it as he doesn't want to have to set his offset for DST..

The server's logging, monitoring and other services are all relying on dates that are stored in the local timezone, while it is a quick setting to change, it will affect much more across the server and is too late to change it. If it is done the server's time to a ton of things, including the stats and backup systems will appear to jump back in time 10 hours, which will mess things up in a large way.
 

Online Monkeh

  • Super Contributor
  • ***
  • Posts: 7992
  • Country: gb
Re: FORUM DISRUPTION: Server Upgrade
« Reply #94 on: April 30, 2017, 12:27:28 pm »
E: Seems to me the quickest solution is just to go into the admin panel and set the timezone to UTC where it belongs. Pretty sure that was shot down by Dave last time I raised it as he doesn't want to have to set his offset for DST..

The server's logging, monitoring and other services are all relying on dates that are stored in the local timezone, while it is a quick setting to change, it will affect much more across the server and is too late to change it. If it is done the server's time to a ton of things, including the stats and backup systems will appear to jump back in time 10 hours, which will mess things up in a large way.

Not on the server - on the forum. There is, according to the source at least (it's been a while since I ran SMF), a timezone setting on the forum. This may be something you can adjust without affecting much.
« Last Edit: April 30, 2017, 12:33:52 pm by Monkeh »
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37730
  • Country: au
    • EEVblog
Re: FORUM DISRUPTION: Server Upgrade
« Reply #95 on: April 30, 2017, 02:45:29 pm »
The SMF timezone is set to Sydney, always has been.
Any changes to any of this I'll leave up to gnif.
 
The following users thanked this post: SeanB


Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf