I am entertaining migrating my PHP/MySQL system over to Amazon Web Services. I have multiple MySQL Databases, currently managed by phpMyAdmin. I frequently have to cross query Databases, PDO Joins across two or more Databases in a single query.
If i migrated the code to EC2 and the database across to Amazon RDS, could I still cross query multiple databases using a single query in PHP / MySQL / PDO?
If so, can someone provide guidance on how this can be achieved. Thanks for your help.