For our purposes, it is sometimes to share tables between sites. In particular, we share the user table quite regularly. Since this is done in the settings.php, it would require to be a Aegir module of some sort.
I would picture starting with a provision module that would tap into the settings.php hooks to add a $db_prefix variable like this:
$db_prefix = array('default' => '', 'users' => 'other_db.');
This could be hardcoded in the site's settings to start with, but then we would need a hosting frontend to manipulate that setting. Not sure about the UI here...
The backend should also ensure the user has access to the other_db using the appropriate grant (and also remove those grants when the site is removed).
Comments
Comment #1
nordviks commentedI think Ægir should have this feature by default. There are probably numerous reasons why one would need communication between Ægir sites. Mine is an organization that has many offices with different websites, these need a unified microbloging. I would like to help testing.
Comment #2
anarcat commented#500088: allow user-defined settings.php overrides should help with this, for those who want to shoot themselves in the foot (because db_prefix will break upgrades). But I don't think we should go out of our way to support this.
Comment #3
anarcat commentedSee also #608918: Support for Single-sign on (if this is about SSO) and #556598: $db_prefix not handled in migration (for transition away from prefixes).
Comment #4
anarcat commentedclearly a faq