Take the 2-minute tour ×
Drupal Answers is a question and answer site for Drupal developers and administrators. It's 100% free, no registration required.

Since it's so easy to set up pagodabox with multiple databases (for free), I thought I'd experiment with master/slave database setups.

I have good credentials for both MySQL databases. Everything should be fine and dandy.

The trouble is: At no point does Drupal create tables on the slave DB. I made a module to show me the credentials, and verify the connection, but the DB simply has no tables.

Should it? Is Drupal supposed to do this? Or do I need to do the initial replication myself?

share|improve this question
    
This is for sure an interesting question. But I think it does not have a lot to do with drupal. Consider moving it to serverfault since it's about database management. –  BetaRide Jun 28 '12 at 4:58
1  
@BetaRide: The way the question is asked has a lot to do with Drupal, because he assumed that Drupal is responsible for the replication. –  Berdir Jun 28 '12 at 6:16

1 Answer 1

up vote 4 down vote accepted

No, Drupal doesn't.

Master/Slave replication is the job of the database management system, not Drupal's. All that Drupal does is use it, by using the slave server for specifically marked queries.

To be able to use replication, you either need a pre-configured hosting environment which already provides this or full access to the database server so that you can configure it. Replication happens on a server to server level, not database to database. In short, Pagodabox will most likely not allow you to set up replication.

share|improve this answer
    
Thanks, Berdir. –  paul-m Jul 1 '12 at 21:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.