I want to have one site with two different databases: one should store users and other should store the rest. Databases are on independent servers. I know that in settings.php there can be several databse connections. But how can I tell the User module not to use default one?

  • What is your reasoning for having two seperate databases like this? AFAIK splitting up a single Drupal site in this manner is not recommended. If you explain in a little more detail what your functional requirements are I could try recommend a better solution. – Alex Kirsten Feb 13 '14 at 11:04
  • Basically, you can't simply "tell module to use different DB". More details can be found in this question. – Mołot Feb 13 '14 at 11:09
  • Actually I want multiple sites to share users. But the solution when multiple sites share one database is not for this case. Each site should have it's own db and one common with users. – menelai Feb 13 '14 at 12:18
  • Have you checked to see if MySQL itself can support single-query joining across tables in databases located on different servers? I imagine it does in some way, however bad for performance - but If it can't, this is all moot anyway – Clive Feb 13 '14 at 13:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.