开发者

Generating report from multiple mysql databases hosted on different servers

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜