none
change server parameters on mysql azure PaaS RRS feed

  • Question

  • Hello i read

    https://docs.microsoft.com/azure/mysql/howto-server-parameters

    i can't find any related to if changing a service parameter needs an instance's restart as for as when you scale the instance out.

    thanks


    • Edited by baleng Monday, June 24, 2019 10:31 AM
    Monday, June 24, 2019 9:30 AM

All replies

  • Hi,

    Thanks for the feedback.

    Most of the Server System Variables can be changed dynamically at runtime using the SET statement, which enables you to modify operation of the server without having to stop and restart it. You can also use system variable values in expressions.

    List of Dynamic System Variables

    Refer Server System Variables for more information. Hope this helps.

    Monday, June 24, 2019 10:45 AM
    Moderator
  • Hello i'am referring to the Azure PaaS mysql server parameter's page .

    for example: on prem if i change the parameter "wait timeout" i need to restart the instance after editing the my.cnf

    the question i want to be answered is: if i modify the paramenter from the portal page the instance is being restarted when i push the save button?


    Monday, June 24, 2019 11:00 AM
  • If the server parameter is "static", the server needs to be restarted in order for this to take affect. You can use the "restart" button on the server's overview blade to do this: https://docs.microsoft.com/en-us/azure/mysql/howto-restart-server-portal

    If the server parameter is "dynamic", the changes will be updated on the server without requiring a server restart, but you may still need to disconnect from your current session to see these changes. 

    Thanks,

    Andrea Lam

    Program Manager, Azure DB for MySQL


    Tuesday, August 13, 2019 5:54 PM