This topic describes how to connect an on-premises database or a database that is
hosted on a third-party cloud to Alibaba Cloud by using Database Gateway. When you
configure data migration, data synchronization, or change tracking, you can specify
the connected database as the source or destination database.
Prerequisites
An AccessKey pair is created. The AccessKey pair consists of an AccessKey ID and AccessKey
secret. For more information, see
Create an AccessKey pair.
Background information
You can connect an on-premises database or a database that is hosted on a third-party
cloud to Alibaba Cloud by using one of the following methods:
- Connect over Express Connect, VPN Gateway, or Smart Access Gateway: This method is
not suitable for individual users because it requires high costs.
- Connect to the service port of the database over the Internet: This method incurs
potential security risks.
- Forward service requests by using a user-created proxy: This method requires high
costs and does not ensure high stability.
However, the preceding methods have disadvantages. You can connect an on-premises
database or a database that is hosted on a third-party cloud to Alibaba Cloud by using
Database Gateway at a lower cost. For more information about the design concept of
Database Gateway, see How it works.
Billing
Database Gateway is in public preview and incurs no fees.
Procedure
- Log on to the Database Gateway console.
Note If you are using Database Gateway for the first time, the Enable Service page appears. On this page, read and agree to the Database Gateway Service Agreement,
and then click Enable Now.
- Click Create Gateway.
- In the Create Gateway dialog box, enter the name and description of the database gateway,
and then click Next step.
- Download the gateway program.
Notice The server that is used to deploy the gateway program must meet the following requirements:
- Performance: At least one CPU core and 1 GB memory are available. You can use higher-performance
devices.
- Software environment: JRE 1.7 or later is installed. We recommend that you use a 64-bit
operating system.
- Network:
- The server can connect to the database. If the server and the database are deployed
in the same internal network, the network latency is minimal.
- The server can access the Internet. The service port of the server does not need to
be accessible over the Internet. To ensure the transmission rate and stability, the
outbound bandwidth must be at least 10 Mbit/s.
- In the Create Gateway dialog box, download the gateway program for the target operating
system based on the runtime environment.
- Copy the downloaded installation file to the server where you want to deploy the gateway
program, and decompress the file.
- Start the gateway program.
- Log on to the server where the gateway program is deployed, and go to the directory
where the gateway program is decompressed.
- Select one of the following methods to start the gateway program based on your operating
system:
- For Linux or Mac, run the
bin/start.bat
command.
- For Windows, double-click the db_agent.bat file in the bin directory.
- Enter the AccessKey ID and AccessKey secret.
- After the verification is successful, return to the Database Gateway console and click
Next step to obtain a random verification code.
- Enter the verification code in the CLI of the gateway program and press the Enter
key. Wait until the connection is established.
- Add a database.
Note You can repeat this step to add multiple databases.
- Return to the Database Gateway console and click Add database.
- In the dialog box that appears, specify the database address, service port number,
and description, and then click OK.
What to do next
When you configure data migration, data synchronization, or change tracking, select
Database without public IP:Port (Accessed through database gateway) as the instance type. Select the database address from the drop-down list. You can
select the database that is connected over Database Gateway as the source database
or destination database.
Note If you select Database without public IP:Port (Accessed through database gateway) as the instance type when you configure data migration, the source and destination
instances must reside in the same region.