- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Starting on mid of October, Azure Databricks will conduct Hive Metastore maintenance. This maintenance will change the IP addresses of the Hive Metastore. If you have hard-coded Hive Metastore IP addresses in your user-defined routes or firewalls, you must follow the instructions to avoid a service outage.
Instructions
- Please update your user-defined routes or appliances to use the “Azure SQL service tag” instead of the Hive Metastore IP addresses to avoid outages due to IP changes.
- If your security policy cannot allow Azure service tag, please add the reserved IP range for the Hive Metastore Flexible Server on your user-defined routes or firewalls. If your firewall supports FQDN filtering, you can also add FQDN.
If you’re using Azure service tags, your current running jobs will not be interrupted.
Azure Databricks Hive Metastore
Below you can find the Azure Databricks Metastore workspace regions and the Hive Metastore corresponding reserved IP range.
|
Azure Databricks Workspace Region |
Service |
FQDN |
Reserved IP Range |
Port |
Protocol |
|
Australia Central |
Metastore |
consolidated-australiacentral-prod-metastore.mysql.database.azure.com |
4.199.196.32/27 4.199.196.64/26 4.199.196.128/30 |
3306 |
TCP |
|
Australia Central 2 |
Metastore |
consolidated-australiacentral2-prod-metastore.mysql.database.azure.com |
20.167.180.200/30 20.167.181.0/26 20.167.181.64/27 |
3306 |
TCP |
|
Australia East |
Metastore |
consolidated-australiaeast-prod-metastore.mysql.database.azure.com consolidated-australiaeast-prod-metastore-addl-1.mysql.database.azure.com |
4.195.4.168/30 4.195.4.224/27 4.195.6.0/26 |
3306 |
TCP |
|
Australia Southeast |
Metastore |
consolidated-australiasoutheast-prod-metastore.mysql.database.azure.com |
48.215.165.32/27 48.215.165.128/26 48.215.165.192/30 |
3306 |
TCP |
|
Brazil South |
Metastore |
consolidated-brazilsouth-prod-metastore.mysql.database.azure.com |
4.201.209.132/30 4.201.209.160/27 4.201.209.192/26 |
3306 |
TCP |
|
Canada Central |
Metastore |
consolidated-canadacentral-prod-metastore.mysql.database.azure.com |
4.172.73.100/30 4.172.73.128/26 4.172.73.192/27 |
3306 |
TCP |
|
Canada East |
Metastore |
consolidated-canadaeast-prod-metastore.mysql.database.azure.com consolidated-canadaeastc2-prod-metastore-0.mysql.database.azure.com |
4.239.76.68/30 4.239.76.96/27 4.239.76.128/26 |
3306 |
TCP |
|
Central India |
Metastore |
consolidated-centralindia-prod-metastore.mysql.database.azure.com |
4.186.0.0/26 135.13.173.252/30 135.13.174.160/27 |
3306 |
TCP |
|
Central US |
Metastore |
consolidated-centralus-prod-metastore.mysql.database.azure.com consolidated-centralus-prod-metastore-addl-1.mysql.database.azure.com consolidated-centralus-prod-metastore-addl-2.mysql.database.azure.com consolidated-centralus-prod-metastore-addl-3.mysql.database.azure.com consolidated-centralusc2-prod-metastore-0.mysql.database.azure.com consolidated-centralusc2-prod-metastore-1.mysql.database.azure.com consolidated-centralusc2-prod-metastore-2.mysql.database.azure.com consolidated-centralusc2-prod-metastore-3.mysql.database.azure.com |
172.169.140.184/30 172.169.141.32/27 172.169.141.128/26 |
3306 |
TCP |
|
East Asia |
Metastore |
consolidated-eastasia-prod-metastore.mysql.database.azure.com consolidated-eastasiac2-prod-metastore-0.mysql.database.azure.com |
4.144.9.0/26 4.144.9.64/27 4.144.55.88/30 |
3306 |
TCP |
|
East US |
Metastore |
consolidated-eastus-prod-metastore.mysql.database.azure.com consolidated-eastus-prod-metastore-addl-1.mysql.database.azure.com consolidated-eastus-prod-metastore-addl-2.mysql.database.azure.com consolidated-eastus-prod-metastore-addl-3.mysql.database.azure.com consolidated-eastus-prod-metastore-addl-4.mysql.database.azure.com consolidated-eastusc2-prod-metastore-0.mysql.database.azure.com consolidated-eastusc3-prod-metastore-0.mysql.database.azure.com consolidated-eastusc3-prod-metastore-1.mysql.database.azure.com consolidated-eastusc3-prod-metastore-2.mysql.database.azure.com consolidated-eastusc3-prod-metastore-3.mysql.database.azure.com |
135.222.234.208/30 135.222.234.224/27 135.222.235.0/26 |
3306 |
TCP |
|
East US 2 |
Metastore |
consolidated-eastus2-prod-metastore.mysql.database.azure.com consolidated-eastus2-prod-metastore-addl-1.mysql.database.azure.com consolidated-eastus2-prod-metastore-addl-2.mysql.database.azure.com consolidated-eastus2-prod-metastore-addl-3.mysql.database.azure.com consolidated-eastus2c2-prod-metastore-0.mysql.database.azure.com consolidated-eastus2c2-prod-metastore-1.mysql.database.azure.com consolidated-eastus2c2-prod-metastore-2.mysql.database.azure.com consolidated-eastus2c2-prod-metastore-3.mysql.database.azure.com consolidated-eastus2c3-prod-metastore-0.mysql.database.azure.com consolidated-eastus2c3-prod-metastore-1.mysql.database.azure.com |
4.153.236.44/30 4.153.237.192/26 4.153.238.0/27 |
3306 |
TCP |
|
France Central |
Metastore |
consolidated-francecentral-prod-metastore.mysql.database.azure.com |
48.220.62.40/30 48.220.63.32/27 48.220.63.64/26 |
3306 |
TCP |
|
Germany West Central |
Metastore |
consolidated-germanywestcentral-prod-metastore-0.mysql.database.azure.com |
4.185.33.128/26 4.185.33.192/27 4.185.33.224/30 |
3306 |
TCP |
|
Japan East |
Metastore |
consolidated-japaneast-prod-metastore.mysql.database.azure.com |
4.189.200.100/30 4.189.202.0/26 4.189.202.64/27 |
3306 |
TCP |
|
Korea Central |
Metastore |
consolidated-koreacentral-prod-metastore.mysql.database.azure.com |
72.155.108.188/30 72.155.110.224/27 72.155.111.0/26 |
3306 |
TCP |
|
North Central US |
Metastore |
consolidated-northcentralus-prod-metastore.mysql.database.azure.com consolidated-northcentralusc2-prod-metastore-0.mysql.database.azure.com |
20.41.156.116/30 20.41.156.128/26 20.41.156.192/27 |
3306 |
TCP |
|
North Europe |
Metastore |
consolidated-northeurope-prod-metastore.mysql.database.azure.com consolidated-northeurope-prod-metastore-addl-1.mysql.database.azure.com consolidated-northeurope-prod-metastore-addl-2.mysql.database.azure.com consolidated-northeurope-prod-metastore-addl-3.mysql.database.azure.com consolidated-northeuropec2-prod-metastore-0.mysql.database.azure.com consolidated-northeuropec2-prod-metastore-1.mysql.database.azure.com consolidated-northeuropec2-prod-metastore-2.mysql.database.azure.com consolidated-northeuropec2-prod-metastore-3.mysql.database.azure.com |
4.207.59.172/30 4.207.61.224/27 4.207.62.0/26 |
3306 |
TCP |
|
Norway East |
Metastore |
consolidated-norwayeast-prod-metastore-0.mysql.database.azure.com |
131.163.107.216/30 131.163.108.160/27 131.163.108.192/26 |
3306 |
TCP |
|
South Africa North |
Metastore |
consolidated-southafricanorth-prod-metastore.mysql.database.azure.com |
172.209.228.192/26 172.209.230.128/27 172.209.230.160/30 |
3306 |
TCP |
|
South Central US |
Metastore |
consolidated-southcentralus-prod-metastore.mysql.database.azure.com consolidated-southcentralus-prod-metastore-addl-1.mysql.database.azure.com. consolidated-southcentralusc2-prod-metastore-addl-1.mysql.database.azure.com |
20.165.75.176/30 20.165.75.192/26 20.165.76.0/27 |
3306 |
TCP |
|
South India |
Metastore |
consolidated-southindia-prod-metastore.mysql.database.azure.com |
135.13.54.120/30 135.13.55.160/27 135.13.55.192/26 |
3306 |
TCP |
|
Southeast Asia |
Metastore |
consolidated-southeastasia-prod-metastore.mysql.database.azure.com consolidated-southeastasia-prod-metastore-addl-1.mysql.database.azure.com |
20.6.59.80/30 20.6.59.96/27 20.6.59.128/26 |
3306 |
TCP |
|
Sweden Central |
Metastore |
consolidated-swedencentral-prod-metastore-0.mysql.database.azure.com |
135.116.173.100/30 135.116.174.0/26 135.116.174.64/27 |
3306 |
TCP |
|
Switzerland North |
Metastore |
consolidated-switzerlandnorth-prod-metastore-0.mysql.database.azure.com |
74.161.187.72/30 74.161.189.32/27 74.161.189.64/26 |
3306 |
TCP |
|
Switzerland West (Requires Azure region access request) |
Metastore |
consolidated-switzerlandwest-prod-metastore-0.mysql.database.azure.com consolidated-switzerlandwest-prod-metastore-0.mysql.database.azure.com |
4.226.195.4/30 4.226.195.32/27 4.226.195.64/26 |
3306 |
TCP |
|
UAE North |
Metastore |
consolidated-uaenorth-prod-metastore.mysql.database.azure.com |
74.162.217.212/30 74.162.217.224/27 74.162.219.128/26 |
3306 |
TCP |
|
UK South |
Metastore |
consolidated-uksouth-prod-metastore.mysql.database.azure.com consolidated-uksouth-prod-metastore-addl-1.mysql.database.azure.com |
4.158.130.8/30 4.158.130.96/27 4.158.130.128/26 |
3306 |
TCP |
|
UK West |
Metastore |
consolidated-ukwest-prod-metastore.mysql.database.azure.com |
172.186.79.0/26 172.186.79.64/27 172.186.79.96/30 |
3306 |
TCP |
|
West Central US |
Metastore |
consolidated-westcentralus-prod-metastore-0.mysql.database.azure.com |
128.24.231.160/27 128.24.231.192/26 128.24.231.20/30 |
3306 |
TCP |
|
West Europe |
Metastore |
consolidated-westeurope-prod-metastore.mysql.database.azure.com consolidated-westeurope-prod-metastore-addl-1.mysql.database.azure.com consolidated-westeurope-prod-metastore-addl-2.mysql.database.azure.com consolidated-westeurope-prod-metastore-addl-3.mysql.database.azure.com consolidated-westeuropec2-prod-metastore-0.mysql.database.azure.com consolidated-westeuropec2-prod-metastore-1.mysql.database.azure.com consolidated-westeuropec2-prod-metastore-2.mysql.database.azure.com consolidated-westeuropec2-prod-metastore-3.mysql.database.azure.com |
172.199.16.212/30 172.199.16.224/27 172.199.17.0/26 |
3306 |
TCP |
|
West India |
Metastore |
consolidated-westindia-prod-metastore.mysql.database.azure.com |
57.159.154.72/30 57.159.155.0/26 57.159.155.64/27 |
3306 |
TCP |
|
West US |
Metastore |
consolidated-westus-prod-metastore.mysql.database.azure.com consolidated-westus-prod-metastore-addl-1.mysql.database.azure.com consolidated-westus-prod-metastore-addl-2.mysql.database.azure.com consolidated-westus-prod-metastore-addl-3.mysql.database.azure.com consolidated-westus2c2-prod-metastore-addl-1.mysql.database.azure.com |
52.190.155.28/30 52.190.155.160/27 52.190.155.192/26 |
3306 |
TCP |
|
West US 2 |
Metastore |
consolidated-westus2-prod-metastore.mysql.database.azure.com consolidated-westus2-prod-metastore-addl-1.mysql.database.azure.com consolidated-westus2-prod-metastore-addl-2.mysql.database.azure.com |
48.192.3.92/30 48.192.3.96/27 48.192.4.192/26 |
3306 |
TCP |
|
West US 3 |
Metastore |
consolidated-westus3-prod-metastore-0.mysql.database.azure.com |
51.57.104.24/30 51.57.104.192/26 51.57.105.0/27 |
3306 |
TCP |
|
China East 2 |
Metastore |
consolidated-chinaeast2-prod-metastore-0.mysql.database.chinacloudapi.cn |
163.228.201.128/25 |
3306 |
TCP |
|
China North 2 |
Metastore |
consolidated-chinanorth2-prod-metastore-0.mysql.database.chinacloudapi.cn |
143.64.206.128/25 |
3306 |
TCP |
Wrap-Up
Please make the changes before the maintenance to avoid any service outages. If you have any questions, please reach out to your Databricks account team or contact help@databricks.com
