[mysqld]
federated
# --Master replication options
skip-slave-start
server_id=2
slave_skip_errors=all
# log-bin=tattoo-bin
# binlog_format=MIXED
innodb_flush_log_at_trx_commit=1
sync_binlog=1

# replicate-do-db=mobile_analytics
# replicate-do-db=sitewerx
# replicate-do-db=content_services

# replicate-do-table=sitewerx.sw_configurations
# replicate-do-table=sitewerx.mgmt_complexes
# replicate-do-table=sitewerx.mgmt_buildings
# replicate-do-table=sitewerx.mgmt_floors
# replicate-do-table=sitewerx.location_groups
# replicate-do-table=content_services.mobile_applications
# replicate-do-table=mobile_analytics.device_selections
# replicate-do-table=mobile_analytics.visit_aggregates
# replicate-do-table=mobile_analytics.visit_lg_aggregates
#replicate-ignore-table=sitewerx.mgmt_link_status
#replicate-ignore-table=sitewerx.mgmt_chain_links
replicate-ignore-table=mobile_analytics.device_selections_BH
replicate-wild-ignore-table=I.q%
# Replication Slave
relay-log-index=relay-bin.index
relay-log=relay-bin

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
# symbolic-links=0
max-allowed-packet=512M
# init-file=/usr/local/wirelesswerx/init-script.sql
# init-file=/usr/local/wirelesswerx/populate_memory_tables.sql
max-connections=512
default_time_zone=SYSTEM

# skip-locking
key_buffer_size = 16M
table_open_cache = 256
sort_buffer_size = 5M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
thread_cache_size = 8
thread_concurrency = 8
query_cache_size= 16M
max_heap_table_size = 536870912

myisam_sort_buffer_size = 32M
innodb_buffer_pool_size = 2G
log-error=/var/log/mysqld.log

[mysqld_safe]
timezone=UTC
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid