Wordpress + Heroku + PostgreSQL + Amazon S3 = ¥0 / 無料でサイト運営

1
2
$ git clone git://github.com/mhoofman/wordpress-heroku.git
$ mv wordpress-heroku my-wordpress

1
2
3
4
5
6
7
$ sudo -u postgres psql
DB作成
postgres=# create database my-wordpress owner yourname;
確認
postgres=# \l
終了
postgres=# \q

1
2
3
4
5
6
7
8
9
10
11
12
13
14
Apache設定ファイルの編集
$ sudo vi /etc/httpd/conf/httpd.conf

↓

<VirtualHost *:80>
    ServerName     dev.yoursite.com
    DocumentRoot   "/var/www/html/my-wordpress"
    setEnv WP_ENV development #必要だったら
    setEnv WP_DB_URL xxxxxxxxxxxxxxxxxxxxxxxxxx
    setEnv WP_DB_NAME xxxxxxxxx
    setEnv WP_DB_USER xxxxxxxxx
    setEnv WP_DB_PASSWORD xxxxxxxxx
</VirtualHost>

1
2
$ service httpd start
$ service httpd restart 起動してたら再起動

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
<?php

// ** Heroku Postgres settings - from Heroku Environment ** //
$db = parse_url(getenv('WP_DB_NAME'));

/** MySQL database username */
define('DB_USER', getenv('WP_DB_USER'));

/** MySQL database password */
define('DB_PASSWORD', getenv('WP_DB_PASSWORD'));

/** MySQL hostname */
define('DB_HOST', getenv('WP_DB_HOST'));

?>

1
2
3
4
5
6
7
8
define('AUTH_KEY',         'xxxxxx');
define('SECURE_AUTH_KEY',  'xxxxxxxx');
define('LOGGED_IN_KEY',    'xxxxxxxx');
define('NONCE_KEY',        'xxxxxxxx');
define('AUTH_SALT',        'xxxxxxxx');
define('SECURE_AUTH_SALT', 'xxxxxxxx');
define('LOGGED_IN_SALT',   'xxxxxxxx');
define('NONCE_SALT',       'xxxxxxxx');

1
2
3
4
5
6
7
8
9
10
11
12
13
<?php
if ( getenv('WP_ENV') === "development" ) {

    define('WP_HOME','http://dev.your_site.com');
    define('WP_SITEURL','http://dev.your_site.com');

} elseif ( getenv('WP_ENV') === "production" ) {

    define('WP_HOME','http://your_site.com');
    define('WP_SITEURL','http://your_site.com');

}
?>

1
2
3
4
5
6
<?php
  if (preg_match('/localhost/', getenv('WP_DB_NAME'))) {
    preg_match('/(.*)\/wp-.*\/(\w*\.php)+$/', $_SERVER['REQUEST_URI'], $path);
    return ("http://" . $_SERVER['HTTP_HOST'] . $path[1]);
  }
?>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<select name="wpro-aws-endpoint" id="wpro-aws-endpoint">
<?php
    $aws_regions = array(
        's3.amazonaws.com' => 'US East Region (Standard)',
        's3-us-west-2.amazonaws.com' => 'US West (Oregon) Region',
        's3-us-west-1.amazonaws.com' => 'US West (Northern California) Region',
        's3-eu-west-1.amazonaws.com' => 'EU (Ireland) Region',
        's3-ap-southeast-1.amazonaws.com' => 'Asia Pacific (Singapore) Region',
        's3-ap-southeast-2.amazonaws.com' => 'Asia Pacific (Sydney) Region', //追加した
        's3-ap-northeast-1.amazonaws.com' => 'Asia Pacific (Tokyo) Region',
        's3-sa-east-1.amazonaws.com' => 'South America (Sao Paulo) Region'
    );
    // Endpoints comes from http://docs.amazonwebservices.com/general/latest/gr/rande.html

    foreach ($aws_regions as $endpoint => $endpoint_name) {
        echo ('<option value="' . $endpoint . '"');
        if ($endpoint == get_option('wpro-aws-endpoint')) {
            echo(' selected="selected"');
        }
        echo ('>' . $endpoint_name . '</option>');
    }
?>
</select> 

1
2
3
4
5
$ heroku config:set WP_DB_URL=xxxxxxx
$ heroku config:set WP_DB_NAME=xxxxxxx
$ heroku config:set WP_DB_USER=xxxxxxx
$ heroku config:set WP_DB_PASSWORD=xxxxxxx
$ heroku config:set WP_DB_HOST=xxxxxxx

1
2
3
4
$ heroku config
↓
SENDGRID_PASSWORD:           xxxxxxxx
SENDGRID_USERNAME:           [email protected]

1
2
3
4
5
6
7
{
  "require": {
    "php": "~5.6.0",
    "ext-gd": "*",
    "ext-mbstring": "*"
  }
}

1
$ git push heroku master