4. Using MySQL with OpenShift Applications | OPENSHIFT COOKBOOK

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

OPENSHIFT COOKBOOK

By : Gulati

3.8 (6)

OPENSHIFT COOKBOOK

3.8 (6)

By: Gulati

Overview of this book

If you are a web application developer who wants to use the OpenShift platform to host your next big idea but are looking for guidance on how to achieve this, then this book is the first step you need to take. This is a very accessible cookbook where no previous knowledge of OpenShift is needed.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Getting Started with OpenShift

1. Getting Started with OpenShift

A brief introduction into OpenShift

Creating an OpenShift Online account

Creating OpenShift domains using the web console

Creating a WordPress application using the web console

Uploading SSH keys using the web console

Working with the SSH key passphrases

Cloning the application to the local machine

Deploying your first change

Checking the application's gear quota and limits

Installing the OpenShift rhc command-line client

Setting up an OpenShift account using rhc

Enabling the autocomplete feature in an rhc command-line client

Viewing the account details using rhc

Specifying a different OpenShift server hostname

Updating rhc

2. Managing Domains

2. Managing Domains

Introduction

Creating a domain using rhc

Renaming a domain using rhc

Viewing domain details using rhc

Adding viewer members to a domain using rhc

Adding an editor member to a domain using rhc

Adding an admin member to a domain using rhc

Viewing all the members in a domain using rhc

Removing members from a domain using rhc

Restricting gear sizes for a domain using rhc

Leaving a domain using rhc

Deleting a domain using rhc

3. Creating and Managing Applications

3. Creating and Managing Applications

Introduction

Creating an OpenShift application using the rhc command-line client

Specifying your own template Git repository URL

Starting/stopping/restarting an application

Adding and managing add-on cartridges

Adding a cron cartridge to an application

Using downloadable cartridges with OpenShift applications

Viewing application details

Cloning the application Git repository using rhc

SSH into the application gear using rhc

Running a command in the application's SSH session using rhc

Setting application-specific environment variables

Taking and restoring application backups

Tracking and rolling back application deployments

Configuring the default Git branch for deployment

Doing manual deployments

Configuring and doing binary deployments

Using your own custom domain name

Cleaning up the application

Deleting the application

4. Using MySQL with OpenShift Applications

4. Using MySQL with OpenShift Applications

Introduction

Adding a MySQL cartridge to your application

Adding a phpMyAdmin cartridge to your application

Accessing a MySQL database from your local machine

Connecting to a MySQL cartridge from your local machine using MySQL Workbench

Updating the MySQL max connections setting

Updating the MySQL configuration settings

Performing scheduled MySQL database backups

Using an Amazon RDS MySQL DB instance with OpenShift

5. Using PostgreSQL with OpenShift Applications

5. Using PostgreSQL with OpenShift Applications

Introduction

Adding the PostgreSQL cartridge to your application

Accessing the PostgreSQL cartridge from your local machine

Connecting to the PostgreSQL cartridge using pgAdmin from your local machine

Updating the PostgreSQL max_connections setting

Using the .psqlrc configuration file to configure the OpenShift application psql shell

Performing scheduled PostgreSQL database backups

Using EnterpriseDB PostgreSQL Cloud Database with OpenShift

Installing PostgreSQL extensions

6. Using MongoDB and Third-party Database Cartridges with OpenShift Applications

6. Using MongoDB and Third-party Database Cartridges with OpenShift Applications

Introduction

Adding a MongoDB cartridge to your application

Adding a RockMongo cartridge to your application

Accessing a MongoDB cartridge from your local machine

Connecting to a MongoDB cartridge using Robomongo from your local machine

Enabling the MongoDB cartridge REST interface

Performing scheduled MongoDB database backups

Using MongoLab MongoDB-as-a-Service with OpenShift

Adding a MariaDB cartridge to your application

Adding a Redis cartridge to your application

7. OpenShift for Java Developers

7. OpenShift for Java Developers

Introduction

Creating and deploying Java EE 6 applications using the JBoss EAP and PostgreSQL 9.2 cartridges

Configuring application security by defining the database login module in standalone.xml

Installing modules with JBoss cartridges

Managing JBoss cartridges using the management web interface and CLI

Creating and deploying Spring applications using the Tomcat 7 cartridge

Taking thread dumps of Java cartridges

Choosing between Java 6 and Java 7

Enabling hot deployment for Java applications

Skipping the Maven build

Forcing a clean Maven build

Overriding the default Maven build command

Installing the JAR file not present in the Maven central repository

Developing OpenShift Java applications using Eclipse

Using Eclipse System Explorer to SSH into the application gear

Debugging Java applications in the Cloud

8. OpenShift for Python Developers

8. OpenShift for Python Developers

Introduction

Creating your first Python application

Managing Python application dependencies

Creating and deploying Flask web applications using Python and PostgreSQL cartridges

Enabling hot deployment for Python applications

Forcing a clean Python virtual environment

Accessing an application's Python virtual environment

Using Gevent with Python applications

Installing a custom Python package

Using the .htaccess file to configure Apache

9. OpenShift for Node.js Developers

9. OpenShift for Node.js Developers

Introduction

Creating your first Node.js application

Configuring Node supervisor options

Managing Node.js application dependencies

Using the use_npm marker

Enabling hot deployment for Node.js applications

Creating and deploying Express web applications using Node.js and MongoDB cartridges

Working with Web Sockets

Using CoffeeScript with OpenShift Node.js applications

10. Continuous Integration for OpenShift Applications

10. Continuous Integration for OpenShift Applications

Introduction

Adding Jenkins CI to your application

Increasing the slave idle timeout

Installing Jenkins plugins

Using Jenkins to build projects hosted on GitHub

Creating a Jenkins workflow for your OpenShift applications

Upgrading Jenkins to the latest version

11. Logging and Scaling Your OpenShift Applications

11. Logging and Scaling Your OpenShift Applications

Introduction

Viewing application logs

Working with JBoss application logs

Enabling JBoss access logs

Working with Tomcat application logs

Working with Python application logs

Creating scalable applications

Configuring a different health check URL for HAProxy

Configuring HAProxy to use a different balance algorithm

Creating scalable apps from nonscalable apps

Enabling manual scaling with marker files

A. Running OpenShift on a Virtual Machine

A. Running OpenShift on a Virtual Machine

Index

Index

Customer Reviews

3.8 (6)

5 star

33.3%

4 star

50%

3 star

0

2 star

0

1 star

16.7%

Updating the MySQL max connections setting

The MySQL database will start giving too many connection errors when all the available connections are in use by other clients. In this recipe, you will learn how to update the MySQL cartridge max connections setting.

Getting ready

To complete this recipe, you will need an application with a MySQL cartridge. Please refer to the Adding a MySQL cartridge to your application recipe of this chapter to learn how to install the MySQL cartridge.

How to do it…

Follow these steps to update the MySQL max connection setting:

To set the maximum connections to 200, open a command-line terminal, and run the following command:
```
$ rhc env-set OPENSHIFT_MYSQL_MAX_CONNECTIONS=200 --app myapp
```
After setting the environment variable, you have to restart the MySQL cartridge for changes to take effect using the following command:
```
$ rhc cartridge-restart mysql --app myapp
```

How it works…

The number of connections supported by the MySQL database is controlled by the max_connections...

Search

Your notes and bookmarks