Synopsis
Gets, sets, or resets configuration values for an Azure Database for MariaDB server.
Syntax
Get-AzMariaDbConfiguration
[-ResourceGroupName] <String>
-ServerName <String>
[[-Name <String[]>]]
[[-DefaultProfile <IAzureContextContainer>]]
[[-WhatIf]]
[[-Confirm]]
Set-AzMariaDbConfiguration
-ResourceGroupName <String>
-ServerName <String>
-Name <String>
-Value <String>
[[-DefaultProfile <IAzureContextContainer>]]
[[-WhatIf]]
[[-Confirm]]
Reset-AzMariaDbConfiguration
-ResourceGroupName <String>
-ServerName <String>
-Name <String>
[[-DefaultProfile <IAzureContextContainer>]]
[[-WhatIf]]
[[-Confirm]]Parameters
| Parameter | Type | Description |
|---|---|---|
| -ResourceGroupName | String | Name of the resource group containing the server. |
| -ServerName | String | Name of the MariaDB server. |
| -Name | String[] | Configuration name(s) to get, set or reset. |
| -Value | String | New value for the configuration (required for Set-AzMariaDbConfiguration). |
| -DefaultProfile | IAzureContextContainer | Azure context profile. |
| -WhatIf | SwitchParameter | Shows what would happen if the cmdlet runs. |
| -Confirm | SwitchParameter | Prompts for confirmation before executing. |
Examples
1. Get all configuration values for a server
Get-AzMariaDbConfiguration -ResourceGroupName "MyResourceGroup" -ServerName "mydbserver"2. Get specific configuration values
Get-AzMariaDbConfiguration -ResourceGroupName "MyResourceGroup" -ServerName "mydbserver" -Name "max_connections","innodb_buffer_pool_size"3. Set a configuration value
Set-AzMariaDbConfiguration -ResourceGroupName "MyResourceGroup" -ServerName "mydbserver" -Name "max_connections" -Value "250"4. Reset a configuration to its default
Reset-AzMariaDbConfiguration -ResourceGroupName "MyResourceGroup" -ServerName "mydbserver" -Name "max_connections"