CODEWITHSUNDEEP
mysqlsqldatabasejoin
kulls
kulls

Reputation: 885

common mysql table in a server connect to different mysql Servers

I have a country table in server A and I want to have a reference it in different servers B, C and D.

How can I Join A with B, A with C and so on? Or Should I create a view of Country table in B,C and D?

Upvotes: 0

Views: 35

Answers (1)

Mariusz Beltowski
Mariusz Beltowski

Reputation: 998

To acquire this on the database level you will need to setup replication, you can read about it here

Or use federated tables, here.

Upvotes: 1

Related Questions