Take MTSQL for example

Database A:

IP: 192.168.1.1:3306

The username root1/root1

Database B:

IP: 192.168.1.2 instead: 3306

The username root2/root 2

Now want to put the data in the database A backup to the regular daily database B,

For a great god how should handle?

CodePudding user response:

1, master-slave, 2, write a script export import, 3, direct copy database data directory

CodePudding user response:

So get into master-slave synchronization?

CodePudding user response:

Bandwidth between data timeliness, data capacity, AB, nothing, not even how much Ken,

CodePudding user response:

1/f, positive solutions,
To get into,
Baidu once,

CodePudding user response:

Master-slave is best, but also depends on the specific circumstances, cloudy or area master-slave not necessarily more reliable to solve the problem, if the Lord is not alone to write a small service in sync, copy the data directory does not display,

CodePudding user response:

Can't through stored procedures?

CodePudding user response:

Datax smoke several tools to know about the

CodePudding user response:

Timing task (crontab) scripts can ah,
Mysqldump out a SQL file to backup library is deleted, to import into,

CodePudding user response:

I also think this timing task how to solve