MySQL Performance: MySQL => Join tables across database

Join tables across database [message #680]

Wed, 07 February 2007 10:56

al.james
Messages: 16
Registered: October 2006

Junior Member

Hi there...

I am building a couple of websites. The idea is that the two (later to be more) sites share some info such as user accounts.

Now, I want to use a separate database for each website, but how would I manage to link the user tables?

Currently all the databases exist on the same server, so I beleive it would be possible to keep the joint data in its own database and be able to access it in database.table.column notation.

However, would I pay a performance hit doing it this way? In particular if I were performing joins across databases?

Is there another way to do it. I.e. could I create a virtual table in one database that is a linked copy one from the other database.

Also, if the database grows beyond a single server, I guess I could use replication to do this?

Report message to a moderator