Kishhna, On Tue, Mar 17, 2009 at 4:13 PM, Krishna Chandra Prajapati <prajapat...@gmail.com> wrote: > Hi list, > > THE IDEA IS TO HAVE A COMMON LOGIN > > I have two mysql servers with different databases on each of them. > > I want to search each databases(few tables) on both the server using a > single login(mysql connection) > > Procedure is working fine.but then i have to use two logins(mysql > connection) > (Federated is not working efficiently) > > Is there any solution apart from scripting.
Maybe this is too much overhead, but you could have something like sphinx search index both servers and search there instead. Cheers, Ewen > -- > Krishna > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org