current position：Home>What are the restrictions on the source database of DTS self built MySQL synchronized to RDS MySQL?
What are the restrictions on the source database of DTS self built MySQL synchronized to RDS MySQL?
2022-02-04 16:46:27 【Alibaba cloud Q & A】
dts build by oneself MySQL Sync to RDS MySQL What are the source library restrictions for ？
Take the answer 1：
The table to be synchronized must have a primary key or unique constraint , And the field is unique , Otherwise, duplicate data may appear in the target database . For example, the synchronization object is table level , And need to edit （ Such as table column name mapping ）, Then a single synchronization task only supports synchronization 1000 A watch . When the quantity limit is exceeded , The request error will be displayed after the task is submitted , At this time, it is recommended that you split the table to be synchronized , Configure multiple tasks in batches , Or configure the synchronization task of the whole library . Binlog journal ： To be opened Binlog, For the opening method, see setting instance parameters , also binlog_format by row、binlog_row_image by full. Otherwise, an error will be prompted in the pre inspection stage , And the data synchronization task cannot be started successfully . Be careful If the source instance is self built MySQL Dual master cluster （ The two are master and slave to each other ）, To protect DTS Can get all Binlog journal , Then you need to turn on the parameter log_slave_updates. If it is an incremental synchronization task ,DTS The local address of the source database is required Binlog Log saving 24 hours , For example, full synchronization and incremental synchronization tasks ,DTS The local address of the source database is required Binlog Keep the log at least 7 Days or more （ After the full synchronization is completed, you can Binlog Save time is set to 24 hours ）, otherwise DTS May be due to inability to obtain Binlog And cause the task to fail , In extreme cases, it may even lead to data inconsistency or loss . Because of the Binlog Log save time is less than DTS The required time leads to problems , be not in DTS Of SLA Within the scope of protection .
author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.
The sidebar is recommended
- Summary of common knowledge points of Android interview in 2020, HashMap traversal
- 2020android will never die. As a programmer, what do you think is the biggest sorrow
- Linux system programming 43 file descriptor
- C + + date judgment blank filling is required to complete the blank filling
- About the parameter problem in Ajax, geigei help
- The number of daffodils in C language is wrong,
- UE4 carving terrain painting display problem
- Single chip C51 assembly language scatter program error
- Hello, let me ask Prometheus how to write port rules
- How can Linux ssh server solve the following problems
guess what you like
How about the Java debug mode? This is what I finally appeared.
Linux operating system, online solution
Calculate the value of the formula and display it on the screen
What is the use of inter address access pointer access reference access
There are two different pages in the front end. Add data on one page and refresh the data on the other page
Find someone to teach me how to train somethingv2 on slowfast
How can the statistics after pandas group by be output conditionally?
Nlogit import data, whether in CSV or exclude format, not even the CSV format exported by Stata. Project import cannot import it
Problems and solutions in the research and implementation of monitoring system testing in Universities Based on Servlet
- How does uniapp enable wechat applet users to automatically register and log in without authorization
- Java springboot queries the database. The result in the database is empty. Will it return null or throw an exception directly at this time
- Vue import excel table, interface error
- Why is no target connected always displayed
- The sum of the first n series can be solved by a lucky person
- How to calculate the time complexity
- Why does Java report an error?
- Regular expressions that allow numbers, English, and some special characters
- Please answer the questions about ＃ C ＃!
- Is there a method to realize or call sending SMS
- The most hardcore Java programmers in the whole network must have basic knowledge (I)
- How to use selenium to solve the problem of continuing reading in a library
- In simple terms, MySQL index optimization topic sharing | interview cycle
- How to convert the specific template type of template function into string in C + +
- Why is the result 3 4
- DDD (Domain Driven Design) thought interpretation and excellent practice GGG
- MFC project operation error is not a class or namespace
- Builder pattern of Java design pattern
- How to change the inconsistency of two Y-axis axes of echarts? The values of the left and right Y axes are uncertain
- C language to find the volume and surface area of the ball, the volume is equal to the surface area?
- Analysis of shallow cloning and deep cloning in Java
- main. JS introduces Ant Design Vue
- Can some Java dictionaries store null?
- I need HTML when downloading the boost library with WGet on CentOS tar
- [test development] knowledge points - spring cache + redis is used to cache data in the project
- VO entity deposit value is empty? VO entity content data is empty
- Logic of process scheduling in Linux kernel source code analysis
- How to open a file with relative path in C + + under QT environment
- 30000 words to talk about redis (VI)
- It's great to use debug a!
- Netcom infinite integral code
- How to find element label in MATLAB
- 2021 is gone, and 2022 is my year-end summary of 2021
- How to use wechat applet for this page
- Why is the second% s not output
- Badboy recording script website can't be opened in ie. why can't badboy record after changing the default browser?
- fatal error LNK1113: invalid machine type
- Crazy God said that there was a 404 problem in the ssmbuild project in Java
- What is the spark job submission process?
- What is a database connection pool?