Layer7 API Management

  • Private Community
 View Only

Back to discussions
Expand all | Collapse all

"Upgrade the Layer7 API Gateway database" after patching the virtual appliance gateway from 11.1 to 11.1.2

  • 1.  "Upgrade the Layer7 API Gateway database" after patching the virtual appliance gateway from 11.1 to 11.1.2

    Posted May 01, 2025 08:40 AM

    Hi There,

    I have a freshly installed version 11.1 virtual appliance gateway cluster with two nodes. 

    I have set up the master/master replication between the two nodes for the internal MySQL database.

    I have also set up failover with one node being Primary and another node being Secondary.

    I patched the system up to 11.1.2 and after that the "Node Status" is showing "WONT_START" due to the mismatch of the database version and the gateway software version:

            Database upgrade is required.

             Software version : 11.1.2
             Database version : 11.1.00

    So, my question is how I upgrade the database version? 

    If I upgrade with the gateway main menu "2) Display Layer7 API Gateway configuration menu / 1) Upgrade the Layer7 API Gateway database", which one of the following two should I use?

    1) Upgrade the database on the Primary node and let replication propagate the change to the Secondary node.

    2) Stop the replication on both nodes, upgrade the database on both nodes and then start replication again.

    I guess the answer depends on what exactly the upgrade database process does on the node where you run it. If it is purely database, then we might be able to rely on replication to propagate the changes to the other node. If there is anything else, then we might need to run upgrade database on both nodes.

    Thank you and regards,

    Jiangping Li



  • 2.  RE: "Upgrade the Layer7 API Gateway database" after patching the virtual appliance gateway from 11.1 to 11.1.2

    Broadcom Employee
    Posted May 01, 2025 09:19 AM

    Hello Jiangping,

    Per steps 8. Stop Database Replication and 9. Upgrade the Gateway Database, you should stop replication and just upgrade the primary node before restarting replication. You can either upgrade the database through the menu or using the indicated script.

    Regards,



    ------------------------------
    Ben Urbanski
    Product Manager, API Gateway
    Layer7 API Management
    ------------------------------

    Original Message


  • 3.  RE: "Upgrade the Layer7 API Gateway database" after patching the virtual appliance gateway from 11.1 to 11.1.2

    Posted May 01, 2025 08:19 PM

    Thanks Ben for your reply.

    I guess I can find out what exactly database upgrade does from the scripts.

    Regards,

    Jiangping Li


    Original Message