[mysql]
#ALEPO_FILE_VERSION=10.5
 
# CLIENT #
port                            = 3306
socket                          = /var/lib/mysql/mysql.sock
#default-character-set          = utf8
 
[mysqld]
 
# GENERAL #
skip-name-resolve
user                            = mysql
default_storage_engine          = InnoDB
socket                          = /var/lib/mysql/mysql.sock
pid_file                        = /var/lib/mysql/mysql.pid
lower_case_table_names          =  1
transaction-isolation           = READ-COMMITTED
secure_auth                     = 1
wait_timeout                    = 1800
# If replication is Used then put these parameter for DB1 server id will be 1 for DB2 server Id will be 2 and logbin and relaylog also
server-id                       = 4
log-bin                         = db4-binary
relay-log                       = db4-relay
binlog_format                   = mixed
core-file
#It has to be decided by MMM at run time.If MMM is configured use this parameter otherwise comment this.
read_only                       = 1
 
log_slave_updates               = 1
max-relay-log-size              = 64M
max-binlog-size                 = 200M
#relay-log                      = /var/run/mysqld/mysqld-relay-bin
 
# Ignore table to Replication Please add more table if creating issue in replication
#AAA
replicate-ignore-table          = aaadb.quartz_scheduler_state
replicate-ignore-table          = aaadb.systemconfigurations
#replicate-ignore-table          = aaadb.authenticationlog
 
#CRM
replicate-ignore-table          = crmdb.quartz_scheduler_state
 
#PCRF
replicate-ignore-table          = pcrfdb.quartz_scheduler_state
 
#Activemq
replicate-ignore-table          = activemq.activemq_lock
replicate-ignore-table          = activemq.activemq_acks
 
replicate-ignore-table          = mysql.gtid_slave_pos
slave_exec_mode = STRICT
gtid_domain_id = 4                  #1 for site-1, 2 for site-2
gtid_ignore_duplicates = ON
auto_increment_increment = 10
auto_increment_offset = 4           #equals to serverID
slave-skip-errors              = 1032
#slave-skip-errors              = 1062
#Max Connection depends on Client Requirement, increase this value as per requirment
# SAFETY #
max_allowed_packet              =  512M
max_connect_errors              =  1000000
 
# DATA STORAGE #
datadir                         =  /var/lib/mysql
max_connections                 =  800
 
#Added on Sep 10 2011 This parameter is For All NEW Tables created in Lower Case.If tables created in lowercase use this 
lower_case_table_names          =  1
 
 
# CACHES AND LIMITS #
#Added on 13July
key_buffer_size                 = 64M
sort_buffer_size                = 2M
max_heap_table_size             = 64M
# query_cache_size              = 2M
thread_cache_size               = 60
open_files_limit                = 65535
table_definition_cache          = 4096
table_open_cache                = 2048
query_cache_type                = 0
 
#variable added on 24 Dec as per /usr/share/mysql/my-innodb-heavy-4G.cnf file
 
back_log                        = 50
binlog_cache_size               = 8M
join_buffer_size                = 16M
thread_concurrency              = 4
query_cache_limit               = 0
 
 
# *** INNODB Specific options ***
 
#For Separate Tablespace for each Table put this Parameter Each Newly created table will have it's own tablespace
#For old Table give command after putting this parameter ALTER TABLE table_name ENGINE=InnoDB;
 
innodb_file_per_table           = 1
 
#If you have more than one HardDisk then use separate partition to store data[ibdata1]
# and Use this parameter Otherwise deafult dir /var/lib/mysql
 
#innodb_data_home_dir           = /home/mysql-data
#innodb_data_file_path          = ibdata1:500M:autoextend
innodb_flush_log_at_trx_commit  = 1
 
# This variable to used to change flush method Use it when you have RAID or Replication
innodb_flush_method             = fsync
innodb_log_group_home_dir       = /var/lib/mysql
#innodb_additional_mem_pool_size = 16M
 
#This can be maximum 60%-70% of RAM SIZE [HERE RAM SIZE IS 8G]
innodb_buffer_pool_size         = 300G
#innodb_file_io_threads                 = 4
innodb_read_io_threads=12
innodb_write_io_threads=12
innodb_thread_concurrency       = 12
innodb_log_buffer_size          = 5G
 
# This is for 25-50% of Buffer_pool size
# Sensible values range from 1MB to 1/N-th of the size of the buffer pool, where N is the number of log files in the group
innodb_log_file_size            = 75G
innodb_log_files_in_group       = 4
innodb_strict_mode              = 0
 
# Below Two parameter values updated due to Activemq issue.
 
innodb_lock_wait_timeout        = 300
lock_wait_timeout               = 300
innodb_io_capacity              = 200
 
 
expire_logs_days                = 5
 
# For Slow Query log
slow_query_log                  = 1
 
# This parameter define time in Seconds for slow query
long_query_time                 = 1
 
# This parameter define log file
log_error                       = /var/lib/mysql/mysqld.log
 
# This parameter is used for UserDefined Function which is updating the data.
log_bin_trust_function_creators = 1
 
 
#slave_exec_mode = STRICT
#gtid_domain_id = 2                  #1 for site-1, 2 for site-2
#gtid_ignore_duplicates = ON
auto_increment_increment = 10
auto_increment_offset = 4           #equals to serverID
 
#For myisam
[myisamchk]
key_buffer_size                 = 8M
sort_buffer_size                = 2M
read_buffer                     = 2M
write_buffer                    = 2M
 
 
[mysqld_safe]
pid-file                        = /var/run/mysqld/mysqld.pid