9. Using and Administrating Heroku Postgres | Heroku Cookbook

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Heroku Cookbook

By : Coutermarsh

4.8 (4)

Heroku Cookbook

4.8 (4)

By: Coutermarsh

Overview of this book

Heroku is a Platform as a Service that enables developers to rapidly deploy and scale their web applications. Heroku is designed for developer happiness, freeing developers from doing system administrative tasks such as configuring servers and setting up load balancers. Developers are able to focus on what they do best, building web applications, while leaving the details of deployment and scaling to the experts at Heroku. This practical guide is packed with step-by-step solutions to problems faced by every production-level web application hosted on Heroku. You'll quickly get comfortable with managing your Heroku applications from the command line and then learn everything you need to know to deploy and administer production-level web applications.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Sections

Conventions

Reader feedback

Customer support

Free Chapter

1. Getting Started with Heroku

1. Getting Started with Heroku

Introduction

Installing the Heroku Toolbelt

Introducing version control with Git

Deploying a Rails application to Heroku

Deploying a Node.js application to Heroku

Introducing dynos, workers, and scaling

2. Managing Heroku from the Command Line

2. Managing Heroku from the Command Line

Introduction

Viewing application logs

Searching logs

Installing add-ons

Managing environment variables

Enabling the maintenance page

Managing releases and rolling back

Running one-off tasks and dynos

Managing SSH keys

Sharing and collaboration

Monitoring load average and memory usage

3. Setting Up a Staging Environment

3. Setting Up a Staging Environment

Introduction

Duplicating an existing application

Managing git remotes

Password protection for a Rails app

Deploying with Heroku labs – Pipeline

Deploying from tags

Continuous integration and deployment with Travis CI

4. Production-ready with Heroku

4. Production-ready with Heroku

Introduction

Managing domains from the command line

Configuring DNS with CloudFlare

Setting up SSL with CloudFlare

Enabling preboot for seamless deploys

Enabling custom maintenance and error pages

Setting up a status page

Setting up log draining with LogEntries

5. Error Monitoring and Logging Tools

5. Error Monitoring and Logging Tools

Introduction

Checking Heroku's status

Adjusting Rails's logging level

Storing historical logs with PaperTrail

Monitoring for 404 and 500 errors with PaperTrail

Logging slow queries with PaperTrail

Monitoring uptime with Pingdom

Logging errors with Rollbar

6. Load Testing a Heroku Application

6. Load Testing a Heroku Application

Introduction

Monitoring dyno performance with Librato

Monitoring application performance with New Relic

Learning to load test with Siege

Configuring complex load tests with Siege

Load testing from the cloud with Blitz.io

Testing real-user scenarios with Load Impact

7. Optimizing Ruby Server Performance on Heroku

7. Optimizing Ruby Server Performance on Heroku

Introduction

Setting up and running Unicorn on Heroku

Monitoring and tuning Unicorn's memory usage

Tuning Unicorn's backlog for Heroku

Timing out long requests with Unicorn

Setting up and running Puma on Heroku

Running Puma with Rubinius for parallelism

8. Optimizing a Rails Application on Heroku

8. Optimizing a Rails Application on Heroku

Introduction

Setting up a sample blogging app

Using Heroku Deflater to gzip assets

Serving assets from Amazon Web Services (AWS) Cloudfront

Adding memcached to a Rails application

Adding Redis to a Rails application

Implementing low-level caching in Rails

Caching rendered views

Aborting long requests with Rack::Timeout

Using a follower for read-only DB queries

9. Using and Administrating Heroku Postgres

9. Using and Administrating Heroku Postgres

Introduction

Creating and sizing a new database

Promoting a Heroku database

Connecting to Heroku Postgres from Navicat

Connecting to Heroku Postgres from psql

Creating a database backup

Restoring from a backup

Creating a read-only follower

Viewing and stopping database processes

Analyzing Heroku Postgres's performance

10. The Heroku Platform API

10. The Heroku Platform API

Introduction

Making our first API request with HTTPie

Getting started with the Platform API gem

Scaling dynos and workers

Managing configuration variables

Adding and removing collaborators

Creating new Heroku applications

Index

Index

Connecting to Heroku Postgres from psql

Psql is the terminal application that ships with Postgres. It enables us to run queries and administer our Postgres databases from the command line. With Heroku, you can either use the Heroku CLI to start up a psql session or you can connect to your database using only psql. In this recipe, you'll be introduced to both methods.

How to do it…

To start, let's open up a terminal:

We can quickly start up a psql session through the Heroku CLI by running the pg:psql command:
```
$ heroku pg:psql
```
Note
To exit the psql session, type \q and hit Enter or press Ctrl + D.
By default, it will connect to the database in our DATABASE_URL config variable. If we want to connect to a different database, we need to specify the name:
```
$ heroku pg:psql ORANGE
```
We don't have to use the Heroku CLI to connect to our database. If we'd like, we can use plain psql from the command line. We can get our credentials from the DATABASE_URL configuration variable, and then pass them to the psql...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Heroku Cookbook

Search

Your notes and bookmarks