blob: 72c0f82b4aec70e070340d8396fd75e089a7d294 [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
Dean Troyer41bf4522013-01-28 14:04:39 -060011MY_XTRACE=$(set +o | grep xtrace)
Terry Wilson428af5a2012-11-01 16:12:39 -040012set +o xtrace
13
Dean Troyercc6b4432013-04-08 15:38:03 -050014
Terry Wilson428af5a2012-11-01 16:12:39 -040015register_database mysql
16
Sean Dague53753292014-12-04 19:38:15 -050017# Linux distros, thank you for being incredibly consistent
18MYSQL=mysql
19if is_fedora; then
Attila Fazekas1f316be2015-01-26 16:39:57 +010020 MYSQL=mariadb
Sean Dague53753292014-12-04 19:38:15 -050021fi
Dean Troyercc6b4432013-04-08 15:38:03 -050022
23# Functions
24# ---------
25
Dean Troyer995eb922013-03-07 16:11:40 -060026# Get rid of everything enough to cleanly change database backends
27function cleanup_database_mysql {
Sean Dague53753292014-12-04 19:38:15 -050028 stop_service $MYSQL
Dean Troyer995eb922013-03-07 16:11:40 -060029 if is_ubuntu; then
30 # Get ruthless with mysql
31 stop_service $MYSQL
Sean Dague8f90f762015-01-14 10:36:48 -050032 apt_get purge -y mysql* mariadb*
Dean Troyer995eb922013-03-07 16:11:40 -060033 sudo rm -rf /var/lib/mysql
Tiago Mello4376ae02014-03-14 10:48:56 -030034 sudo rm -rf /etc/mysql
Dean Troyer995eb922013-03-07 16:11:40 -060035 return
36 elif is_fedora; then
Attila Fazekas1f316be2015-01-26 16:39:57 +010037 stop_service mariadb
38 uninstall_package mariadb-server
39 sudo rm -rf /var/lib/mysql
Dean Troyer995eb922013-03-07 16:11:40 -060040 elif is_suse; then
Sean Dague1cbb5d32014-12-15 14:57:15 -050041 stop_service mysql
42 uninstall_package mysql-community-server
43 sudo rm -rf /var/lib/mysql
Dean Troyer995eb922013-03-07 16:11:40 -060044 else
45 return
46 fi
Dean Troyer995eb922013-03-07 16:11:40 -060047}
48
Terry Wilson428af5a2012-11-01 16:12:39 -040049function recreate_database_mysql {
50 local db=$1
zhhuabj2832f282013-05-08 18:43:26 +080051 mysql -u$DATABASE_USER -p$DATABASE_PASSWORD -h$MYSQL_HOST -e "DROP DATABASE IF EXISTS $db;"
Ihar Hrachyshka157c84b2014-10-06 13:29:39 +020052 mysql -u$DATABASE_USER -p$DATABASE_PASSWORD -h$MYSQL_HOST -e "CREATE DATABASE $db CHARACTER SET utf8;"
Terry Wilson428af5a2012-11-01 16:12:39 -040053}
54
55function configure_database_mysql {
Dean Troyer3ef23bc2014-07-25 14:56:22 -050056 local my_conf mysql slow_log
Terry Wilson428af5a2012-11-01 16:12:39 -040057 echo_summary "Configuring and starting MySQL"
58
Vincent Untzc18b9652012-12-04 12:36:34 +010059 if is_ubuntu; then
Dean Troyer3ef23bc2014-07-25 14:56:22 -050060 my_conf=/etc/mysql/my.cnf
61 mysql=mysql
Vincent Untz00011c02012-12-06 09:56:32 +010062 elif is_fedora; then
Attila Fazekas1f316be2015-01-26 16:39:57 +010063 mysql=mariadb
Dean Troyer3ef23bc2014-07-25 14:56:22 -050064 my_conf=/etc/my.cnf
Vincent Untz00011c02012-12-06 09:56:32 +010065 elif is_suse; then
Dean Troyer3ef23bc2014-07-25 14:56:22 -050066 my_conf=/etc/my.cnf
67 mysql=mysql
Vincent Untz00011c02012-12-06 09:56:32 +010068 else
69 exit_distro_not_supported "mysql configuration"
Terry Wilson428af5a2012-11-01 16:12:39 -040070 fi
71
72 # Start mysql-server
Vincent Untz00011c02012-12-06 09:56:32 +010073 if is_fedora || is_suse; then
74 # service is not started by default
Dean Troyer3ef23bc2014-07-25 14:56:22 -050075 start_service $mysql
Vincent Untz00011c02012-12-06 09:56:32 +010076 fi
77
78 # Set the root password - only works the first time. For Ubuntu, we already
79 # did that with debconf before installing the package.
80 if ! is_ubuntu; then
Terry Wilson428af5a2012-11-01 16:12:39 -040081 sudo mysqladmin -u root password $DATABASE_PASSWORD || true
82 fi
Vincent Untz00011c02012-12-06 09:56:32 +010083
Terry Wilson428af5a2012-11-01 16:12:39 -040084 # Update the DB to give user ‘$DATABASE_USER’@’%’ full control of the all databases:
85 sudo mysql -uroot -p$DATABASE_PASSWORD -h127.0.0.1 -e "GRANT ALL PRIVILEGES ON *.* TO '$DATABASE_USER'@'%' identified by '$DATABASE_PASSWORD';"
86
87 # Now update ``my.cnf`` for some local needs and restart the mysql service
88
Ralf Haferkamp0526bb82014-04-03 08:27:33 +020089 # Change ‘bind-address’ from localhost (127.0.0.1) to any (0.0.0.0) and
90 # set default db type to InnoDB
91 sudo bash -c "source $TOP_DIR/functions && \
Dean Troyer3ef23bc2014-07-25 14:56:22 -050092 iniset $my_conf mysqld bind-address 0.0.0.0 && \
93 iniset $my_conf mysqld sql_mode STRICT_ALL_TABLES && \
94 iniset $my_conf mysqld default-storage-engine InnoDB"
Terry Wilson428af5a2012-11-01 16:12:39 -040095
Terry Wilson428af5a2012-11-01 16:12:39 -040096
Jeremy Stanleyc4f47342014-01-25 01:10:31 +000097 if [[ "$DATABASE_QUERY_LOGGING" == "True" ]]; then
98 echo_summary "Enabling MySQL query logging"
Attila Fazekas1f316be2015-01-26 16:39:57 +010099 if is_fedora; then
Attila Fazekas3b53aeb2014-04-30 11:57:22 +0200100 slow_log=/var/log/mariadb/mariadb-slow.log
101 else
102 slow_log=/var/log/mysql/mysql-slow.log
103 fi
Ralf Haferkamp0526bb82014-04-03 08:27:33 +0200104 sudo sed -e '/log.slow.queries/d' \
105 -e '/long.query.time/d' \
106 -e '/log.queries.not.using.indexes/d' \
Dean Troyer3ef23bc2014-07-25 14:56:22 -0500107 -i $my_conf
Monty Taylor7c73e8d2013-01-07 08:17:01 +0000108
Ralf Haferkamp0526bb82014-04-03 08:27:33 +0200109 # Turn on slow query log, log all queries (any query taking longer than
110 # 0 seconds) and log all non-indexed queries
111 sudo bash -c "source $TOP_DIR/functions && \
Dean Troyer3ef23bc2014-07-25 14:56:22 -0500112 iniset $my_conf mysqld slow-query-log 1 && \
113 iniset $my_conf mysqld slow-query-log-file $slow_log && \
114 iniset $my_conf mysqld long-query-time 0 && \
115 iniset $my_conf mysqld log-queries-not-using-indexes 1"
Jeremy Stanleyc4f47342014-01-25 01:10:31 +0000116
117 fi
Monty Taylor7c73e8d2013-01-07 08:17:01 +0000118
Dean Troyer3ef23bc2014-07-25 14:56:22 -0500119 restart_service $mysql
Terry Wilson428af5a2012-11-01 16:12:39 -0400120}
121
122function install_database_mysql {
Vincent Untzc18b9652012-12-04 12:36:34 +0100123 if is_ubuntu; then
Terry Wilson428af5a2012-11-01 16:12:39 -0400124 # Seed configuration with mysql password so that apt-get install doesn't
125 # prompt us for a password upon install.
Bob Ball90333432015-01-19 10:56:42 +0000126 sudo debconf-set-selections <<MYSQL_PRESEED
127mysql-server mysql-server/root_password password $DATABASE_PASSWORD
128mysql-server mysql-server/root_password_again password $DATABASE_PASSWORD
129mysql-server mysql-server/start_on_boot boolean true
Terry Wilson428af5a2012-11-01 16:12:39 -0400130MYSQL_PRESEED
131 fi
132
133 # while ``.my.cnf`` is not needed for OpenStack to function, it is useful
134 # as it allows you to access the mysql databases via ``mysql nova`` instead
135 # of having to specify the username/password each time.
136 if [[ ! -e $HOME/.my.cnf ]]; then
137 cat <<EOF >$HOME/.my.cnf
138[client]
139user=$DATABASE_USER
140password=$DATABASE_PASSWORD
141host=$DATABASE_HOST
142EOF
143 chmod 0600 $HOME/.my.cnf
144 fi
145 # Install mysql-server
pcrews6de7dba2014-11-18 20:50:00 -0800146 if is_fedora; then
Attila Fazekas1f316be2015-01-26 16:39:57 +0100147 install_package mariadb-server
pcrews6de7dba2014-11-18 20:50:00 -0800148 elif is_ubuntu; then
149 install_package mysql-server
Vincent Untz00011c02012-12-06 09:56:32 +0100150 elif is_suse; then
Vincent Untz623a0a52013-04-11 08:41:27 +0200151 if ! is_package_installed mariadb; then
152 install_package mysql-community-server
153 fi
Vincent Untzca5c4712012-11-21 17:45:49 +0100154 else
Vincent Untz00011c02012-12-06 09:56:32 +0100155 exit_distro_not_supported "mysql installation"
Vincent Untzca5c4712012-11-21 17:45:49 +0100156 fi
Terry Wilson428af5a2012-11-01 16:12:39 -0400157}
158
159function database_connection_url_mysql {
Attila Fazekas7e79d912013-03-03 12:23:04 +0100160 local db=$1
161 echo "$BASE_SQL_CONN/$db?charset=utf8"
Terry Wilson428af5a2012-11-01 16:12:39 -0400162}
163
Dean Troyercc6b4432013-04-08 15:38:03 -0500164
Terry Wilson428af5a2012-11-01 16:12:39 -0400165# Restore xtrace
Dean Troyer41bf4522013-01-28 14:04:39 -0600166$MY_XTRACE
Sean Dague584d90e2013-03-29 14:34:53 -0400167
168# Local variables:
169# mode: shell-script
170# End: