Table A and Table B (Table B wants to synchronize the data in Table A. The account field in Table A is the same as the account field in Table B. The condition for synchronization is that the account field exists in Table A but not in Table B. time, you need to take out the account field in table A and write it to table B synchronously) Please share a good solution for the situation where the amount of data is large and growing
1
0
0
歡迎選擇我的課程，讓我們一起見證您的進(jìn)步~~
1. Option 1: When there is an operation of writing to table A, the writing operation of table B is also performed immediately.
add(data){
insertA(data);
insertB(data);
}2. Option 2: When there is an operation to write to table A, write the record to the queue and write it to table B asynchronously.
add(data){
insertA(data);
synQueue2B(data);
}In addition, both solutions can write another job to regularly compare the set of account fields in tables A and B for data synchronization
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
