Can mysql database synchronization be performed on a single table? First question:
Can mysql database synchronization be performed on a single table?
That is to say
1. Database A contains three tables a1, a2, and a3, and database B has only one a1 table (A and B have the same a1 table structure)
2. database B only synchronizes the a1 table in database.
3. Database A also needs to synchronize Table a1 of Table B
Note: In fact, it can be considered that the a1 tables of database A and database B are two-way synchronized, that is, the a1 data of database A has changed, and the a1 data of database B needs to be changed accordingly, similarly, database B a1 changes, and database A a1 also changes (Aa1 <=> Ba1)
Second question:
Is the configuration of database synchronization the same for linux and windows?
Reply to discussion (solution)
Synchronization is for a single table. if multiple tables are required, they should be listed one by one. Of course, you can also set the entire database synchronization.
There are also several similar issues: how to synchronize several tables
