Access shared database tables on different server

Posted by ivan zugec on November 9, 2009 at 5:01am

Hi,

I have been working on setting up a multisite + single sign on site, I did this by adding the following to the settings.php.

$db_url = 'mysqli://username:password@localhost/databasename';
$db_prefix = array(
    'default' => '',
    'authmap' => 'shared.',
    'role' => 'shared.',
    'sessions' => 'shared.',
    'users' => 'shared.',
);

It's working fine if all the databases are on the same server.

But is there a way of telling Drupal to connect to a different mysql server to access the authmap, role, sessions and users tables?

Something like this??:

$db_url['default'] = 'mysqli://username:password@localhost/databasename';
$db_url['shared'] = 'mysqli://username:password@192.168.0.1/user_shared';

Thanks

Comments

If you're using another db

Posted by rpsu on November 24, 2009 at 8:24am

If you're using another db ('shared') you need to switch to this database BEFORE you can run queries to this database. I guess this is not possible, since you would need to switch server/connection always while needing to get stuff from shared-tables.

See this db_set_active api.

--
Perttu Ehn