current position：Home>What are other restrictions on synchronization between RDS and MySQL instances?
What are other restrictions on synchronization between RDS and MySQL instances?
2022-02-04 16:55:44 【Alibaba cloud Q & A】
RDS MySQL What are the other limitations of synchronization between instances ？
Take the answer 1：
It is recommended that the source and target library versions be consistent , Or synchronize from a lower version to a higher version to ensure compatibility . If it is a high version, synchronize to a low version , There may be database compatibility issues . Before performing data synchronization, you need to evaluate the performance of the source library and the target library , At the same time, it is recommended to perform data synchronization in the low peak period . Otherwise, full data initialization will occupy certain read and write resources of the source library and the target library , It may cause the load of the database to increase . Full initialization will be executed concurrently INSERT operation , Cause the table of the target database to fragment , Therefore, after full initialization, the table space of the target instance is larger than that of the source instance . If the synchronization object is a single or multiple tables （ Non integral Library ）, So when data synchronization , Do not use... For synchronization objects of the source library gh-ost or pt-online-schema-change And other similar tools to perform online DDL change , Otherwise, the synchronization will fail . You can use data management DMS（Data Management Service） To perform online DDL change , See structure change of non locking table .
Warning If there is a division DTS External data is written to the target library , Do not use DMS Perform online DDL change , Otherwise, the target database data may be lost .
author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.
The sidebar is recommended
- Technologies needed for wechat applet development
- The expression has been given to find the image?
- OSPF address configuration of switch
- Let's see how to correct this mistake. I didn't find it myself.
- HDU1096 presentation wrong
- Does anyone understand why the first process will operate through P and the second process will block at p?
- Data structure PTA questions do not know how to change
- Use of react material UI 5.0 components
- When configuring Powermode in vscode, expected comma is displayed
- Stc89c52rc controls the stepping motor, and the program card is in the first line of main,
guess what you like
Zhejiang University pat class B 1048 test points 4 and 5 cannot pass, solution
What's the difference between the same sentence?
Enter several student grades at random
Expression 1 + 4 / 5 + 15 & lt; The value of 7 + 4% 5 + (8,10) is
7-3 simple character transformation (20 points)
After the spring boot project is jar packaged and deployed to alicloud server, init datasource error is displayed. But local operation is good.
The automated test tool RF cannot modify the font size
Question about CSS: since I have div nesting, how can I write CSS style
The problem that DSS + FTP cannot be played online
How to automatically execute pycharm file after clicking it
- How to solve the problem that the raspberry pie prompt cannot locate the software package when installing ngnix?
- How should I make up this problem? Please ask me
- What does this error message mean
- Beg, an exercise problem, can't figure out a way of thinking
- How to judge whether the folding screen is unfolded when there is a problem of folding screen adaptation at the mobile terminal?
- On the issue of CAS authentication, there is the problem of bill invalidation
- Why should e add 127 to e? Xiaobai said he didn't understand
- How can I get the value behind this k? Wentang college wants to use crawlers to crawl e-books.
- Pyqt5 how to output percentages directly?
- When the Android 10 app version is downgraded, you are prompted that the application is not installed. How to solve it?
- Different expressions of month, month and day have been output. How to judge the season according to the output month
- Canine distemper sports I Oh, afraid qwe
- Short answer: SQL statements complete the following queries
- What are the input formats of MySQL binlog?
- What is the business logic of wordcount?
- What is the function of terraform?
- What are the four features of MySQL's InnoDB engine?
- What are the instructions for configuring the task steps of DTS self built MySQL synchronization to RDS MySQL?
- What is the process of installing other dependencies in ganglia?
- What are the advantages and disadvantages of MySQL index?
- What are the instructions for configuring the processing mode of the target existing tables that DTS self built MySQL synchronizes to RDS MySQL?
- What is the core program running mechanism of MapReduce?
- What is the core competence of Alibaba cloud log service?
- What are the types of MySQL indexes?
- What is the description of the configuration of synchronization objects from DTS self built Mysql to RDS MySQL?
- What is the function of clusteringkey?
- What should I pay attention to when starting and using ECS?
- What is the description of the configuration of the mapping name change of DTS self built MySQL synchronized to RDS MySQL?
- What are the principles for creating indexes in MySQL?
- What is the description of the configuration of filtering data to be synchronized from DTS self built Mysql to RDS MySQL?
- What is the basic logic of MapReduce client for map phase parallelism planning?
- What is the description of the configuration of SQL operations for DTS self built MySQL synchronization to RDS MySQL synchronization?
- What is the leftmost and most prefixed principle of MySQL?
- What is the description of setting alarm configuration for DTS self built MySQL synchronization to RDS MySQL?
- What does MySQL overlay index and back table refer to?
- What are the instructions for configuring the case policy of the object name of the target database synchronized from DTS self built Mysql to RDS MySQL?
- How to pull data from maxcompute and upload results?
- How to use serverless log to realize alarm?
- What is optimizing bitmap indexing?
- Source table DMS_ ONLINE_ What is the description of whether to copy the temporary table to the target library during DDL?