Posted by mkabot68 on October 23, 2007 at 1:29pm
As I look towards upgrading my Drupal 4.7 multisite with 400+ sites in it, I am questioning what is the best database structure to use. I should note that each of these sites is independant - they do not share tables at all. I am also using mySQL as the DB.
Right now the entire installation uses a single database with DB_PREFIX to seperate the tables by site.
Does anybody have any experience in this area they would care to share?
I do know that one downside of a single database is that backup of individual sites and debugging the db is complex sometimes given the # of tables in a single database and the prefix needed. With a separate DB for each site this would be much easier - question is would that effect performance?