开发者

Generating report from multiple mysql databases hosted on different servers

开发者 https://www.devze.com 2023-01-11 09:21 出处:网络
I have four different servers; parent.com, a.com, b.com and c.com. At the end of the day I have to pull data and generate report from a, b and c and show in parent. a, b and c databases are having sam

I have four different servers; parent.com, a.com, b.com and c.com. At the end of the day I have to pull data and generate report from a, b and c and show in parent. a, b and c databases are having same the s开发者_JAVA技巧tructure, but as I mentioned, they're hosted on different IP/server.

Can you please tell me what may be my approach?


MySQL does support FEDERATED tables, although performance may not be particularly great.

0

精彩评论

暂无评论...
验证码 换一张
取 消