Please fix how you upgrade the database

  • Resolved spuds10

    (@spuds10)


    1 year, 5 months ago

    Currently whenever there is a database upgrade, Broken Link Checker will try to upgrade the database in the init hook. This is a major problem because that means if you have a high trafficked multisite instance, thousands of requests are triggering that database hook script for multiple sites at the same time.

    We’re a high traffic university system with over 800+ sites in our multisite install, so for us this always leads to a db lockout error.

    Every time there is a BLC update, I have to comment out the upgrade script, push it up to our production environment, then write a command line script that manually runs that upgrade code in a foreach loop over each site. It’s not very ideal.

    Can your dev team please create a upgrade method that’s safe for large multisite installs? Maybe there can be some network level queue table? On init, if that blog id is not top of the queue, add it to the queue. If it is on top of the queue, run the upgrade script. That’s a half baked idea, but I think anything that makes those updates sequential across a multisite install would be a huge improvement.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Zafer – WPMU DEV Support

    (@wpmudevsupport15)

    Hi @spuds10,

    I hope you are doing well today!

    Thank you for your detailed explanation about the challenge you’re currently experiencing with the Broken Link Checker. Your feedback is extremely valuable to us and helps drive improvements to our products.

    We were sorry to hear about the issues you’ve faced with the database upgrade process in high traffic instances. We know how crucial a smooth and efficient update process is, especially in a high-scale environment like yours.

    I have forwarded your message to BLC team and they will assess the feasibility of integrating this new upgrade method into the Broken Link Checker. We aim to make future updates smoother and more efficient to prevent any potential lockouts.

    Please feel free to reach out if you have any other concerns or suggestions. We greatly appreciate your patience and understanding.

    Thank you for bringing this to our attention.

    Kind regards,
    Zafer

    Plugin Support Zafer – WPMU DEV Support

    (@wpmudevsupport15)

    Hi again @spuds10,

    Please provide us the following additional information in order to check the issue further.

    • Which part of the upgrade script have you commented out?
    • Please share details of the command line script that is being run

    Kind regards,
    Zafer

    Plugin Support Nebu John – WPMU DEV Support

    (@wpmudevsupport14)

    Hi @spuds10,

    As there have been no recent updates from your end, I will proceed to close this thread as resolved. Feel free to contact us if you have any more questions or need further assistance in the future!

    Kind Regards,
    Nebu John

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Please fix how you upgrade the database’ is closed to new replies.