Synchronizing Databases
| Project: | Fierce SSO |
| Version: | 5.x-1.x-dev |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | eli |
| Status: | closed |
Jump to:
Nice module! Thank you for developing this.
Before I get too far into my next step I wanted to check this out with you to see if I'm duplicating effort or going about this the wrong way.
I want to have N separate hosts/databases participate in the same Fierce SSO federation. Does there exist a module or MySQL-level function that would allow me to replicate the "shared_" tables to all N servers?
MySQL replication is at the database level, so that's out, I think. Using MySQL's Federated engine for these tables would require some Drupal rewriting, so I think that solution is out.
I'm going to go browse the Module library to see what's there, and if I don't find anything then I'm thinking that I'll need to write a custom program that updates the N servers every time a user is added to one ... probably called by cron.
What do you think?
- Scott
#1
Hey, sorry for the delay.
Let me put it this way: this module presumes that you already have a functioning multi-site set up with a single "shared_users" table. All it does is faciltate single-sign on so that when you log in to site A (and create a session), it also logs you in to Site B, C, D, etc (creating user sessions on all those sites too).
If you're looking for a way to divide up the users table among multiple databases/hosts, well, that's outside the scope. If the only thing that the different hosts need to share is the users table, then I would consider looking at something like OpenID or LDAP.
Let me know if that didn't answer the question.