High peak traffic website (100k simultaneous users)

yurilio

Registered
Mar 30, 2021
3
0
1
Usa
cPanel Access Level
Root Administrator
Hello,

I have a website based on PHP + MySql and we have peak traffic that can reach up 100.000 simultaneous users.

We have a high read + write to database.

It's a pooling website, that each users votes on the poll, the number of options voted is updated (write) an then the result is displayed to the user (read).

Our current dedicated server configuration bellow, but is getting stuck when traffic reaches 30k simultaneous users.
(this server is only for this website)
  • Intel Xeon Gold 6226R - Dual
  • 32 cores @ 2.9 GHz (3.9 Max Turbo)
  • 256 GB RAM
  • 2 x 480 GB SSD Primary Disk
  • 8 TB Bandwidth
php handler: fcgi
php-fpm: activated

Is there a suggestion on apache / mysql / php-fpm / or other configuration to handle this kind of traffic?

Thank you!
 
Last edited by a moderator:

cPAdminsMichael

Well-Known Member
Dec 19, 2016
161
56
103
Denmark
cPanel Access Level
Root Administrator
It's always difficult to guess/estimate server hardware.
With my experience, your server hardware sounds more than fine though. It's probably more a question about optimizing Apache/PHP/MySQL for these loads (and peaks if all 100k connects in same second)
 

yurilio

Registered
Mar 30, 2021
3
0
1
Usa
cPanel Access Level
Root Administrator
It's always difficult to guess/estimate server hardware.
With my experience, your server hardware sounds more than fine though. It's probably more a question about optimizing Apache/PHP/MySQL for these loads (and peaks if all 100k connects in same second)
Thanks for the reply.
You have suggestions for software configuration?
Thanks!
 

cPAdminsMichael

Well-Known Member
Dec 19, 2016
161
56
103
Denmark
cPanel Access Level
Root Administrator
Apache:
- Use Worker or Event MPM and increase poolsize to cope with the client count alternatively, you may want to look into Litespeed.
- Checkout NGINX caching server that comes in cPanel 96

MySQL:
- Use Mysql8 or MariaDB 10.3
- Use innodb and set poolsize maybe to keep whole database in memory

PHP:
- Use PHP-FPM. Remember to set the pool vales to match number of connections, etc.
- use fx Opcache
- Alternatively, you may want to look into Cloudlinux and their LSAPI

There are many parameters to tune - and many variables/unknowns... more than happy to work with you to optimize the server for your load.
 

yurilio

Registered
Mar 30, 2021
3
0
1
Usa
cPanel Access Level
Root Administrator
Apache:
- Use Worker or Event MPM and increase poolsize to cope with the client count alternatively, you may want to look into Litespeed.
- Checkout NGINX caching server that comes in cPanel 96

MySQL:
- Use Mysql8 or MariaDB 10.3
- Use innodb and set poolsize maybe to keep whole database in memory

PHP:
- Use PHP-FPM. Remember to set the pool vales to match number of connections, etc.
- use fx Opcache
- Alternatively, you may want to look into Cloudlinux and their LSAPI

There are many parameters to tune - and many variables/unknowns... more than happy to work with you to optimize the server for your load.
Great! Let's work together on this. How can we get in touch?

Thanks
 

cPAdminsMichael

Well-Known Member
Dec 19, 2016
161
56
103
Denmark
cPanel Access Level
Root Administrator
Great! Let's work together on this. How can we get in touch?

Thanks
Best would be on our website. Got your message yesterday but you left wrong mail address (nonexisting domain) :)