Page Menu
Home
DevCentral
Search
Configure Global Search
Log In
Files
F3746733
D855.diff
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Size
3 KB
Referenced Files
None
Subscribers
None
D855.diff
View Options
diff --git a/roles/shellserver/database/files/my.cnf b/roles/shellserver/database/files/my.cnf
new file mode 100644
--- /dev/null
+++ b/roles/shellserver/database/files/my.cnf
@@ -0,0 +1,30 @@
+#
+# Eglide MySQL configuration
+#
+
+[client]
+port = 3306
+socket = /var/run/mysqld/mysqld.sock
+
+[mysqld_safe]
+pid-file = /var/run/mysqld/mysqld.pid
+socket = /var/run/mysqld/mysqld.sock
+nice = 0
+
+[mysqld]
+user = mysql
+pid-file = /var/run/mysqld/mysqld.pid
+socket = /var/run/mysqld/mysqld.sock
+port = 3306
+basedir = /usr
+datadir = /var/lib/mysql
+tmpdir = /tmp
+lc-messages-dir = /usr/share/mysql
+explicit_defaults_for_timestamp
+
+sql_mode =STRICT_ALL_TABLES
+ft_stopword_file=/opt/stopwords.txt
+ft_min_word_len =3
+ft_boolean_syntax=' |-><()~*:""&^'
+
+max_connections = 50
diff --git a/roles/shellserver/database/files/stopwords.txt b/roles/shellserver/database/files/stopwords.txt
new file mode 100644
--- /dev/null
+++ b/roles/shellserver/database/files/stopwords.txt
@@ -0,0 +1,70 @@
+the
+be
+and
+of
+a
+in
+to
+have
+to
+it
+I
+that
+for
+you
+he
+with
+on
+do
+say
+this
+they
+at
+but
+we
+his
+from
+that
+not
+by
+or
+as
+what
+go
+their
+can
+who
+get
+if
+would
+all
+my
+will
+as
+up
+there
+so
+its
+us
+in
+on
+de
+du
+le
+la
+les
+au
+à
+au
+par
+et
+mais
+ou
+donc
+or
+ni
+car
+pas
+que
+des
+dont
diff --git a/roles/shellserver/database/init.sls b/roles/shellserver/database/init.sls
new file mode 100644
--- /dev/null
+++ b/roles/shellserver/database/init.sls
@@ -0,0 +1,10 @@
+# -------------------------------------------------------------
+# Salt — Provision software
+# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+# Project: Eglide
+# Created: 2017-01-23
+# License: Trivial work, not eligible to copyright
+# -------------------------------------------------------------
+
+include:
+ - .mysql
diff --git a/roles/shellserver/database/mysql.sls b/roles/shellserver/database/mysql.sls
new file mode 100644
--- /dev/null
+++ b/roles/shellserver/database/mysql.sls
@@ -0,0 +1,35 @@
+# -------------------------------------------------------------
+# Salt — Provision MySQL
+# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+# Project: Eglide
+# Created: 2017-01-23
+# License: Trivial work, not eligible to copyright
+# -------------------------------------------------------------
+
+# -------------------------------------------------------------
+# Software
+# -------------------------------------------------------------
+
+mysql:
+ pkg:
+ - installed
+ - pkgs:
+ {% if grains['os'] == 'Debian' or grains['os'] == 'Ubuntu' %}
+ - mariadb-server
+ {% elif grains['os'] == 'FreeBSD' %}
+ - mariadb101-server
+ {% endif %}
+
+full_text_search_stopwords_file:
+ file.managed:
+ - name: /opt/stopwords.txt
+ - source: salt://roles/shellserver/database/files/stopwords.txt
+
+mysql_config:
+ file.managed:
+ {% if grains['os'] == 'FreeBSD' %}
+ - name: /usr/local/etc/my.cnf
+ {% else %}
+ - name: /etc/my.cnf
+ {% endif %}
+ - source: salt://roles/shellserver/database/files/my.cnf
File Metadata
Details
Attached
Mime Type
text/plain
Expires
Sat, Nov 16, 22:52 (21 h, 9 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2248220
Default Alt Text
D855.diff (3 KB)
Attached To
Mode
D855: Deploy MySQL on Eglide
Attached
Detach File
Event Timeline
Log In to Comment