How to synchronize field information in different databases and tables? Mysql

How to synchronize field information in different databases and tables? Mysql synchronizes the user personal information of two programs. Is there any good Convenience? 1. when adding the program, write 2 at the same time, besides this, when I modify it, are there any differences between the table and the Field Definitions? one program in the table is discuz, and the other is kppw? I think this is the case. encapsulate a synchronization class, the modification method is called During modification. how does one synchronize fields in different databases and tables during multi-table synchronization? Mysql
Is it convenient to synchronize the user personal information of two programs?
1. when added, both write
2. modified at the same time
Besides this?
Different tables
Field definitions are not all in the same table.
A program is discuz
The other is kppw.

------ Solution --------------------
I think this should be the case. encapsulate a synchronization class and call the modification method when modifying it to perform SQL operations for multi-table synchronization.
------ Solution --------------------
Such a business depends on your own business needs. if you need real-time update, you cannot update the business in real time. if not, you can update the business in different time intervals.

It is recommended that you synchronize updates and update updates in real time. the efficiency will certainly be affected when concurrency is high.