mysqlwordpressnginxload-balancingvirtualmin

How to build a efficient Load Balance?

How to build a efficient Load Balance?

the reason is the very heavy database MYSQL...

a website with 30,000 articles.
I thought about separating the database, creating a file. But I don't know if it's possible with the same URL address.

My intention is to make a Load Balance that is easy to implement and performs well.

System:

Linux Ubuntu Server 20.04
virtualmin
Nginx
PHP 7.4
mysql
WordPress

I'm having trouble finding updated information about Load Balance. Although the questions clear some doubts, but they are out of date and many unanswered... Look: [link][1] [1]: https://stackoverflow.com/search?tab=relevance&q=%5Bload-balancing%5D%20Wordpress

Solution

  • I am not a WordPress expert, but with my basic knowledge about WordPress (I have my personal blog in WordPress), I can put an answer together that might enlighten you.

    There could be many reasons any website is slow, in your case WordPress website. 30000 articles as you mention in your question is not a big deal for a database with the mentioned resources.

    In your question, you come up with a solution to split databases, but I am pretty sure even if you split databases into multiple databases you will still have the same issue.

    I would rather start analyzing the website to find out why it is slow. There are many factors that can cause the slowness of a website. Otherwise, you will solve random issues that do not bring any value to your end goal.

    To analyze your website, there are some online tooling like:

    https://pagespeed.web.dev

    or

    https://tools.pingdom.com

    Both sites offer some suggestions on how to improve your performance.

    I would also parallel to that also read some articles about How to optimize your WordPress (one example).