cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Help
Product Platform Updates
Stay informed about the latest updates and enhancements to the Databricks platform. Learn about new features, improvements, and best practices to optimize your data analytics workflow.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

IP CIDR For Azure Databricks Hive Metastore

joycexudata
Databricks Employee
Databricks Employee
Wednesday

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

  1. 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. 
  2. 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

 

 

1 Comment
Contributors
Popular Articles