Tweet
Sharing users between two forums
Hello, is there a way to share/bridge two vB databases (users) between two forums on two separate URLs, but on same server?
Please assist..
There must be some way..
Please assist..
There must be some way..
-
> Follow this link for the CHEAPEST Domain Name Registration - Domain Transfers Are Even Cheaper! :)
WoW Accounts, FFXI Accounts, Aion Accounts, FFXIV Accounts, MMORPG Market -
Short answer: no.
Long answer: you can hire someone to do the integration but it's a PITA and makes upgrades more challenging. If you don't want to spend a few $1000 over the next few years or really enjoy custom coding, I wouldn't bother. -
> Follow this link for the CHEAPEST Domain Name Registration - Domain Transfers Are Even Cheaper! :)
WoW Accounts, FFXI Accounts, Aion Accounts, FFXIV Accounts, MMORPG MarketComment
-
Unless I'm misunderstanding your question, your best bet is to do this at the database level. There are many clustering solutions out there that will allow for mirroring of tables. Basically the clustering software will notice an insert, delete, update, whatever and perform the operation on both tables simultaneously. It will require a very short lock on the foreign database table, but in the case of a user table we're talking microseconds, if that, so you shouldn't notice any performance degradation.
This would not allow you to actually do the lookups on a different database's table, but instead would allow you to do look ups on the table integral to the database associated with your foum. However the data on the local table will always be identical to the foreign table barring one database being unavailable at the time a write is made. Once the other database becomes available, syncronization will occurr imediately.
The advantage of this is that you have absolutely zero modifications to the php code that your site runs, and no maintenance whatsoever other than upgrades to the clustering software if and when you upgrade your database version. Doing it at the PHP level is just a sorry hack.Anybody who says "it can't be done" will usually be interrupted by somebody who is already doing it.Comment
Comment