Skip to content

Instantly share code, notes, and snippets.

@totten

totten/multisite-range.md

Created July 13, 2018 20:52
Show Gist options
  • Save totten/c64a774974c4fc92673f4c4965ce5856 to your computer and use it in GitHub Desktop.
Save totten/c64a774974c4fc92673f4c4965ce5856 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
multisite-range.md

Definitions

  • Data Parititioning
    • Unitary/Unpartitioned/Shared: All data from the different sites are mutually accessible.
    • Key-based Partition: The data for all sites are stored in the same DB/table/schema. However, there is a column (eg domain_id) to distinguish them.
    • Schema-based Partition: The data for all sites are stored in separate DB/table/schema.
  • Code Partitioning
    • Unitary/Unpartitioned/Shared: The same code is used for all the sites.
    • Partitioned: Each site has different code.

Example

A typical Drupal 7 multisite deployment features:

  • Drupal Data: Schema-based partition
  • Drupal Code: Unitary
  • CiviCRM Data: Schema-based partition
  • CiviCRM Code: Unitary

Matrix

||Foo||Bar|| ||--||--|| ||ab||cd||

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment