High peak traffic website (100k simultaneous users)

yurilio

• March 30, 2021 10:25

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!

• 

  cPRex Jurassic Moderator

  • March 30, 2021 16:04

  Hey there! I don't have much to add on my end, but other users with high-traffic sites will likely get you their opinion soon!

  0
• 

  cPAdminsMichael

  • March 30, 2021 20:40

  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)

  0
• 

  yurilio

  • March 30, 2021 20:52

  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!

  0
• 

  cPAdminsMichael

  • March 31, 2021 13:12

  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.

  0
• 

  yurilio

  • March 31, 2021 23:47

  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

  0
• 

  cPAdminsMichael

  • April 01, 2021 14:26

  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) :)

  0

Please sign in to leave a comment.