且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用Java将数据从mysql数据库复制到其他mysql数据库

更新时间:2023-02-02 20:39:43

一个不错的选择是在MySQL中使用复制功能.请参阅MySQL手册此处以获取更多信息.>

I have developed a small swing desktop application. This app needs data from other database, so for that I've created an small process using java that allows to get the info (using jdbc) from remote db and copy (using jpa) it to the local database, the problem is that this process take a lot of time. is there other way to do it in order to make faster this task ?

Please let me know if I am not clear, I'm not a native speaker.

Thanks

Diego

One good option is to use the Replication feature in MySQL. Please refer to the MySQL manual here for more information.