blob: 7a0145ae1b7436121302a98325a02fe5d9b66f17 [file] [log] [blame]
Dean Troyer6d04fd72012-12-21 11:03:37 -06001# lib/databases/mysql
2# Functions to control the configuration and operation of the **MySQL** database backend
Terry Wilson428af5a2012-11-01 16:12:39 -04003
4# Dependencies:
Adam Spiers6a5aa7c2013-10-24 11:27:02 +01005#
6# - DATABASE_{HOST,USER,PASSWORD} must be defined
Terry Wilson428af5a2012-11-01 16:12:39 -04007
8# Save trace setting
Dean Troyer41bf4522013-01-28 14:04:39 -06009MY_XTRACE=$(set +o | grep xtrace)
Terry Wilson428af5a2012-11-01 16:12:39 -040010set +o xtrace
11
Dean Troyercc6b4432013-04-08 15:38:03 -050012
Terry Wilson428af5a2012-11-01 16:12:39 -040013register_database mysql
14
Dean Troyercc6b4432013-04-08 15:38:03 -050015
16# Functions
17# ---------
18
Dean Troyer995eb922013-03-07 16:11:40 -060019# Get rid of everything enough to cleanly change database backends
20function cleanup_database_mysql {
21 if is_ubuntu; then
22 # Get ruthless with mysql
23 stop_service $MYSQL
Sahid Orentino Ferdjaouie9648272014-02-23 18:55:51 +010024 apt_get purge -y mysql*
Dean Troyer995eb922013-03-07 16:11:40 -060025 sudo rm -rf /var/lib/mysql
Tiago Mello4376ae02014-03-14 10:48:56 -030026 sudo rm -rf /etc/mysql
Dean Troyer995eb922013-03-07 16:11:40 -060027 return
28 elif is_fedora; then
Attila Fazekas2d650592014-02-20 15:49:13 +010029 if [[ $DISTRO =~ (rhel7) ]]; then
30 MYSQL=mariadb
31 else
32 MYSQL=mysqld
33 fi
Dean Troyer995eb922013-03-07 16:11:40 -060034 elif is_suse; then
35 MYSQL=mysql
36 else
37 return
38 fi
39 stop_service $MYSQL
40}
41
Terry Wilson428af5a2012-11-01 16:12:39 -040042function recreate_database_mysql {
43 local db=$1
44 local charset=$2
zhhuabj2832f282013-05-08 18:43:26 +080045 mysql -u$DATABASE_USER -p$DATABASE_PASSWORD -h$MYSQL_HOST -e "DROP DATABASE IF EXISTS $db;"
46 mysql -u$DATABASE_USER -p$DATABASE_PASSWORD -h$MYSQL_HOST -e "CREATE DATABASE $db CHARACTER SET $charset;"
Terry Wilson428af5a2012-11-01 16:12:39 -040047}
48
49function configure_database_mysql {
50 echo_summary "Configuring and starting MySQL"
51
Vincent Untzc18b9652012-12-04 12:36:34 +010052 if is_ubuntu; then
Terry Wilson428af5a2012-11-01 16:12:39 -040053 MY_CONF=/etc/mysql/my.cnf
54 MYSQL=mysql
Vincent Untz00011c02012-12-06 09:56:32 +010055 elif is_fedora; then
Attila Fazekas2d650592014-02-20 15:49:13 +010056 if [[ $DISTRO =~ (rhel7) ]]; then
57 MYSQL=mariadb
58 else
59 MYSQL=mysqld
60 fi
Terry Wilson428af5a2012-11-01 16:12:39 -040061 MY_CONF=/etc/my.cnf
Vincent Untz00011c02012-12-06 09:56:32 +010062 elif is_suse; then
63 MY_CONF=/etc/my.cnf
64 MYSQL=mysql
65 else
66 exit_distro_not_supported "mysql configuration"
Terry Wilson428af5a2012-11-01 16:12:39 -040067 fi
68
69 # Start mysql-server
Vincent Untz00011c02012-12-06 09:56:32 +010070 if is_fedora || is_suse; then
71 # service is not started by default
Terry Wilson428af5a2012-11-01 16:12:39 -040072 start_service $MYSQL
Vincent Untz00011c02012-12-06 09:56:32 +010073 fi
74
75 # Set the root password - only works the first time. For Ubuntu, we already
76 # did that with debconf before installing the package.
77 if ! is_ubuntu; then
Terry Wilson428af5a2012-11-01 16:12:39 -040078 sudo mysqladmin -u root password $DATABASE_PASSWORD || true
79 fi
Vincent Untz00011c02012-12-06 09:56:32 +010080
Terry Wilson428af5a2012-11-01 16:12:39 -040081 # Update the DB to give user ‘$DATABASE_USER’@’%’ full control of the all databases:
82 sudo mysql -uroot -p$DATABASE_PASSWORD -h127.0.0.1 -e "GRANT ALL PRIVILEGES ON *.* TO '$DATABASE_USER'@'%' identified by '$DATABASE_PASSWORD';"
83
84 # Now update ``my.cnf`` for some local needs and restart the mysql service
85
86 # Change ‘bind-address’ from localhost (127.0.0.1) to any (0.0.0.0)
87 sudo sed -i '/^bind-address/s/127.0.0.1/0.0.0.0/g' $MY_CONF
88
89 # Set default db type to InnoDB
90 if sudo grep -q "default-storage-engine" $MY_CONF; then
91 # Change it
92 sudo bash -c "source $TOP_DIR/functions; iniset $MY_CONF mysqld default-storage-engine InnoDB"
93 else
94 # Add it
95 sudo sed -i -e "/^\[mysqld\]/ a \
96default-storage-engine = InnoDB" $MY_CONF
97 fi
98
Jeremy Stanleyc4f47342014-01-25 01:10:31 +000099 if [[ "$DATABASE_QUERY_LOGGING" == "True" ]]; then
100 echo_summary "Enabling MySQL query logging"
Monty Taylor7c73e8d2013-01-07 08:17:01 +0000101
Jeremy Stanleyc4f47342014-01-25 01:10:31 +0000102 # Turn on slow query log
103 sudo sed -i '/log.slow.queries/d' $MY_CONF
104 sudo sed -i -e "/^\[mysqld\]/ a \
105 log-slow-queries = /var/log/mysql/mysql-slow.log" $MY_CONF
Monty Taylor7c73e8d2013-01-07 08:17:01 +0000106
Jeremy Stanleyc4f47342014-01-25 01:10:31 +0000107 # Log all queries (any query taking longer than 0 seconds)
108 sudo sed -i '/long.query.time/d' $MY_CONF
109 sudo sed -i -e "/^\[mysqld\]/ a \
110 long-query-time = 0" $MY_CONF
111
112 # Log all non-indexed queries
113 sudo sed -i '/log.queries.not.using.indexes/d' $MY_CONF
114 sudo sed -i -e "/^\[mysqld\]/ a \
115 log-queries-not-using-indexes" $MY_CONF
116
117 fi
Monty Taylor7c73e8d2013-01-07 08:17:01 +0000118
Terry Wilson428af5a2012-11-01 16:12:39 -0400119 restart_service $MYSQL
120}
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.
126 cat <<MYSQL_PRESEED | sudo debconf-set-selections
127mysql-server-5.1 mysql-server/root_password password $DATABASE_PASSWORD
128mysql-server-5.1 mysql-server/root_password_again password $DATABASE_PASSWORD
129mysql-server-5.1 mysql-server/start_on_boot boolean true
130MYSQL_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
Vincent Untz00011c02012-12-06 09:56:32 +0100146 if is_ubuntu || is_fedora; then
Attila Fazekas2d650592014-02-20 15:49:13 +0100147 if [[ $DISTRO =~ (rhel7) ]]; then
148 install_package mariadb-server
149 else
150 install_package mysql-server
151 fi
Vincent Untz00011c02012-12-06 09:56:32 +0100152 elif is_suse; then
Vincent Untz623a0a52013-04-11 08:41:27 +0200153 if ! is_package_installed mariadb; then
154 install_package mysql-community-server
155 fi
Vincent Untzca5c4712012-11-21 17:45:49 +0100156 else
Vincent Untz00011c02012-12-06 09:56:32 +0100157 exit_distro_not_supported "mysql installation"
Vincent Untzca5c4712012-11-21 17:45:49 +0100158 fi
Terry Wilson428af5a2012-11-01 16:12:39 -0400159}
160
161function database_connection_url_mysql {
Attila Fazekas7e79d912013-03-03 12:23:04 +0100162 local db=$1
163 echo "$BASE_SQL_CONN/$db?charset=utf8"
Terry Wilson428af5a2012-11-01 16:12:39 -0400164}
165
Dean Troyercc6b4432013-04-08 15:38:03 -0500166
Terry Wilson428af5a2012-11-01 16:12:39 -0400167# Restore xtrace
Dean Troyer41bf4522013-01-28 14:04:39 -0600168$MY_XTRACE
Sean Dague584d90e2013-03-29 14:34:53 -0400169
170# Local variables:
171# mode: shell-script
172# End: