Page 1 of 1
multiple mysql databases
Posted: Fri Jan 19, 2007 1:52 pm
by GeXus
Does anyone have any suggestions as to the best way for handling multiple databases with php? I know some people do mirroring or clustering.. but i really am not too familiar with using more than one database. Any input would be great.
Posted: Fri Jan 19, 2007 2:46 pm
by Christopher
I think all you need to do is create a connection to each database and off you go. I do this fairly often. Having a connection object obviously makes this a lot simpler because the code does not have to care which connection it is using.
Posted: Fri Jan 19, 2007 10:01 pm
by GeXus
How would that balance the load though? Wouldnt that mean that I would be writing to both databases simultaneously?