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.
Yes, there's nothing about RDS that would make this any different.
RDS for MySQL is still MySQL Server.
It's managed by AWS, on servers managed by AWS, which means you don't have access to the underlying OS, certain common administrative actions are disabled because they're managed by the RDS infrastructure, some administrative commands normally reserved for users with SUPER privilege (which is not granted) are different (e.g. KILL QUERY thread_id; becomes CALL mysql.rds_kill_query(thread_id);) and some advanced capabilities like the FEDERATED storage engine and custom plugins are disabled...
But there's no reason any of the things you've mentioned wouldn't be exactly the same.
