How feasible to connect to multiple dbs in MySQL

Janardhana M · June 6th, 2005, 08:37 AM

Please Let me know How feasible it is to create & use many databases in the MYSQL Database for an application? The Application needs to communicate with these many databases and display them in some pages of it. Since it has to do many connections to use these many databases and use the data from these different databases in a single page Is this a proper way? Does this has any disadvantages?

Please reply. I'm using MySQL for first time.

Janardhana

ciderpunx · June 7th, 2005, 04:42 AM

You'd normally do this by setting up multiple tables within the same database. So you might have a database called admin with tables called customers, employees and products. This is an absolutely standard thing to do and MySQL should have no problems at all.

If you really need data from seperate databases then this is also possible, but, like you say, you will need to open seperate connections to each one, which may be a little slow for large sites and/or large sets of data.

--
Don't Stand on your head - you'll get footprints in your hair
http://charlieharvey.org.uk
http://charlieharvey.com

ChrisScott · June 7th, 2005, 04:59 AM

Depending on how you are connecting, you can use the same connection for more than one db and even join tables from separate dbs (obviously the user you connect to mysql with will need rights on the various bases)...

Code:

SELECT myField FROM myDataBase.myTable;

HTH,

Chris