As title, the project has a production database and history database,
Ask bosses, synchronous data table what method?

CodePudding user response:

Especially for large tables, hundreds of millions of data, how synchronization is better

CodePudding user response:

The mirror? Master-slave? Disk display + database cluster?

CodePudding user response:

Master, copy machine ACTS as a backup, not bear the operating performance of the business, speaking, reading and writing.
Master-slave replication, the host is responsible for the read and write operations, from the machine only responsible for read operation, is not responsible for write operations,

Database with synchronization mechanism,
SQL server such as
https://blog.csdn.net/Doudou_Mylove/article/details/82692287