[server]

server-id=2

# this is only for the mysqld standalone daemon

[mysqld]

default_storage_engine = InnoDB

max_connect_errors = 10

max_connections = 100

wait_timeout = 3600

datadir = /var/lib/mysql

max_heap_table_size = 100M

performance_schema = ON

##team@inbox 2015-10-23 logs setup

long_query_time = 0.1

slow_query_log = ON

log_error = /var/log/mysql/mysql.err

slow_query_log_file = /var/log/mysql/slow_query.log

sql_error_log_filename = /var/log/mysql/sql_error.log

plugin-load = sql_errlog.so

log_bin

binlog_format = ROW

innodb_locks_unsafe_for_binlog = 1

#binlog_format=row

#default_storage_engine=InnoDB

innodb_autoinc_lock_mode=2

bind-address=0.0.0.0

#

# Optional setting

wsrep_slave_threads=4

innodb_flush_log_at_trx_commit=2

##Galera settings from training material

wsrep_on = ON

wsrep_cluster_name="test_cluster"

wsrep_node_name=node2

wsrep_cluster_address="gcomm://192.168.76.199,192.168.76.189"

wsrep_node_address=192.168.76.199

wsrep_sst_method = xtrabackup-v2

wsrep_sst_receive_address=192.168.76.199

wsrep_sst_auth=sst:galera

wsrep_provider=/usr/lib64/galera/libgalera_smm.so

# this is only for embedded server

[embedded]

# This group is only read by MariaDB servers, not by MySQL.

# If you use the same .cnf file for MySQL and MariaDB,

# you can put MariaDB-only options here

[mariadb]

# This group is only read by MariaDB-10.1 servers.

# If you use the same .cnf file for MariaDB of different versions,

# use this group for options that older servers don't understand

[mariadb-10.1]