We have an application that uses two instances of mysql, running on two different ports on the same server, say 4510 and 4511. Table "A" has transaction details and a user number, Table "B" (on 4511) has user details. I need to simply join the two tables to provide all of the transaction details and the associated user name. Apparently if these two databases were on the same mysql port, this would be pretty simple. However, I'm not sure how to make it work in this case.
The only thing I've found so far relates to using a federated storage engine and federated table. Is this the correct (only?) way to do what I need to do?