I would like to use the multi_db gem to connect to multiple slave databases. It looks pretty easy as long as your app has a single application database. For example: production: adapter: mysql database: a_production username: blahblah password: host: 10.0.0.1 port: 3306
production_slave_database_1: adapter: mysql database: a_production username: blahblah password: host: 10.0.0.3 port: 3306
production_slave_database_2: adapter: mysql database: a_production username: blahblah password: host: 10.0.0.4 port: 3306
The issue I am having is I can't figure out how to configure it to work with multiple application databases. Let's say your app has 2 databases, your main app database and data database. The app database has users info and user created info while the data database has a lot of read only data that gets updated say...once a week.
You might create a production: adapter: mysql . . . production_data: adapter: mysql . . .
Then you might want slave/s for each of those databases. You can use establish_connection in the models that need to access the production_data database. There is a way to do it with masochism like this:
##example, showing the setup of a different master/slave combo using setup_for config.after_initialize do ActiveReload::ConnectionProxy.setup! ActiveReload::ConnectionProxy.setup_for SpeciesSchemaWriter, SpeciesSchemaModel end But, as far as I know you can only use a single slave with masochism, is that true?
Thanks for any help. Erik