Add an IP address to the allowlist of a database instance in Azure

If you select public IP as the connection type when you create a data source with Azure as the cloud vendor, you need to add the data source IP address displayed in the OceanBase Cloud console to the allowlist of the MySQL database instance (including Azure MySQL and self-managed MySQL), self-managed Oracle database instance, self-managed OceanBase Database instance, PostgreSQL database instance (including Azure PostgreSQL and self-managed PostgreSQL), or self-managed TiDB database instance. This ensures that the data source can be accessed.

Obtain the IP address to be added to the allowlist

1. Log in to the OceanBase Cloud console.

2. Go to the Create Data Source page.

   1. In the left-side navigation pane, click Data Services > Data Sources.

   2. On the Data Sources page, click Create Data Source in the upper-right corner and select the required data source type.

3. In the Create Data Source dialog box, select Azure for Cloud Vendor and Public Connection for Connection Method, and select the required instance type based on your needs.

4. Copy the IP address displayed below the Connection Information field.

   Note

   The selected region must be the same as the region where the Azure instance is located.

Add an IP address to the allowlist of an Azure MySQL/PostgreSQL instance

1. Log in to the Azure Database for MySQL servers page.

2. Click the name of the target server to go to the Overview page.

3. In the left-side navigation pane, click Settings > Networking.

4. In the Firewall rules section, enter the IP address in the Start IP address and End IP address fields, and create a new firewall rule.

   

Add an IP address to the allowlist of a self-managed MySQL/Oracle/OceanBase/PostgreSQL/TiDB instance

1. Log in to the Azure virtual machines page.

2. Click the name of the target virtual machine to go to the Overview page.

3. In the left-side navigation pane, click Networking > Network settings.

4. In the Rules section, click Create port rule > Inbound port rule.

   

5. On the Add inbound security rule page, configure the following parameters. Other parameters can be left unchanged.

   Parameter	Description
   Source	Select IP Address.
   Source IP addresses/CIDR ranges	Enter the IP address copied from the Create Data Source page.
   Destination port ranges	Enter the port displayed on the Create Data Source page.
   Protocol	Select TCP.

6. Click Add.