From a79f9f3838b98f9b06fa492a2bbd902658ff223d Mon Sep 17 00:00:00 2001
From: Ludovic CHEVALIER <ludovic.chevalier@heureux-cyclage.org>
Date: Tue, 19 Mar 2013 15:02:57 +0100
Subject: [PATCH] Modification: rule_mysql_configure

---
 etc/mysql/my.cnf | 51 ++++++++++++++++++++++++++++++++++++++++++++++++
 vm_hosted        |  5 +++++
 2 files changed, 56 insertions(+)
 create mode 100644 etc/mysql/my.cnf

diff --git a/etc/mysql/my.cnf b/etc/mysql/my.cnf
new file mode 100644
index 0000000..60dd256
--- /dev/null
+++ b/etc/mysql/my.cnf
@@ -0,0 +1,51 @@
+[client]
+port		= 3306
+socket		= /var/run/mysqld/mysqld.sock
+[mysqld_safe]
+nice		= 0
+socket		= /var/run/mysqld/mysqld.sock
+[mysqld]
+# chroot = /var/lib/mysql/
+# ssl-ca=/etc/mysql/cacert.pem
+# ssl-cert=/etc/mysql/server-cert.pem
+# ssl-key=/etc/mysql/server-key.pem
+basedir		= /usr
+bind-address		= 127.0.0.1
+#binlog_do_db		= include_database_name
+#binlog_ignore_db	= include_database_name
+datadir		= /home/mysql
+expire_logs_days	= 10
+#general_log             = 1
+#general_log_file        = /var/log/mysql/mysql.log
+key_buffer		= 16M
+lc-messages-dir	= /usr/share/mysql
+#log-queries-not-using-indexes
+#log_bin			= /var/log/mysql/mysql-bin.log
+#log_slow_queries	= /var/log/mysql/mysql-slow.log
+#long_query_time = 2
+max_allowed_packet	= 16M
+max_binlog_size         = 100M
+#max_connections        = 100
+myisam-recover         = BACKUP
+pid-file	= /var/run/mysqld/mysqld.pid
+port		= 3306
+query_cache_limit	= 1M
+query_cache_size        = 16M
+#server-id		= 1
+skip-external-locking
+socket		= /var/run/mysqld/mysqld.sock
+#table_cache            = 64
+thread_cache_size       = 8
+#thread_concurrency     = 10
+thread_stack		= 192K
+tmpdir		= /tmp
+user		= mysql
+[mysqldump]
+max_allowed_packet	= 16M
+quick
+quote-names
+[mysql]
+#no-auto-rehash	# faster start of mysql but no tab completition
+[isamchk]
+key_buffer		= 16M
+!includedir /etc/mysql/conf.d/
diff --git a/vm_hosted b/vm_hosted
index 8fc2641..46aa6af 100755
--- a/vm_hosted
+++ b/vm_hosted
@@ -708,6 +708,11 @@ rule_mail_configure () {
  }
 rule_mysql_configure () {
 	rule apt_get_install mysql-server-5.5
+	sudo install -m 644 -o root -g root \
+	    "$tool"/etc/mysql/my.cnf \
+	    /etc/mysql/my.cnf
+	sudo install -d -m 750 -o mysql -g mysql \
+	 /home/mysql
 	sudo service mysql restart
  }
 rule_network_configure () {
-- 
2.20.1