Book Image

OpenShift Cookbook

By : Shekhar Gulati
Book Image

OpenShift Cookbook

By: Shekhar Gulati

Overview of this book

Table of Contents (19 chapters)
OpenShift Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Running OpenShift on a Virtual Machine
Index

Updating the MySQL configuration settings


The MySQL database stores its configuration settings in the my.cnf file. This file is located under the conf directory inside the MySQL cartridge installation. As mentioned in the previous recipe, OpenShift does not allow users to update the my.cnf configuration file. The solution is to use a set of environment variables to configure various settings of the MySQL database.

At the time of writing this book, you could configure the following MySQL settings through the environment variables:

MySQL setting

OpenShift environment variable

lower_case_table_names

OPENSHIFT_MYSQL_LOWER_CASE_TABLE_NAMES

default-storage-engine

OPENSHIFT_MYSQL_DEFAULT_STORAGE_ENGINE

max_connections

OPENSHIFT_MYSQL_MAX_CONNECTIONS

ft_min_word_len

OPENSHIFT_MYSQL_FT_MIN_WORD_LEN

ft_max_word_len

OPENSHIFT_MYSQL_FT_MAX_WORD_LEN

innodb_use_native_aio

OPENSHIFT_MYSQL_AIO

default-time-zone

OPENSHIFT_MYSQL_TIMEZONE

table_open_cache

OPENSHIFT_MYSQL_TABLE_OPEN_CACHE...