Replication pada Linux Ubuntu MySQL 5.1 x

1. Pada Server Master

Config pada /etc/mysql/my.cnf

server-id        = 1
binlog_format= row ## disini format binlog bisa menggunakan row atau mixed, untuk efektivitas perangkat pada server sebaiknya menggunakan format " row "
log_bin          = /var/log/mysql/mysql-bin.log
expire_logs_days      = 10
max_binlog_size       = 100M
binlog_do_db            = db-master
binlog_do_db            = mysql
log_bin_trust_function_creators      = 1
innodb_flush_log_at_trx_commit    = 1
sync_binlog               = 1

2. Pada Server Slave

Config pada /etc/mysql/my.cnf

server-id               = 2

master-host           = x.x.x.x

master-connect-retry  = 120

master-user                = xxx

master-password        = ***

replicate-do-db           = db-master

replicate-do-db           = mysql

replicate-ignore-db     = smsbpr

replicate-ignore-table  = mbs-online.log_login

replicate-ignore-table  = smsbpr.sms_out

slave-skip-errors          = 1062,1032

#slave-skip-errors        = all

relay-log                      = /var/lib/mysql/slave-relay.log

relay-log-index            = /var/lib/mysql/slave-relay-log.index