�ݺ�ߣ

• 26,000+ Students
• 4500+ Faculty and Staﬀ
• Teeny-tiny web team
• Over 600 single site installs
Canada’s Capital University
About
Carleton
michael.corkum@carleton.ca
@mikecorkum

How It
Started
@mikecorkum

Y U NO
MULTI
SITE?
@mikecorkum

The
Rogue
@mikecorkum

Function
Of Doom!
@mikecorkum
echo_text(‘What am I doing?’);
When you feel bad about your skill
level, remember that someone
thought this was a good idea…

Function
Of Doom!
@mikecorkum
echo_text(‘What am I doing?’);
When you feel bad about your skill
level, remember that someone
thought this was a good idea…
function echo_text( $text ) {
echo $text;
}

When I
Started
@mikecorkum
• Manual updates to plugins and core
via FTP
• Random plugins
• Simple architecture
• No version control
Total time to update: 5-7 days

Goals
are fun…
@mikecorkum
Better network architecture
Make updates fast and easy
Make all sites portable
Track site information

When I
Started
@mikecorkum
Sometimes real life isn’t
cutting edge…

Network
Overview
@mikecorkum

Updates
@mikecorkum

ln -s
@mikecorkum
https://2016.wpcampus.org/schedule/introducing-wordpress-multitenancy/

Huh?
@mikecorkum
The term "software multitenancy" refers
to a software architecture in which a
single instance of software runs on a
server and serves multiple tenants. A
tenant is a group of users who share a
common access with speciﬁc privileges
to the software instance.

WP Folder
Theme Folder
Plugin Folder
SERVER ROOT
/wp
/wp-content/themes
/wp-content/plugins
INSTALL
/wp
/wp-content/themes
/wp-content/plugins
INSTALL
Huh?
@mikecorkum
What’s a Multitenancy?

Each
Install
@mikecorkum
index.php
Conﬁg File
WordPress (symlink)
Themes (symlink)
Plugins (symlink)

Case study: Carleton University – managing 600+ single installs

Code
Updates
@mikecorkum
https://roots.io/using-composer-with-wordpress/

MySQL:
Always
Down
@mikecorkum

MySQL:
Always
Down
@mikecorkum
https://github.com/stuttter/ludicrousdb
$wpdb->add_database(array(
'host' => 'localhost',
'user' => 'user',
'password' => 'password',
'name' => ‘db_name',
'write' => 1,
'read' => 0,
));
'host' => 'localhost',
'user' => 'user',
'password' => 'password',
'name' => ‘db_name',
'write' => 0,
'read' => 1,
'timeout' => 0.2,
));
https://wordpress.org/plugins/hyperdb/

Dynamic
Conﬁg
@mikecorkum
URLs
define( 'CURRENT_HOST', $_SERVER['HTTP_HOST'] );
define( 'WP_HOME', 'https://' . CURRENT_HOST );
define( 'WP_SITEURL', 'https://' . CURRENT_HOST . '/wp' );
if ( CURRENT_HOST !== PRODUCTION_CURRENT_SITE ) {
ob_start( function ( $page ) {
return str_replace(
array(
PRODUCTION_CURRENT_SITE,
STAGING_CURRENT_SITE,
DEV_CURRENT_SITE,
LOCAL_CURRENT_HOST,
),
CURRENT_HOST,
$page
);
});
}
https://scotty-t.com/2012/01/18/wordpress-in-dev-qa-and-prod/
define( 'PRODUCTION_CURRENT_SITE', 'carleton.ca/dev' );
define( 'STAGING_CURRENT_SITE', 'stage.carleton.ca/dev' );
define( 'DEV_CURRENT_SITE', 'dev.carleton.ca/dev' );
define( 'LOCAL_CURRENT_HOST', 'local.carleton.ca/dev' );

Dynamic
Conﬁg
@mikecorkum
Diﬀerences per environment
$is_staging = ( STAGING_CURRENT_SITE === CURRENT_HOST );
$is_dev = ( DEV_CURRENT_SITE === CURRENT_HOST );
$is_local = ( LOCAL_CURRENT_HOST === CURRENT_HOST );
$wp_debug = false;
$wp_debug_log = false;
$wp_cache = true;
$is_redis_disabled = false;
if ( $is_staging ) {
$wp_debug = true;
$wp_debug_log = true;
$wp_cache = true;
} elseif ( $is_dev || $is_local ) {
$wp_debug = true;
$wp_debug_log = true;
$wp_cache = false;
}
define( 'WP_DEBUG', $wp_debug );
define( 'WP_DEBUG_LOG', $wp_debug_log );
define( 'WP_DEBUG_DISPLAY', $wp_debug_display );
define( 'WP_CACHE', $wp_cache );
define( 'WP_REDIS_DISABLED', $is_redis_disabled );

Dynamic
Conﬁg
@mikecorkum
Databases
$database_config = 'prod.php';
if ( $is_staging ) {
$database_config = 'staging.php';
} elseif ( $is_dev ) {
$database_config = 'dev.php';
} elseif ( $is_local ) {
$database_config = 'local.php';
}
require_once( $database_config );
'host' => DB_PROD_HOST,
'user' => DB_PROD_USER_NAME,
'password' => DB_PROD_USER_PASS,
'name' => DB_PROD_USER_TABLE_PASS,
'write' => 1,
'read' => 0,
));
define( 'DB_PROD_HOST', 'db.carleton.ca' );
define( 'DB_PROD_USER_NAME', 'username' );
define( 'DB_PROD_USER_PASS', 'password' );
define( 'DB_PROD_USER_TABLE', 'table_name' );

Dynamic
Conﬁg
@mikecorkum
.htaccess
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteRule ^composer.(lock|json)$ - [F,L]
RewriteRule ^composer.dev.(lock|json)$ - [F,L]
RewriteRule ^vendor/.*$ - [F,L]
RewriteBase /
RewriteRule ^index.php$ - [L]
RewriteCond %{ENV:URI} ^$
RewriteRule ^(.*)$ - [ENV=URI:$1]
RewriteCond %{ENV:BASE} ^$
RewriteCond %{ENV:URI}::%{REQUEST_URI} ^(.*)::(.*?)1$
RewriteRule ^ - [ENV=BASE:%2]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-l
RewriteRule . %{ENV:BASE}index.php [L,QSA]
</IfModule>

Update
Time
20 Seconds Per Server
@mikecorkum

Site
Manager
@mikecorkum

What’s
Next?
@mikecorkum
MOAR SYMLINKS!!!!!!!!
Simpliﬁcation of Multitenancy
Continuous Integration
Ravens Design System

�ݺ�ߣ

Case study: Carleton University – managing 600+ single installs

More Related Content

Case study: Carleton University – managing 600+ single installs