Multiple Communities, One Database

Is it possible to have multiple communities (i.e. one for each state) that map to one database? That way, even if member log in to a specific state (i.e. FL), they still have access to all members in different states?

Possible of course.

you should install X dolphins to different databases.

and after installations - connect all dolphins to first database (via header file). Thats all :)

You rock! I'll give it a try this weekend. Thank you.

@AndrewP

you are sure that it works?

f.e. the picture paths are all different then

if i upload a pic on site1 it cannot be found on site2 server

you're correct  not so easy won't work i tried this months ago

I also tried it many months ago. It does not work.

Aaaaw guys :( I was super happy to give this a try. I'm not too concerned about them having all of their items on both sites.... more just the ability to log in...

We do this on several sites (but version 5.6.5)  - one Dolphin code base, one database, multiple domains supported - but it is a custom modification, and not generally available.

But yes, 100% possible with some work.

-Smoge

Yes is very hard work, there no easy way

This guy asked about having single database through several websites. So I answered.

He not asked - how to merge media and other files between hosts. This is another question.

Yes, I can confirm that it will work.

More than 1 year I had boonex.ru and demozzz.ru (my websites) under single database.

Just sometimes (as example) once per month I performed merging of images, videos etc. Commonly this is not so difficult using shell (look for CP command).

Our working configuration is all real time - no need for a copy or merge from time to time.

Each user has a "site join" and "site allow", which indicates what site they joined on, and what sites they are allowed to use.

Also, each domain has filters to control what users can see that domains "members", and so on.

Each domain has it's own template, and also, can have specialized profile fields and search filters.

The largest working configuration we support has more than 750,000 members, 117 million messages,  and about 7 million profile / album images.

But - getting back to the original posters question - we maybe adding this to a Dolphin 5.6.5 project we are working on, that will be open source and available for download.  But we have no plans now to add this to Dolphin 7.x

-Smoge

Stupid way!

@AndrewP 

which header file do you mean  this one --> inc/header.inc.php  I tried but have a few probs i main dolphin in main domain i installed second install in sub-folder new databse etc then changed  inc/header.inc.php to match main site databse etc.

when search from main site it pull data  ect ok but if i try to log in via sub-folder site i get datbase error but if i log in via main site it logs in but to main site not the subfolder site  hope i have explained properly any idea what is wrong ? did i edit wrong file

any help/advice would be appreciated

 sorry to bring up old post guys

Thx again

Hello

You have edited the right file.

Firtst of all:

1)Be sure you have written everything fine in your inc/header.inc.php file

2)Be sure to have the same modules installed in both sites.

So for example.

If you have installed some mods during the installation of the second site, but these mods are not installed in the first site, you will get a database error, because the second site won't find the DB tables for those mods.

3)Are you sure that is a subfolder?

If you are using a subdomain, remember that cookies are not shared between main domain and subdomain, so if you login the main site, you won't automatically login the second site, because cookies are not shared between them.

Let me know if you need further assistance.

 1. yes header file edited correctly only 3 items to change

2.yes only have 2 modules installed deanos tools and articles

3. yes definetly sub-folder  --> www.mydomain.com/newsite

i noticed now that nav menu has changed to matched main domain now and also home pages are exact same eve tho i didnt change anything in new site,  new site is stock except for 2 modules installed

just noticed that the 1click install in cpanel for dolphin installed 7.0.4 where main site is 7.0.3 could this be problem

as when i try to log into new site get database query  error but if hit back button on browser i am logged in ?

Yes, that's sure

The problem is that you are running two different Dolphin versions.

Try to upgrade the 7.0.3 to 7.0.4 or do a fresh installation (much better)

It should work then.

 thx that work did a complete fresh install so now can log in in sub-directory  and also search from main directory but now  that creates another 2 issues

1. now both main site and sub-directory site have same nav menu!  would like to have different nav menu on main site and stock nav on sub-directory

2. also both sites have same index.php lay out is it possible to have diffrent blocks on both home pages?

Thx again for help i really appreciate it  @YobiLab

No I am sorry

Because Blocks and Menu Items are stored in the DB.

So if you have one DB , you will have some blocks and same Menu Items.

You should do an hard modification in the code to make different things.

 Thx for all info looks like will have to re think how i will do this as i didnt want to do major re-code of core files, trying to keep most of  core files stock so for easy upgrading, plus i aint that good lol :)

maybe  a custom goole search box to search multiple sites or pay for a mod hmm  ahh well thx again for help

I've got this for D7 right now. Smoge is right, it is custom.

 @mrpowless

do you have demo ?  what is the cost 

thx for any info

@AndrewP:

If your going to throw out an answer like this on such a complex issue then at least give the poor soul a little info on the level of mastery needed to pull it off.  Can it be done?  Yes.  Is it just as easy as installing multiple D's & then editing a few lines of code?  No.  And there is a lot more to it than just connecting them all to the same inc/header.inc.php file and you know that.  If they're all at the same header.inc.php file then in the end they will all be the same site since the DB is what really makes the site the site.  Gawd, even UFO360 could tell you that and make it understandable. 

Why would you want to do a 90's SQL DB Merge one a month for this?  If you were going to go that route wouldn't you at least lighten the load on yourself and set the cron jobs to do it? 

Sorry UFO, your just a great example in this one.

@TTBrunton

Pay attention to Smoge & Darren (ModMySite & Mrpowless).  It can be done however you need to have some very specific walls up within the DB and within the php files to pull this trick off.  If your not fully fluent in it then I'd suggest hiring Darren to do the work as he has vast experience in it.

Hello guys, this thread had so replies, wow, even not noticed that you asking me

I can confirm that my method working, I had 2 websites (in 2 different domains) for about 1 year

Yes, main question - media and other files-stuff.

Of course!  - you should periodically merge all this stuff manually (but this is good that this is just minutes using shell)

I already prepared necessary SSH commands to merge files in both directions like

cp project1_folder/media/images/*.jpg project2_folder/media/images/

cp project2_folder/media/images/*.jpg project1_folder/media/images/

with skip all (no replaces).

of course - this is just sample, in real I had about 10 different paths. But under shell - this is very fast.

so, periodically (once per week as example) - merge your custom files too !

Again, why would you want to do this manually or in shell manually ever?  What is stopping you from just creating a cron setting to do this for you every so often?  heck, then you could set it to run every five minutes to compare db's and then update as necessary.

Is this what your looking for?

http://www.boonex.com/unity/blog/entry/Synchronization_with_multiple_sites_and_one_BDD_Dolphin

Has anyone else got this working? I want to try it myself