Ringkasan Multiway SQL Antar Komputer


MASTER1
1. MATIKAN FIREWALL (START | SETTINGS | CONTROL PANEL | WINDOWS FIREWALL | OFF)
2. EDIT FILE MY.INI (C:\APPSERV\MYSQL\MY.INI) MENGGUNAKAN NOTEPAD
   PADA [MYSQLD] TAMBAHKAN :
      server-id=1
      auto-increment-increment=2
      master-host=(ip server2)
      master-user=server1
      master-password=server1
      master-connect-retry=60
      replicate-do-db=akademik
      log-bin=C:\appserv\mysql\mysql-bin.log
      binlog-do-db=akademik
      relay-log=C:\appserv\mysql\slave-relay.log
      relay-log-index=C:\appserv\mysql\slave-relay-log.index
      expire_logs_days=5
      max_binlog_size=100M
   DAN DI SIMPAN
4. RESTART MYSQL (START|SETTINGS|CONTROL PANEL|ADMINISTRATIVE TOOLS|SERVICES|MYSQL|RESTART)
5. JIKA ERROR MAKA ULANGI LANGKAH NO. 2
6. MASUK KE MYSQL (START|RUN|CMD|OK)
   C:\CD APPSERV\MYSQL\BIN (COMMAND PROMPT)
   MYSQL -u root -p
   PASSWORD : root
7. MYSQL>GRANT REPLICATION SLAVE ON *.* TO 'server2'@'(lihat ip server2 )' IDENTIFIED BY 'server2';
8. FLUSH PRIVILEGES;
9. SHOW MASTER STATUS;
10. MYSQL>SLAVE STOP
11. MYSQL>CHANGE MASTER TO MASTER_HOST='(lihat ip server2)',
         MASTER_USER='server1', MASTER_PASSWORD='server1',
         MASTER_LOG_FILE='mysql-bin.000001 (lihat file dari show master status)', 
         MASTER_LOG_POS=160 (lihat position dari show master status);
12. MYSQL>START SLAVE
13. MYSQL>SHOW SLAVE STATUS\G

MASTER2
1. MATIKAN FIREWALL (START | SETTINGS | CONTROL PANEL | WINDOWS FIREWALL | OFF)
2. EDIT FILE MY.INI (C:\APPSERV\MYSQL\MY.INI) MENGGUNAKAN NOTEPAD
   PADA [MYSQLD] TAMBAHKAN :
 server-id=2
        replicate-same-server-id=0
        auto-increment-increment=2
 master-host=(ip server1) 
 master-user=server2
 master-password=server2
 master-connect-retry=60
 replicate-do-db=akademik
        log-bin=C:\appserv\mysql\mysql-bin.log
        binlog-do-db=akademik
        relay-log=C:\appserv\mysql\slave-relay.log
        relay-log-index=C:\appserv\mysql\slave-relay-log.index
        expire_logs_days=5
        max_binlog_size=100M
4. RESTART MYSQL (START|SETTINGS|CONTROL PANEL|ADMINISTRATIVE TOOLS|SERVICES|MYSQL|RESTART)
5. JIKA ERROR MAKA ULANGI LANGKAH NO. 2
6. MASUK KE MYSQL (START|RUN|CMD|OK)
   C:\CD APPSERV\MYSQL\BIN (COMMAND PROMPT)
   MYSQL -u root -p
   PASSWORD : root
7. MYSQL>GRANT REPLICATION SLAVE ON *.* TO 'server1'@'(lihat ip server1)' IDENTIFIED BY 'server1';
8. FLUSH PRIVILEGES;
9. SHOW MASTER STATUS;
10. MYSQL>SLAVE STOP;
11. MYSQL>CHANGE MASTER TO MASTER_HOST='(lihat ip server1)',
         MASTER_USER='server2', MASTER_PASSWORD='server2',
         MASTER_LOG_FILE='mysql-bin.000001 (lihat file dari show master status)', 
         MASTER_LOG_POS=160 (lihat position dari show master status);
12. MYSQL>START SLAVE;
13. MYSQL>SHOW SLAVE STATUS\G;



Post a Comment

1 Comments

  1. Cara setting my.ini agar tidak memasukan perintah ke cmd bagaimana ? Yang di cmd hanya hak aksesnya saja yang di do masukan setelah itu menjalankan databasenya via my.ini

    ReplyDelete