Re: Newbie needs help with MySQL and multiple databases

Matthew wrote:

Hi, im fairly new to php and mysql and need a little help. im running a forum community and would like to have it run on multiple databases because of performance issues others have encountered using the same software on on database. My question is is it possible to have the software connect to 2 different databases depending on which is needed? and if so will users need to login again when accessing the second database (their user info will only be on the second database.) Thank You Users shouldn't have to log in, the whole process should be transparent.

But how, that would depend on what data you want to get from where, (I gather the 2nd db would be on a different machine?). You'll usually have to edit the files to get something like that done =/ - Tularis