Make the most of the MySQL Flexible Servers (Preview) with Azure CLI

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

Having the right tools can help improve your productivity as you build applications and try to get day-to-day tasks done efficiently. The CLI is the predominantly preferred by developers as a tool for performing everything from one-time tasks to creating automated scripts. To help developers work more efficiently and maximize their productivity, we’ve made many improvements to the Azure Database for MySQL Flexible Servers (Preview) CLI experience.

 

For example, the new experience includes:

  • Refined output to ensure that you’re informed about what's going on behind the scenes.
  • A single command for creating a secure server inside a virtual network.
  • The ability to use contextual information between CLI commands to help reduce the number of keystrokes for each command.

See all Azure Database for MySQL Flexible Server CLI commands to get started.

 

Local context support

 

Flexible Server CLI commands support local context with the az config param-persist command, which locally stores information such as region, resource group, subscription ID, resource name, etc., for every sequential CLI command you run. You can easily turn on local context to store information by using the az config param-persist on command. If local context is turned on, you can see the contextual information by using the az config param-persist show command. You can always turn off local context by using the az config param-persist off command.

 

mk_sunitha_0-1604700695428.png

Figure 1: Run az config param-persist show to view what information is stored.

 

Ease of provisioning and deprovisioning

 

When creating a MySQL server using our managed database service on Azure, you’ll probably want to get started quickly, especially if you're just trying things out. With the new and improved Azure CLI for Flexible Server on Azure Database for MySQL, you can quickly create a MySQL server inside a virtual network. If you prefer, you can also easily provision a server with firewall rules in a single step. You can also view the progress visually as CLI commands to keep informed about what's going on behind the scenes.

 

Create a MySQL Flexible Server inside a new virtual network

 

Rather than using separate commands to create a resource group, a virtual network, and a subnet, you can use the az mysql flexible-server create command as shown below to create a secure MySQL Flexible Server inside a new virtual network and have a new subnet delegated to the server.

 

mk_sunitha_1-1604700695512.png

Figure 2: Run az mysql flexible-server create to provision a secure server in a virtual network

 

Create a MySQL Flexible Server with public access to all IPs

 

Use the az postgres flexible-server create –public-access all command to create a publicly accessible MySQL server. A publicly accessible server can be accessed from any client computer using the correct username and password.

To restrict access only to your IP set, use the --public -access argument to scope it either your <IP – address> or a range of IP addresses, <Start IP address - End IP address>.

 

mk_sunitha_2-1604700695639.png

Figure 3: Run az postgres flexible-server create --public-access all to provision a publicly accessible server.

 

Delete the server when using local context

 

Use the az mysql flexible-server delete command to delete any MySQL Flexible Server identified in the local context. In the example below, the command identifies server210976926 in the local context and then tries to delete that server.

 

mk_sunitha_3-1604700695680.png

Figure 4: Run az mysql flexible-server delete to delete a publicly accessible server.

 

Boost your productivity

 

Tuning MySQL database parameters is important when configuring your server to meet your application’s needs, or even to optimize performance. You can use the parameter set command to easily update server parameters with ease . You can view all the server parameter with parameter list and parameter show commands to view the values of a specific server parameter.

 

mk_sunitha_4-1604700695743.png

Figure 5: Run az mysql flexible-server parameter set to configure audit logs.

 

Do more with flexible servers with Azure CLI utilities 

 

Here are few more powerful things that you can do when using the Azure CLI with MySQL Flexible Server:

  • Use the az find command to find a specific command.
  • Use the --help argument to get a complete list of commands and subgroups of a group.
  • Change the output formatting to table or tsv or yaml formats.
  • Use az interactive mode, which provides an interactive shell with auto-completion, command descriptions, and examples.
  • Use the az upgrade command to update your CLI and extensions.
  • Use the az rest command to call your service endpoints to run GET , PUT , PATCH methods in a secure way

 

These changes have been designed to support the best possible experience for developers when creating and managing their MySQL servers. We’d love for you to try out Azure Database for MySQL Flexible Server CLI commands and share any feedback you might have on the new or existing CLI commands.

 

 

 

 

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.