Hi,

As a member of drupal i had a portal which consist of various section as in photos,locations,audios,videos and so on.Each section is big in itself.I m using a one database for the whole section due to these my server load is increasing.Now i want to separate each section and create an respective database for each section i.e. I want to used the same code for multiple database but if user in audios section and he want to search profiles which is in other section he should get the result what he searched.I don't know weather its possible or not but i m awating for some good response.

Comments

gbaudoin’s picture

gbaudoin commented
Status: Active » Closed (fixed)

If you need more performance out of the database, you'd better use a master-slave DB setup, to share the load amongst several servers. It'll still look as one big database from your website.

gbaudoin’s picture

gbaudoin commented

Please follow the steps in http://drupal.org/documentation/install