Bu sayfa henüz yerel dilinizde mevcut değildir. Daha fazla dil seçeneği eklemek için yoğun bir şekilde çalışıyoruz. Desteğiniz için teşekkür ederiz.

Compute
Elastic Cloud Server
Huawei Cloud Flexus
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Cloud Phone Host
Huawei Cloud EulerOS
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
VPC Endpoint
Cloud Connect
Enterprise Router
Enterprise Switch
Global Accelerator
Management & Governance
Cloud Eye
Identity and Access Management
Cloud Trace Service
Resource Formation Service
Tag Management Service
Log Tank Service
Config
OneAccess
Resource Access Manager
Simple Message Notification
Application Performance Management
Application Operations Management
Organizations
Optimization Advisor
IAM Identity Center
Cloud Operations Center
Resource Governance Center
Migration
Server Migration Service
Object Storage Migration Service
Cloud Data Migration
Migration Center
Cloud Ecosystem
KooGallery
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP Filing
Support Plans
My Credentials
Customer Operation Capabilities
Partner Support Plans
Professional Services
Analytics
MapReduce Service
Data Lake Insight
CloudTable Service
Cloud Search Service
Data Lake Visualization
Data Ingestion Service
GaussDB(DWS)
DataArts Studio
Data Lake Factory
DataArts Lake Formation
IoT
IoT Device Access
Others
Product Pricing Details
System Permissions
Console Quick Start
Common FAQs
Instructions for Associating with a HUAWEI CLOUD Partner
Message Center
Security & Compliance
Security Technologies and Applications
Web Application Firewall
Host Security Service
Cloud Firewall
SecMaster
Anti-DDoS Service
Data Encryption Workshop
Database Security Service
Cloud Bastion Host
Data Security Center
Cloud Certificate Manager
Edge Security
Situation Awareness
Managed Threat Detection
Blockchain
Blockchain Service
Web3 Node Engine Service
Media Services
Media Processing Center
Video On Demand
Live
SparkRTC
MetaStudio
Storage
Object Storage Service
Elastic Volume Service
Cloud Backup and Recovery
Storage Disaster Recovery Service
Scalable File Service Turbo
Scalable File Service
Volume Backup Service
Cloud Server Backup Service
Data Express Service
Dedicated Distributed Storage Service
Containers
Cloud Container Engine
Software Repository for Container
Application Service Mesh
Ubiquitous Cloud Native Service
Cloud Container Instance
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GeminiDB
GaussDB
Distributed Database Middleware
Database and Application Migration UGO
TaurusDB
Middleware
Distributed Cache Service
API Gateway
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
Multi-Site High Availability Service
EventGrid
Dedicated Cloud
Dedicated Computing Cluster
Business Applications
Workspace
ROMA Connect
Message & SMS
Domain Name Service
Edge Data Center Management
Meeting
AI
Face Recognition Service
Graph Engine Service
Content Moderation
Image Recognition
Optical Character Recognition
ModelArts
ImageSearch
Conversational Bot Service
Speech Interaction Service
Huawei HiLens
Video Intelligent Analysis Service
Developer Tools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Content Delivery & Edge Computing
Content Delivery Network
Intelligent EdgeFabric
CloudPond
Intelligent EdgeCloud
Solutions
SAP Cloud
High Performance Computing
Developer Services
ServiceStage
CodeArts
CodeArts PerfTest
CodeArts Req
CodeArts Pipeline
CodeArts Build
CodeArts Deploy
CodeArts Artifact
CodeArts TestPlan
CodeArts Check
CodeArts Repo
Cloud Application Engine
MacroVerse aPaaS
KooMessage
KooPhone
KooDrive

Creating a Publication

Updated on 2024-10-14 GMT+08:00

What Is Publication and Subscription?

RDS for SQL Server provides publications and subscriptions. This function uses the replication technology to split data reads and writes as well as synchronize data between cloud databases and between cloud databases and on-premises databases.

Scenarios

To synchronize data from your instance to another one, you can use your instance as the publisher instance, configure a distributor for it, create a publication, and then add a subscriber for the created publication.

Figure 1 Topology

Constraints

  • RDS for SQL Server does not support cross-region publications or subscriptions.
  • Only one distributor can be configured for an instance. All publications of the instance use this distributor. Deleting a distributor will also delete the publications using this distributor.
  • RDS for SQL Server Web Edition instances cannot be used as distributors or publisher instances, but can be used as subscribers.
  • When you create a publication, the database name and publication name must be different from those of existing publications.
  • RDS for SQL Server supports only transactional publications.
  • If you add a subscription server other than RDS, the account used for logging to the server must have the sysadmin permission.
  • If you add an RDS subscription server, you can select a maximum of 10 destination databases at a time.
  • The floating IP address and port number of an instance with a publication or subscription created cannot be changed.
  • Chinese characters are not allowed in table names or field names on the publisher or subscriber.
  • If the primary node of the distributor fails, the publication and subscription link cannot be restored through primary/standby switchover.

Configuring a Distributor

  1. Log in to the management console.
  2. Click in the upper left corner and select a region.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the DB instance name.
  5. In the navigation pane, choose Publications & Subscriptions.
  6. On the Publications page, click Configure Distributor.
  7. In the displayed dialog box, select the current instance or another instance as the distributor, select I have read and understood this information, and click OK.

    Figure 2 Configuring a distributor

  8. View the configured distributor.

    Figure 3 Viewing a distributor

Creating a Publication

  1. On the Instances page, click the DB instance name.
  2. In the navigation pane, choose Publications & Subscriptions.
  3. On the Publications page, click Create Publication.
  4. On the displayed page, configure parameters and click OK.

    • Enter a publication name, select a publication database, and specify publication objects.
    • To set a filter for publishing tables/fields, click Set Filter.
    • To set project properties for publishing tables/fields, click Set Project Properties.
    • If you select Create Now for Full Snapshot, a full snapshot is triggered on the distributor immediately after the publication is created. If Create Now is not selected, a full snapshot is created when a new subscription is added. Data cannot be synchronized to the subscriber until the snapshot agent is initialized.
    • You can customize an incremental snapshot schedule by day, week, or month to generate incremental snapshots on the distributor.
    Figure 4 Creating a publication
    Figure 5 Setting project attributes

  5. View the created publication.

    Figure 6 Viewing a publication
    • To add a subscription for the publication, follow the instructions in Adding a Subscriber.
    • To view Latency for Data Changes and Transactions, click Monitor.
    • To modify tables or fields to be published and the incremental snapshot schedule, choose More > Modify Publication.
    • To delete the publication, choose More > Delete.

Adding a Subscriber

  1. On the Instances page, click the DB instance name.
  2. In the navigation pane, choose Publications & Subscriptions.
  3. On the Publications page, locate the created publication and click Add Subscription in the Operation column.
  4. Click Add Subscriber.
  5. On the displayed page, configure parameters and click OK.

    For details about the publisher and subscriber types supported by RDS for SQL Server, see Compatibility Between Publishers and Subscribers.

    If you select RDS for Server:

    • Select one or more RDS for SQL Server subscriber instances and destination databases, and click to synchronize the selected databases to the right box.

      Ensure that the publisher instance and subscriber instance can communicate with each other in the same VPC or through a peering connection between VPCs. If they are in different security groups, configure security group rules to allow access.

    • Select Push subscription for Subscription Type.
    • Select a synchronization schedule for data subscription. You can customize a schedule by day, week, or month.
    Figure 7 Adding an RDS subscriber

    If you select Others for Server:

    • Enter the subscriber name, subscriber IP address, port number, login username, and password, and specify destination databases.
    • Select Push subscription for Subscription Type.
    • Select a synchronization schedule for data subscription. You can customize a schedule by day, week, or month.
    Figure 8 Adding other subscribers

  6. Locate the created publication, click the number in the Subscribed Databases column to view the subscription details.

    Figure 9 Subscription details

Sitemizi ve deneyiminizi iyileştirmek için çerezleri kullanırız. Sitemizde tarama yapmaya devam ederek çerez politikamızı kabul etmiş olursunuz. Daha fazla bilgi edinin

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback