Largest WP News site become slow day by day

  • mehrabhosain

    (@mehrabhosain)


    1 year, 10 months ago

    I am running a news portal using WP, My DB size is quite large, at almost 6GB+, and my web size is more than 100GB+. The number of posts is more than a million.
    Day by day, my back is going very slowly. It takes a long time to add new post, edit, save, publish, or update. I am using a high configuration web server Two, one For DB one for FIle, (E52650V4, 128GB Ram each) . anothe more one for Development purpose,
    Frontend/Public sites makes faster using Cloudflare CDN.

    I am thinking move to another platform like Javascript base network.

    But I really Love WordPress. Is there any good solutions? Day by Day my web/DB sizes are increasing.

    What would be possible solutions? Like I have article since 2014, Is there any way split out databse for 2014-20 for archive, when someone click old(2014-2020) link it will auto redirect to archive server automatic?

    • This topic was modified 1 year, 10 months ago by mehrabhosain. Reason: Grammer correction
    • This topic was modified 1 year, 10 months ago by Jan Dembowski.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Moderator Yui

    (@fierevere)

    永子

    1 year, 10 months ago

    A couple of hints by Clorith:

    Split the database up to have one read and one write DB, also get object caching going (they don’t mention this at all, but that’s a maassive performance bosot to the logged in sections of a site).
    17:33
    They also don’t mention how their Cf setup is working oput, what kind of cache hits/misses are they experiencing,. should that be optimized as well?
    17:34
    https://wordpress.org/plugins/hyperdb/ will let them split the DB into a rread and write shard for example, that way you’re separating the tasks and the read-only one can do more in-memory caches if they’d like and fun things like that

    You can also use MaxScale as proxy to optimize multiple servers database throughput

    Redis for object/transients cache
    And static page caching works very well for news sites too

Viewing 1 replies (of 1 total)
  • The topic ‘Largest WP News site become slow day by day’ is closed to new replies.