blob: 7eb0a40754dcf2fafd453cca730f292b95ee09a4 [file] [log] [blame]
#
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements. See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License. You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
# Overrides the mysql defaults in /etc/mysql/my.cnf
# Reference from https://github.com/mozilla/treeherder/blob/master/vagrant/mysql.cnf
[mysqld]
character_set_server="utf8"
collation_server="utf8_bin"
# Ensure operations involving astral characters fail loudly,
# rather than mysql silently replacing each byte of the
# original character with a U+FFFD replacement character.
# See bug 1275425.
sql_mode="NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES"
# Django advises using READ-COMMITTED instead of REPEATABLE-READ:
# https://docs.djangoproject.com/en/1.10/ref/models/querysets/#get-or-create
# Unhelpfully MySQL uses a different (undocumented) variable name if set via config file:
# https://bugs.mysql.com/bug.php?id=70008
transaction-isolation=READ-COMMITTED
# Travis only: Speed up I/O by reducing data-loss protection.
innodb_flush_log_at_trx_commit="0"