By ivan zugec on
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?
Thanks,
Ivan
Comments
I don't think you can do this
I don't think you can do this through prefixing. You will probably need to enable some sort of clustering on the backend.