REPLIKASI NATIF ( ONE WAY )

MASTER 

MATIKAN FIREWALL (START | SETTINGS | CONTROL PANEL | WINDOWS FIREWALL | OFF)

EDIT FILE MY.INI (C:\APPSERV\MYSQL\MY.INI) MENGGUNAKAN NOTEPAD

PADA [MYSQLD] TAMBAHKAN :

      server-id = 1

      log-bin = C:\appserv\mysql\mysql-bin.log

      binlog-do-db = akademik

DAN DI SIMPAN

RESTART MYSQL (START|SETTINGS|CONTROL PANEL|ADMINISTRATIVE TOOLS|SERVICES|MYSQL|RESTART)

JIKA ERROR MAKA ULANGI LANGKAH DIATAS

MASUK KE MYSQL (START|RUN|CMD|OK)

C:\CD APPSERV\MYSQL\BIN (COMMAND PROMPT)

MYSQL -u root -p

PASSWORD : root

MYSQL>GRANT REPLICATION SLAVE ON *.* TO 'slave'@'( ip client )' IDENTIFIED BY 'slave';

FLUSH PRIVILEGES;

SHOW MASTER STATUS;

CLIENT

MATIKAN FIREWALL (START | SETTINGS | CONTROL PANEL | WINDOWS FIREWALL | OFF)

EDIT FILE MY.INI (C:\APPSERV\MYSQL\MY.INI) MENGGUNAKAN NOTEPAD

PADA [MYSQLD] TAMBAHKAN :

    server-id = 3

    master-host = (ip client)

    master-user = slave

    master-password = slave

    master-connect-retry = 60

    replicate-do-db =database anda

DAN DI SIMPAN

RESTART MYSQL (START|SETTINGS|CONTROL PANEL|ADMINISTRATIVE TOOLS|SERVICES|MYSQL|RESTART)

JIKA ERROR MAKA ULANGI LANGKAH DIATAS

MASUK KE MYSQL (START|RUN|CMD|OK)

C:\CD APPSERV\MYSQL\BIN (COMMAND PROMPT)

MYSQL -u root -p

PASSWORD : root

MYSQL>SLAVE STOP;

MYSQL>CHANGE MASTER TO MASTER_HOST='(ip master)',

MASTER_USER='slave', MASTER_PASSWORD='slave',

MASTER_LOG_FILE='mysql-bin.000001 (lihat file dari show master status)',

MASTER_LOG_POS=160 (lihat position dari show master status);

MYSQL>START SLAVE;

MYSQL>SHOW SLAVE STATUS\G;

Silahkan Dicoba semoga bermanfaat ya......!

Posted in: REPLIKASI DATABASE