Wishing all of our readers, members and friends a very merry and safe Christmas!
December 22nd 2021
Shahzaib has a WordPress website on a dedicated server. Under traffic the load on MySQL jumps to end up consuming 30 CPUs. For caching he's using WordPress supercache plugin and PHP opcache with nginx+php-fpm. He asks if there's a way to reduce the Mysql CPU load? After some early advice in the thread he found that after creating indexes on wp_postmeta the load was drastically reduced. That was a few weeks ago but yesterday he was back to report that there has been a sudden surge on MySQL load and there are abnormal long queries running. For those that have experience of tuning WordPress sites that produce a heavy MySQL load, what advice can you offer in this thread that could help?
A member's project has been running the traditional LAMP stack for their website (PHP+MySQL, similar to WordPress), for the past 10+ years. But as they are about to tackle some upgrade projects a question came up - Should they go to cloud? And, if they do, what should they do there? Is the obvious answer to just to get a VM in the cloud and put LAMP on it again? Something like Amazon Lightsail? Or can they do more? Should they even be doing that anymore? Does it make more sense to do it as a collection of cloud services, hosting their files in storage and use the distributed MySQL database in the cloud? They realize in this scenario they lose a lot of flexibility and control, but is this design the way of the future? Also, keeping costs low and steady is very important to them. What are your experiences on moving away from LAMP?
Fully Managed Dedicated from $99/mo
Upgrade to Fully Managed Hosting with special savings on select configurations, as low as $99/mo.
Last week we warned of the HApache Log4j utility zero-day exploit made public on December 9, 2021. Unfortunately there have been further updates since, with a second vulnerability, and then a third, being discovered, with the latest 2.17.0 version of Log4J being released. It is also now being reported that the Conti ransomware operation is using the critical Log4Shell exploit to gain rapid access to internal VMware vCenter Server instances and encrypt virtual machines.
More from around our Industry:
Got some news of your own to share? If it's news from your own company it belongs in Web Hosting Industry Announcements (no ads please!). If you've scooped some news about something else going on in the hosting industry we'd love for you to share it in our Industry News section!
Have you ever wondered how to increase your presence and exposure on WebHostingTalk? Premium and Corporate memberships offer you opportunities to stand out in posts and advertisements, post offers more frequently, enjoy a larger PM (private message) box capacity, participate in the "VIP" area at the top of the forum and, for corporate members, receive keyword alerts which you can customize to your own needs. Find out more by visiting our memberships page.
WebHostingTalk, Inc. 2 Toronto St., Ste. #239, Toronto, ON, M5C 2B5 Canada
Phone:+1 416 277 0095
This mailing list is announce-only.
Delivered weekly, the Web Hosting Talk Insider newsletter covers the latest news in the cloud and hosting industry, the hottest Web Hosting Talk threads, and in-depth insight and commentary on the trends impacting your business.