diff options
| author | Vikram Hosakote <vhosakot@cisco.com> | 2016-03-30 04:43:48 +0000 |
|---|---|---|
| committer | Vikram Hosakote <vhosakot@cisco.com> | 2016-04-04 02:52:30 +0000 |
| commit | 86bafeee7a8926d212e8d089fade667772dbcc83 (patch) | |
| tree | a313f6f4fcc7033ab3b3e1e39f303fa3c2666e69 /ansible | |
| parent | 251b498c72f896a86672ea47394e672e309ccb96 (diff) | |
| download | kolla-86bafeee7a8926d212e8d089fade667772dbcc83.tar.gz kolla-86bafeee7a8926d212e8d089fade667772dbcc83.zip | |
Add general_log to mariadb container and make heka collect it
Added general_log to ansible/roles/mariadb/templates/galera.cnf.j2
to improve mariadb logging.
This will be helpful to debug mariadb issues especially when
mariadb is scaled.
Test results of this patch set are at:
http://paste.openstack.org/show/492852/
Change-Id: I80438d1bbdd1ed2a1f47489c6f9c45b8107340a0
Closes-Bug: #1563668
Diffstat (limited to 'ansible')
| -rw-r--r-- | ansible/roles/common/templates/heka-mariadb.toml.j2 | 2 | ||||
| -rw-r--r-- | ansible/roles/mariadb/templates/galera.cnf.j2 | 4 |
2 files changed, 4 insertions, 2 deletions
diff --git a/ansible/roles/common/templates/heka-mariadb.toml.j2 b/ansible/roles/common/templates/heka-mariadb.toml.j2 index 07d710541..04abd33b4 100644 --- a/ansible/roles/common/templates/heka-mariadb.toml.j2 +++ b/ansible/roles/common/templates/heka-mariadb.toml.j2 @@ -6,6 +6,6 @@ filename = "lua_decoders/os_mysql_log.lua" type = "LogstreamerInput" decoder = "mariadb_log_decoder" log_directory = "/var/log/kolla" -file_match = 'mariadb/mariadb\.log\.?(?P<Seq>\d*)$' +file_match = 'mariadb/(mariadb|mariadb-error)\.log\.?(?P<Seq>\d*)$' priority = ["^Seq"] differentiator = ['mariadb'] diff --git a/ansible/roles/mariadb/templates/galera.cnf.j2 b/ansible/roles/mariadb/templates/galera.cnf.j2 index a4210fa9c..fac774967 100644 --- a/ansible/roles/mariadb/templates/galera.cnf.j2 +++ b/ansible/roles/mariadb/templates/galera.cnf.j2 @@ -3,7 +3,9 @@ bind-address={{ hostvars[inventory_hostname]['ansible_' + api_interface]['ipv4']['address'] }} port={{ mariadb_port }} -log-error=/var/log/kolla/mariadb/mariadb.log +log-error=/var/log/kolla/mariadb/mariadb-error.log +general_log=1 +general_log_file=/var/log/kolla/mariadb/mariadb.log binlog_format=ROW default-storage-engine=innodb |