admin - 28th Feb, 2008

Mengembalikan Mirroring pada MySQL

Mengembalikan Replication

 

  1. Reset Master:
    1. Master-mysql -> reset master;
  2. Stop Slave
    1. Slave-mysql ->stop slave;
  3. Reset Slave
    1. Slave-mysql -> reset slave;
  4. Dump Slave
    1. Slave-mysql->LOAD DATA FROM MASTER;
    2. Insert Triggers + Procedure
  5. Start Slave
    1. Slave-mysql ->start slave;
  6. Check status Slave;
    1. Slave-mysql ->show slave status;
Categories: Server, hack, mysql

Leave a response

Your response: