should i rename all table with shared_ before the table ? (master and slaves ?)

'somesitename' should it be the domain name of the site ??

in my case the name of my database is :name-of-my-mysql-laccount_name-of-site-database

it's not clear i have test renaming two tabla user and sessions on the slave site and an error occur :

cant find the user table ???

other questions

is it compatible with civic-crm (i plan to use it before) ?
is it compatibilty beetween 4.6 and 4.7 versions ?

thanks'

Comments

dotan’s picture

dotan commented

The simplest way is the following:

Set the master prefix for ALL it's tables. e.g:
$db_prefix = 'master_';

In the slave settings, use the master prefix for the shared tables. e.g:

$db_prefix = array(
    'default'        => 'slave_',
    'authmap'        => 'master_',
    'profile_fields' => 'master_',
    'profile_values' => 'master_',
    'role'           => 'master_',
    'sequences'      => 'master_',
    'sessions'       => 'master_',
    'users'          => 'master_',
    'users_roles'    => 'master_'
    );
danielc’s picture

danielc commented
Status: Active » Closed (fixed)

> is it compatible with civic-crm (i plan to use it before) ?

Don't know. Probably is.

> is it compatibilty beetween 4.6 and 4.7 versions ?

Yes. Go to the project page and click on "View other releases" link.

Your other questions will be answered by reading the comments inside drupal/sites/default/settings.php and Drupal's documentation.

Tobias Maier’s picture

Tobias Maier commented
Status: Closed (fixed) » Fixed

if you close an issue it is not anymore visible for the most people
so give the status "fixed" if you finished a job.
"closed" will be set by the drupal cron-job after a few weeks.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)