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.
精彩评论