blob: 1bbbd62cc30bd6b0c7a4451698bae72ca0111db7 [file] [log] [blame]
Sean Daguee263c822014-12-05 14:25:28 -05001#!/bin/bash
2#
Dean Troyer6d04fd72012-12-21 11:03:37 -06003# lib/databases/mysql
4# Functions to control the configuration and operation of the **MySQL** database backend
Terry Wilson428af5a2012-11-01 16:12:39 -04005
6# Dependencies:
Adam Spiers6a5aa7c2013-10-24 11:27:02 +01007#
8# - DATABASE_{HOST,USER,PASSWORD} must be defined
Terry Wilson428af5a2012-11-01 16:12:39 -04009
10# Save trace setting
Ian Wienand523f4882015-10-13 11:03:03 +110011_XTRACE_DB_MYSQL=$(set +o | grep xtrace)
Terry Wilson428af5a2012-11-01 16:12:39 -040012set +o xtrace
13
armando-migliacciob3d88222015-06-12 07:54:03 -070014MYSQL_DRIVER=${MYSQL_DRIVER:-PyMySQL}
Dean Troyercc6b4432013-04-08 15:38:03 -050015
Terry Wilson428af5a2012-11-01 16:12:39 -040016register_database mysql
17
Sean Dague53753292014-12-04 19:38:15 -050018# Linux distros, thank you for being incredibly consistent
19MYSQL=mysql
Wiekus Beukesec47bc12015-03-19 08:20:38 -070020if is_fedora && ! is_oraclelinux; then
Attila Fazekas1f316be2015-01-26 16:39:57 +010021 MYSQL=mariadb
Sean Dague53753292014-12-04 19:38:15 -050022fi
Dean Troyercc6b4432013-04-08 15:38:03 -050023
24# Functions
25# ---------
26
Julien Danjou0eec4f82015-09-08 10:45:06 +000027function get_database_type_mysql {
28 if [[ "$MYSQL_DRIVER" == "PyMySQL" ]]; then
29 echo mysql+pymysql
30 else
31 echo mysql
32 fi
33}
34
Dean Troyer995eb922013-03-07 16:11:40 -060035# Get rid of everything enough to cleanly change database backends
36function cleanup_database_mysql {
Sean Dague53753292014-12-04 19:38:15 -050037 stop_service $MYSQL
Dean Troyer995eb922013-03-07 16:11:40 -060038 if is_ubuntu; then
39 # Get ruthless with mysql
Sean Dague8f90f762015-01-14 10:36:48 -050040 apt_get purge -y mysql* mariadb*
Dean Troyer995eb922013-03-07 16:11:40 -060041 sudo rm -rf /var/lib/mysql
Tiago Mello4376ae02014-03-14 10:48:56 -030042 sudo rm -rf /etc/mysql
Dean Troyer995eb922013-03-07 16:11:40 -060043 return
Wiekus Beukesec47bc12015-03-19 08:20:38 -070044 elif is_suse || is_oraclelinux; then
45 uninstall_package mysql-community-server
46 sudo rm -rf /var/lib/mysql
Dean Troyer995eb922013-03-07 16:11:40 -060047 elif is_fedora; then
Attila Fazekas1f316be2015-01-26 16:39:57 +010048 uninstall_package mariadb-server
49 sudo rm -rf /var/lib/mysql
Dean Troyer995eb922013-03-07 16:11:40 -060050 else
51 return
52 fi
Dean Troyer995eb922013-03-07 16:11:40 -060053}
54
Terry Wilson428af5a2012-11-01 16:12:39 -040055function recreate_database_mysql {
56 local db=$1
zhhuabj2832f282013-05-08 18:43:26 +080057 mysql -u$DATABASE_USER -p$DATABASE_PASSWORD -h$MYSQL_HOST -e "DROP DATABASE IF EXISTS $db;"
Ihar Hrachyshka157c84b2014-10-06 13:29:39 +020058 mysql -u$DATABASE_USER -p$DATABASE_PASSWORD -h$MYSQL_HOST -e "CREATE DATABASE $db CHARACTER SET utf8;"
Terry Wilson428af5a2012-11-01 16:12:39 -040059}
60
61function configure_database_mysql {
Dean Troyer3ef23bc2014-07-25 14:56:22 -050062 local my_conf mysql slow_log
Terry Wilson428af5a2012-11-01 16:12:39 -040063 echo_summary "Configuring and starting MySQL"
64
Vincent Untzc18b9652012-12-04 12:36:34 +010065 if is_ubuntu; then
Dean Troyer3ef23bc2014-07-25 14:56:22 -050066 my_conf=/etc/mysql/my.cnf
67 mysql=mysql
Wiekus Beukesec47bc12015-03-19 08:20:38 -070068 elif is_suse || is_oraclelinux; then
69 my_conf=/etc/my.cnf
70 mysql=mysql
Vincent Untz00011c02012-12-06 09:56:32 +010071 elif is_fedora; then
Attila Fazekas1f316be2015-01-26 16:39:57 +010072 mysql=mariadb
Dean Troyer3ef23bc2014-07-25 14:56:22 -050073 my_conf=/etc/my.cnf
Vincent Untz00011c02012-12-06 09:56:32 +010074 else
75 exit_distro_not_supported "mysql configuration"
Terry Wilson428af5a2012-11-01 16:12:39 -040076 fi
77
78 # Start mysql-server
Vincent Untz00011c02012-12-06 09:56:32 +010079 if is_fedora || is_suse; then
80 # service is not started by default
Dean Troyer3ef23bc2014-07-25 14:56:22 -050081 start_service $mysql
Vincent Untz00011c02012-12-06 09:56:32 +010082 fi
83
84 # Set the root password - only works the first time. For Ubuntu, we already
85 # did that with debconf before installing the package.
86 if ! is_ubuntu; then
Terry Wilson428af5a2012-11-01 16:12:39 -040087 sudo mysqladmin -u root password $DATABASE_PASSWORD || true
88 fi
Vincent Untz00011c02012-12-06 09:56:32 +010089
Marian Horbanea21eb42015-08-18 06:57:18 -040090 # Update the DB to give user '$DATABASE_USER'@'%' full control of the all databases:
Terry Wilson428af5a2012-11-01 16:12:39 -040091 sudo mysql -uroot -p$DATABASE_PASSWORD -h127.0.0.1 -e "GRANT ALL PRIVILEGES ON *.* TO '$DATABASE_USER'@'%' identified by '$DATABASE_PASSWORD';"
92
93 # Now update ``my.cnf`` for some local needs and restart the mysql service
94
Marian Horbanea21eb42015-08-18 06:57:18 -040095 # Change bind-address from localhost (127.0.0.1) to any (::) and
Ralf Haferkamp0526bb82014-04-03 08:27:33 +020096 # set default db type to InnoDB
Ian Wienand9c0b9f32015-07-22 06:08:09 +100097 iniset -sudo $my_conf mysqld bind-address "$SERVICE_LISTEN_ADDRESS"
98 iniset -sudo $my_conf mysqld sql_mode STRICT_ALL_TABLES
99 iniset -sudo $my_conf mysqld default-storage-engine InnoDB
100 iniset -sudo $my_conf mysqld max_connections 1024
101 iniset -sudo $my_conf mysqld query_cache_type OFF
102 iniset -sudo $my_conf mysqld query_cache_size 0
Terry Wilson428af5a2012-11-01 16:12:39 -0400103
Jeremy Stanleyc4f47342014-01-25 01:10:31 +0000104 if [[ "$DATABASE_QUERY_LOGGING" == "True" ]]; then
105 echo_summary "Enabling MySQL query logging"
Attila Fazekas1f316be2015-01-26 16:39:57 +0100106 if is_fedora; then
Attila Fazekas3b53aeb2014-04-30 11:57:22 +0200107 slow_log=/var/log/mariadb/mariadb-slow.log
108 else
109 slow_log=/var/log/mysql/mysql-slow.log
110 fi
Ralf Haferkamp0526bb82014-04-03 08:27:33 +0200111 sudo sed -e '/log.slow.queries/d' \
112 -e '/long.query.time/d' \
113 -e '/log.queries.not.using.indexes/d' \
Dean Troyer3ef23bc2014-07-25 14:56:22 -0500114 -i $my_conf
Monty Taylor7c73e8d2013-01-07 08:17:01 +0000115
Ralf Haferkamp0526bb82014-04-03 08:27:33 +0200116 # Turn on slow query log, log all queries (any query taking longer than
117 # 0 seconds) and log all non-indexed queries
Ian Wienand9c0b9f32015-07-22 06:08:09 +1000118 iniset -sudo $my_conf mysqld slow-query-log 1
119 iniset -sudo $my_conf mysqld slow-query-log-file $slow_log
120 iniset -sudo $my_conf mysqld long-query-time 0
121 iniset -sudo $my_conf mysqld log-queries-not-using-indexes 1
Jeremy Stanleyc4f47342014-01-25 01:10:31 +0000122 fi
Monty Taylor7c73e8d2013-01-07 08:17:01 +0000123
Dean Troyer3ef23bc2014-07-25 14:56:22 -0500124 restart_service $mysql
Terry Wilson428af5a2012-11-01 16:12:39 -0400125}
126
127function install_database_mysql {
Vincent Untzc18b9652012-12-04 12:36:34 +0100128 if is_ubuntu; then
Terry Wilson428af5a2012-11-01 16:12:39 -0400129 # Seed configuration with mysql password so that apt-get install doesn't
130 # prompt us for a password upon install.
Bob Ball90333432015-01-19 10:56:42 +0000131 sudo debconf-set-selections <<MYSQL_PRESEED
132mysql-server mysql-server/root_password password $DATABASE_PASSWORD
133mysql-server mysql-server/root_password_again password $DATABASE_PASSWORD
134mysql-server mysql-server/start_on_boot boolean true
Terry Wilson428af5a2012-11-01 16:12:39 -0400135MYSQL_PRESEED
136 fi
137
138 # while ``.my.cnf`` is not needed for OpenStack to function, it is useful
139 # as it allows you to access the mysql databases via ``mysql nova`` instead
140 # of having to specify the username/password each time.
141 if [[ ! -e $HOME/.my.cnf ]]; then
142 cat <<EOF >$HOME/.my.cnf
143[client]
144user=$DATABASE_USER
145password=$DATABASE_PASSWORD
Johan Pas199d8572015-11-17 00:56:25 +0100146host=$MYSQL_HOST
Terry Wilson428af5a2012-11-01 16:12:39 -0400147EOF
148 chmod 0600 $HOME/.my.cnf
149 fi
150 # Install mysql-server
Wiekus Beukesec47bc12015-03-19 08:20:38 -0700151 if is_suse || is_oraclelinux; then
Vincent Untz623a0a52013-04-11 08:41:27 +0200152 if ! is_package_installed mariadb; then
153 install_package mysql-community-server
154 fi
Wiekus Beukesec47bc12015-03-19 08:20:38 -0700155 elif is_fedora; then
156 install_package mariadb-server
157 elif is_ubuntu; then
158 install_package mysql-server
Vincent Untzca5c4712012-11-21 17:45:49 +0100159 else
Vincent Untz00011c02012-12-06 09:56:32 +0100160 exit_distro_not_supported "mysql installation"
Vincent Untzca5c4712012-11-21 17:45:49 +0100161 fi
Dean Troyer5686dbc2015-03-09 14:27:51 -0500162}
Dean Troyerb1d8e8e2015-02-16 13:58:35 -0600163
Dean Troyer5686dbc2015-03-09 14:27:51 -0500164function install_database_python_mysql {
Dean Troyerb1d8e8e2015-02-16 13:58:35 -0600165 # Install Python client module
Sean Dague37421992015-05-20 06:37:11 -0700166 pip_install_gr $MYSQL_DRIVER
167 if [[ "$MYSQL_DRIVER" == "MySQL-python" ]]; then
168 ADDITIONAL_VENV_PACKAGES+=",MySQL-python"
Julien Danjou0f63eb32015-06-12 09:05:12 +0200169 elif [[ "$MYSQL_DRIVER" == "PyMySQL" ]]; then
170 ADDITIONAL_VENV_PACKAGES+=",PyMySQL"
Sean Dague37421992015-05-20 06:37:11 -0700171 fi
Terry Wilson428af5a2012-11-01 16:12:39 -0400172}
173
174function database_connection_url_mysql {
Attila Fazekas7e79d912013-03-03 12:23:04 +0100175 local db=$1
176 echo "$BASE_SQL_CONN/$db?charset=utf8"
Terry Wilson428af5a2012-11-01 16:12:39 -0400177}
178
Dean Troyercc6b4432013-04-08 15:38:03 -0500179
Terry Wilson428af5a2012-11-01 16:12:39 -0400180# Restore xtrace
Ian Wienand523f4882015-10-13 11:03:03 +1100181$_XTRACE_DB_MYSQL
Sean Dague584d90e2013-03-29 14:34:53 -0400182
183# Local variables:
184# mode: shell-script
185# End: