Hi, I have 3 servers ( A B and C ) and every Server has one db ( DBA DBB DBC ) On the third Server I would like to query all three databases ( only selects from DBA and DBB ). I thought about setting 2 slave and 1 master Servers on Server C but then I would need to open 3 connections to query all databases. Last night I got the idea to let the slaves run under an other user and link the DBA and DBB directory read only into the Server C data dir... So I could query the DBC Server with all databases. I guess query_cache won't work then because Server C don't see updates or deletes in the DBA and DBB tables but another question is do I need locking when I only do read only access ?
-- Bastian Hoyer ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
