Answers.Body: <p>Should work fine. Best practice is definitely two databases. </p>
  
  <p>IMHO it is easier to understand where data is stored and deal with update and rolling back changes when the databases are separate, but in some hosting environments you are forced to use a single database for both the Drupal and CiviCRM tables.</p>
  
  <p>Using separate databases requires you to go to CiviCRM > Administer > System Settings > CMS Integration and copy the array generated to your Drupal settings.php file.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-10T12:59:17.990Z
Answers.LastActivityDate: 2018-01-10T12:59:17.990Z
Answers.UserDisplayName: Pradeep Nayak
Answers.Body: <p>Unless absolutely necessary, I never use the same database for both. Both Drupal and CiviCRM can end up with databases of a significant size. I've found that this can sometimes cause lag and slowness with the site. Not to mention that if you need to restore a database, it can be difficult for the average person to do once it gets over a certain size. Often times you'll need to get assistance from tech support at your host or know how to use command line.</p>
  
  <p>I've found typically if I am so locked down that I can only have a limited number of databases, the server also has insufficient resources for running Drupal and CiviCRM well. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-11T23:47:01.497Z
Answers.LastActivityDate: 2018-01-11T23:47:01.497Z
Answers.UserDisplayName: Jenni Simonis
Body: <p>Is there a reason to use two separate databases for CiviCRM and Drupal, or can I use the same for both? What would be affected if I used the same for both?</p>
  
Tags: <drupal><mysql>
Title: One Database or two?
ThreadText: # One Database or two?
  
  (Asked by: username_0 on 2018-01-10)
  
  Is there a reason to use two separate databases for CiviCRM and Drupal, or can I use the same for both? What would be affected if I used the same for both?
  
  **Tags:** drupal, mysql
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2018-01-10. Score: 3
  
  Should work fine. Best practice is definitely two databases.
  
  IMHO it is easier to understand where data is stored and deal with update and rolling back changes when the databases are separate, but in some hosting environments you are forced to use a single database for both the Drupal and CiviCRM tables.
  
  Using separate databases requires you to go to CiviCRM > Administer > System Settings > CMS Integration and copy the array generated to your Drupal settings.php file.
  
  
  ---
  
  ### Answer by username_2 on 2018-01-11. Score: 0
  
  Unless absolutely necessary, I never use the same database for both. Both Drupal and CiviCRM can end up with databases of a significant size. I've found that this can sometimes cause lag and slowness with the site. Not to mention that if you need to restore a database, it can be difficult for the average person to do once it gets over a certain size. Often times you'll need to get assistance from tech support at your host or know how to use command line.
  
  I've found typically if I am so locked down that I can only have a limited number of databases, the server also has insufficient resources for running Drupal and CiviCRM well.
  
  
  ---
  
  