For example 192.0.0.1 database data synchronization to A table 192.0.0.2 database A table
The database structure are the same can directly covered table data directly to consider synchronization time
Because does not require real-time now didn't consider the master-slave replication

Want to use the mysql timing task execution beg ace bosses grant instruction! !!!!!

CodePudding user response:

Windows or Linux? Linux can use crontab regularly run the script, Windows task plan

CodePudding user response:

FEDERATED

CodePudding user response:

Linux stored procedure I write not to use the open source Kettle realizes the ETL tool

CodePudding user response:

Mysqldump -h source server source library source table | mysql - h target server