Shared database technique in general
After investing a lot of time trying to figure out how to do multi-site via a shared database, I've come to the following (personal opinion) conclusion.
Just Say No
Reasons:
Read moreD5 Shared database - sharing all but theming/layout/navigation
Warning - I'm a noob, please be gentle
Here's a pretty much self-documented settings.php file showing how I've got my multi-site working. If someone familiar with Drupal's (v5) database structures could scan this and comment I'd really appreciate it. Note ALL the core tables are listed here, as per grepping "CREATE TABLE" from the .install files.
$db_prefix = array(
'default' => 'watchout_drupal.shb1sh_', /* new tables get created here, /
/ need to analyze and then add (shared or separate?) below /
'cache' => 'shb1sh_', / must be separate /
'cache_filter' => 'shb1sh_', / must be separate /
'cache_menu' => 'shb1sh_', / must be separate /
'cache_page' => 'shb1sh_', / must be separate /
'variable' => 'shb1sh_', / must be separate /
'accesslog' => 'shb1sh_', / site tracking - separate /
'client' => 'shb1sh_', / site tracking - separate /
'client_system' => 'shb1sh_', / site tracking - separate /
'flood' => 'shb1sh_', / site tracking - separate /
'watchdog' => 'shb1sh_', / site tracking - separate
The Drupal Virtual Site module
I am just starting a multisite drupal setup. My plan is to have some magazines with pretty much all the same functionality. even the themes will be the same with differnet images. I was looking at the drupal virtual site module, but have not tried playing with it. Its sounds pretty sexxy but I have not started playing yet. does anyone have any experience. This is a D6.2 project.
the link is here: http://drupal.org/project/virtual_site
Here is the sticking point... I want to have one code base, but the domains are separate...
www.domain1.com
www.domain2.com
www.domain3.com
I'm having trouble setting up a second separate site - database tables need to get created somehow
Hi all, first time post.
I have been using Drupal for my wife's business website for some time now and I really like it. I am running Drupal 6.2 on FreeBSD and I'm using Apache 2.2 as the web server and PostgreSQL as the db backend.
I am trying to setup a website for myself using Drupal with a separate database for my site. I created the appropriate folder under sites/ and copied the settings.php file. I created a new db and set that db name and password in the settings.php file. I also configured apache to handle the new virtual server.
Read moreDevelopment, Staging and Production sites
Hi everyone, newbie here. I was able to multisite working. I only have one problem:
My customers have exisiting sites like lets say customer1.com and customer2.com
I want to migrate them, but be able to host them on my server (mydrupalserver.com) until they migrate thier hosting and site to my site.
I totally understand how to setup my box to read thier domain locally (With hosts files in windows), how would I set up a staging site so I can essentially move over thier .com
some issues I see:
Read moreGroups vs. Multiple Drupal installations
Hello there!
If you want to give a user total control over a site (his/her site, area, or whatever you want to call it), what should be better? Creating a group for each user, as in drupal Groups, or creating a multisite installation?
When I say "total control" I mean everything: Blogs, polls, newsletters, have a fan´s group (not buudies, I mean actual users that are created just to enter his/her personal site).
Would multiple sites installations become a huge monster, that no server could manage?
What are your thoughts?
Rosamunda
Read moreMySite on shared tables
Hi
I'm thinking about the possibility to use mysite with multi site installation.
For example, let's say we have several shared tables:
'users' => 'shared.',
'sessions' => 'shared.',
'role' => 'shared.',
'authmap' => 'shared.',
'sequences' => 'shared.',
'profile_fields' => 'shared.',
'profile_values' => 'shared.',
'users_roles' => 'shared.',
we have two sites site.com - for english users and site.ru for russian users. Both sites have shared tables in shared. database and each site has own database for the rest tables. This should be working well.
Read moreHosting ideas?
Folks, I'm looking for some ideas.
I currently play "site admin" for four different web sites. They are all physically located in different web hosting accounts with the same web host. All of them are running Drupal. My role with all of them is to keep Drupal and the necessary modules and themes up-to-date and to establish the structure and functionality of the site. It's someone else's job to create and manage content using the tools that Drupal provides. All of these sites are for not-for-profit organizations and I'm not making any money from them...just covering expenses.
Read moreLong URL's for Multisite files folder
I have set up my first multisite installation and I have a question. I have parked a domain using CPanel onto my main domain and I have directories set up for each site in the sites folder. Here is what my sites directory looks like for the 2 domains:
sites/domain1.com/files
sites/domain1.com/modules
sites/domain1.com/templates
sites/domain1.com/tmp
sites/domain1.com/settings.php
sites/domain2.com/files
sites/domain2.com/modules
sites/domain2.com/templates
sites/domain2.com/tmp
sites/domain2.com/settings.php
New installer
Create a new installation/site administration mechanism for Drupal. I should be able to configure any number of sites for my Drupal installation, right from the installer, through a simple GUI, without ever needing to manually copy files. The installer should be able to create the appropriate folders and files in the sites directory for me. I also should be able to return to the installer at any time to add additional sites to my installation, or to reconfigure existing sites.
Read more


