Cross database queries

Hello, Does anybody have any info on cross-database joins? i.e. doing a join across various tables that are located inside different databases (albeit on the same database server). I'm interesested in any potential pitfalls, limitations, and performance issues. There doesn't appear to be mu

Re: To replicate or not to replicate that is the question

> I need to put a read-only copy of a single table on a database another > server so remote customers can have read access to it. I use SQLYob Job Agent to synchronise two MySQL databases. See http://www.webyog.com/en/ for more information. I use SSH to so port forwarding from one box to the