Forum/website issue

[JanRoza]

Compliments Marc!
It must have cost you a big amount of time ans sweat to solve this.
Well done!

[af0815]

+1
to the server admins for her work

[Thaddy]

Indeed. Well done Marc!

[Marc]

Time for a wrap-up, what happened:

There were happening 2 things simultaneously, an increased interest(?) from china and one or two bots looking for SQL injections every second.
This caused a load on the original server configuration, apache using mod_php.
Since the amount of traffic was larger than normal, but still realistic, I decided to use fast-cgi to remove the php overhead from the apache process. The same time I could now use the mpm_event module which can handle way more connections to the server.
After some days of config tweaking everything should be fine..... not.
The server started to work OK until, according to netstat, about 800 sockets were in use after which the server failed to respond. This continued till the amount of sockets dropped to about 50 (due to timeouts etc). Then the server was responsive again and the whole cycle started again. After a lot of googling it appeared that this was caused by this issue in apache https://bz.apache.org/bugzilla/show_bug.cgi?id=53555
Since we're still running 16.04 LTS, our apache was one minor release to old. So I manually upgraded apache to the latest version and the problem was gone
 

[nummer8]

Great job Marc,

Thanks for the feedback.
It helps to get an understanding in what is done the last couple of days.

Jos

[Zath]

Good work.
That said, it took me about 20s to connect to the forum from another site.
Might be my end …..

[440bx]

@Marc,

Thank you for all the hard work.  Obviously, we all appreciate your efforts.

[winni]

@Marc

Congratulations with UTF8!

🧰🧩🌞🍀🍄🍓🍭🍯🍰🍵🎓🎖🏁🏺🐧💎💝💥💰📡📸🔉🔭

Winni

[ASBzone]

Time for a wrap-up, what happened:

...
After some days of config tweaking everything should be fine..... not.
...
Since we're still running 16.04 LTS, our apache was one minor release to old. So I manually upgraded apache to the latest version and the problem was gone

Admit it Marc, tech support and administration is fun.   

Thanks for staying on top of this.

[Thaddy]

@Marc

Congratulations with UTF8!

🧰🧩🌞🍀🍄🍓🍭🍯🍰🍵🎓🎖🏁🏺🐧💎💝💥💰📡📸🔉🔭

Winni

You can do that with any font not fully complete: not an utf8 issue.

[VTwin]

Thanks Marc, much appreciated.