If the engine supports cross-server joins then it should be possible in both PHP and Python.
2). (As you are using PHP) Fetching data from one server, then either looping through the data and firing relevant queries to another server, or firing single aggregated query to another server based on the data fetched from first server.
I have two identical mysql server with same databases and tables structures but with different data.
Different Strokes… …for Different Folks PHP 101 (part 8): Databases and Other Animals – Part 2.
This article covers the various options for querying and reporting data from multiple sources and different techniques and software that is available.
Good day to all... I just want to ask.. How would you connect two tables from 2 different databases using PHP scripts?
I have Database server on one machine and another one on some other machine. Now, the thing that I want to achieve is query the 2nd server's database
May I know how to establish connection to two different database in two different server for one website? The reason I ask is because I do have the need to query another database that hosted in another server from my website.
Php Query into database Fail? 0. FromJoomla MySQL Query with where condition on external database. 0. Relational database querying failing. 1. while loop - Database query failed
To answer you question yes you can connect different servers at the same time.