Database Gateway (DG) lets you connect an on-premises or third-party cloud database to Alibaba Cloud without a dedicated network product. It is designed for quickly verifying Data Transmission Service (DTS) functionality during the proof of concept (POC) phase.
DG is for the POC phase only and is not a production-grade network product. It does not support cross-region data migration when used as the access method for a data migration task. After the POC phase, delete the DTS task, set up a dedicated network connection, and reconfigure the task.
DG is a feature of Data Management (DMS). For an overview, see What is Database Gateway?.
Prerequisites
Before you begin, ensure that you have:
Access to the machine where you plan to install the DG gateway
Network connectivity from that machine to your database
Outbound network access from the gateway machine to Alibaba Cloud
Deployment planning
Deploy the DG gateway on a machine that is physically close to the database. This minimizes latency between the database and the gateway, and between the gateway and DTS.
If your database is in Germany and DTS runs in Singapore, deploy the DG gateway in Germany and point it to the DG service endpoint in Germany—not Singapore. A cross-border gateway connection increases latency and degrades the quality of the DTS link.
Set up the gateway
Step 1: Create a gateway
Log on to the Database Gateway console.
NoteIf this is your first time using Database Gateway, you are redirected to the Cloud Service Activation page. Read and accept the terms of service, then click Activate Now.
Click Create Gateway. In the dialog box that appears, enter a gateway name and description, then click Next step.
Step 2: Install the gateway
Select the installation package for your operating system and install it:
Operating system Installation method Windows Click Download gateway and follow the on-screen prompts. Other operating systems Copy the installation command and run it on the target machine. Wait for the local gateway to start.
NoteStartup time varies based on your service, network, and operating system.
Go to the add database page. The console redirects you automatically when the gateway starts, or click Next step to continue manually.
Step 3: Add your database
Click Add database address to register your database with the gateway. For detailed instructions, see Create a database gateway.
Step 4: Finish setup
Click Complete. After setup, you can modify or delete the database registration at any time.
Configure a DTS task to use the gateway
When creating a data migration, data synchronization, change tracking, or data validation task in DTS, set Access Method to Database Gateway. Then select your database from the Database Endpoint drop-down list to use it as the source or destination database.
Transition to production
After the POC phase, replace DG with a production-grade network solution:
Delete the DTS task.
Set up a dedicated network connection using one of the following options:
Network product Use case VPN Gateway Connect an on-premises or third-party cloud network (such as AWS) to Alibaba Cloud over the internet Express Connect High-bandwidth, low-latency private connection between on-premises infrastructure and Alibaba Cloud Smart Access Gateway Branch office or remote site connectivity Reconfigure the DTS task and set the connection type to Express Connect, VPN Gateway, or Smart Access Gateway.
For an example of connecting a database on AWS to Alibaba Cloud, see Connect a database on AWS to Alibaba Cloud.