[mysqld]
server-id=100
log-bin=mysqlprd-bin.log
binlog_format=mixed
datadir=/opt/pmysqldata
innodb_flush_log_at_trx_commit=1
sync_binlog=1
key-buffer-size = 32M
innodb = ON
innodb_buffer_pool_size=1G
lower_case_table_names = 1