聚合PHP中多个mySQL数据库的结果

Question

I have a large # (say 100) of databases with identical schemas and want to do SQL aggregates across this entire collection of databases.

Lets say the table is ATHLETES

CREATE TABLE ATHLETES(JERSEYNUM, FIRSTNAME, LASTNAME, TEAMNAME, SPORT)

I want to be able to dynamically specify a query like

SELECT SPORT, COUNT(*) FROM ATHLETES GROUP BY SPORT

And have it run across all 100 of my databases, producing one combined result set.

The important thing is I want to do this dynamically -- I want to type a SQL query into a PHP-based web UI and execute it.

Also these queries are typically slow (3 min each), so I'd rather they run in parallel then in serial and take 300 mins.

Answer 1

In my opinion, you should create a table with the databases login data and then loop through all the db's with your query and collect the data in php arrays. As far as I know is possible to join tables but not join db's? I don't think it will be possible to run parallel queries.