Skip to content

Instantly share code, notes, and snippets.

@cloudnull
Last active August 29, 2015 14:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cloudnull/c50f14f2b82f6850fe48 to your computer and use it in GitHub Desktop.
Save cloudnull/c50f14f2b82f6850fe48 to your computer and use it in GitHub Desktop.
galera fix logging
diff --git a/playbooks/galera-install.yml b/playbooks/galera-install.yml
index 753550e..a06b9a6 100644
--- a/playbooks/galera-install.yml
+++ b/playbooks/galera-install.yml
@@ -45,7 +45,7 @@
roles:
- { role: "galera_server", tags: [ "galera-server" ] }
- role: "rsyslog_client"
- rsyslog_client_log_dir: "/var/log/mysql"
+ rsyslog_client_log_dir: "/var/log/mysql_logs"
rsyslog_client_log_files:
- /var/log/mysql.log
- /var/log/mysql.err
diff --git a/playbooks/roles/galera_server/tasks/galera_post_install.yml b/playbooks/roles/galera_server/tasks/galera_post_install.yml
index 642f564..a693e2e 100644
--- a/playbooks/roles/galera_server/tasks/galera_post_install.yml
+++ b/playbooks/roles/galera_server/tasks/galera_post_install.yml
@@ -23,6 +23,7 @@
recurse: "{{ item.recurse|default('false') }}"
with_items:
- { path: "/var/log/mysql/", owner: "mysql", recurse: "true" }
+ - { path: "/var/log/mysql_logs/", owner: "mysql", group: "syslog", mode: "2755" }
- { path: "/etc/mysql/conf.d" }
tags:
- galera-config
diff --git a/playbooks/roles/galera_server/templates/my.cnf.j2 b/playbooks/roles/galera_server/templates/my.cnf.j2
index 6c4589f..cc53f82 100644
--- a/playbooks/roles/galera_server/templates/my.cnf.j2
+++ b/playbooks/roles/galera_server/templates/my.cnf.j2
@@ -32,8 +32,8 @@ datadir = /var/lib/mysql
# LOGGING #
log-queries-not-using-indexes = 1
slow-query-log = 1
-slow-query-log-file = /var/log/mysql/mysql-slow.log
-log_error = /var/log/mysql/galera_server_error.log
+slow-query-log-file = /var/log/mysql_logs/mysql-slow.log
+log_error = /var/log/mysql_logs/galera_server_error.log
log-bin = /var/lib/mysql/mariadb-bin
log-bin-index = /var/lib/mysql/mariadb-bin.index
expire-logs-days = 7
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment