[client]
port		= 3306
socket		= /tmp/mysql.sock
#default-character-set = utf8
password=root
[mysqld]
log_bin_trust_function_creators = 1
innodb_log_group_home_dir = /u02/mysqldata
innodb_data_home_dir = 
innodb_data_file_path = /u02/mysqldata/ibdata1:79691776:autoextend:max:40G
#master-info-repository=TABLE
report-host = occ-cms-01
report-port = 3306
slave-skip-errors=1062,1032,1053
replicate-ignore-table = test.adm_sequence,tra_occ.adm_sequence
log_bin_trust_function_creators = 1
gtid_mode=on
#disable-gtid-unsafe-statements
#disable_gtid_unsafe_statements=1 renamed to enforce_gtid_consistency
enforce_gtid_consistency=1
sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_BACKSLASH_ESCAPES,NO_ENGINE_SUBSTITUTION,NO_UNSIGNED_SUBTRACTION,PIPES_AS_CONCAT'
#sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_UNSIGNED_SUBTRACTION,PIPES_AS_CONCAT'
#log=mysql.log
event_scheduler=1
federated
basedir = /u01/app/mysql
datadir = /u01/app/mysql/data
port		= 3306
socket		= /tmp/mysql.sock
#init_connect='SET collation_connection=utf8_bin'
#default-character-set = utf8
character-set-server = utf8
collation-server = utf8_bin
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 2M
tmp_table_size = 256M
max_heap_table_size = 256M
sort_buffer_size = 1M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
#myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 256M
query_cache_limit   = 2M
long_query_time    = 10
slow_query_log = ON
max_binlog_size         = 50M
max_connections     = 665
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
#log-bin=mysql-bin
binlog_format=MIXED
lower_case_table_name=1
default-storage-engine=innodb
#autocommit=0
#replication
master_retry_count=0
server-id=1
binlog-do-db=test
binlog-do-db=tra_occ
log-bin=master-bin
log-bin-index=master-log-bin
relay-log=slave-relay
relay-log-info-file=slave-relay-log
relay-log-index=slave-relay-log
replicate-do-db=test
replicate-do-db=tra_occ
log-slave-updates
#slave-skip-errors=all
sync_binlog=1
auto_increment_increment=2
#auto_increment_offset=2
auto_increment_offset=1

#semi-sync
rpl_semi_sync_master_enabled=1
rpl_semi_sync_master_timeout=10000
rpl_semi_sync_slave_enabled=1
#rpl_semi_sync_master_wait_before_commit=1

#ndbcluster
#ndb-connectstring=occ-cms-01,occ-cms-02 # location of management server



[mysqldump]
quick
max_allowed_packet = 512M

[mysql]
no-auto-rehash

[mysqlhotcopy]
interactive-timeout

#[mysql_cluster]
# for ndbd
#ndb-connectstring=occ-cms-01,occ-cms-02 # location of management server