리플리케이션 설정시에 반드시 별도 계정과 디비를 만들어야하나요?

 

저는 기존디비 계정에다가 권한만

 

GRANT REPLICATION SLAVE ON *.*  TO 계정@아이피  IDENTIFIED BY '비번';

 

이런식으로 넣어주었는데요 음..

 

계정권한은

 

        Select_priv: N
          Insert_priv: N
          Update_priv: N
          Delete_priv: N
          Create_priv: N
            Drop_priv: N
          Reload_priv: N
        Shutdown_priv: N
         Process_priv: N
            File_priv: N
           Grant_priv: N
      References_priv: N
           Index_priv: N
           Alter_priv: N
         Show_db_priv: N
           Super_priv: N
Create_tmp_table_priv: N
     Lock_tables_priv: N
         Execute_priv: N
      Repl_slave_priv: Y      <-- 여기만 변경되면 되는것이 맞는지요?
     Repl_client_priv: N
     Create_view_priv: N
       Show_view_priv: N
  Create_routine_priv: N
   Alter_routine_priv: N
     Create_user_priv: N
           Event_priv: N
         Trigger_priv: N
             ssl_type:
           ssl_cipher:
          x509_issuer:
         x509_subject:
        max_questions: 0
          max_updates: 0
      max_connections: 0
 max_user_connections: 0

 

 

 

| Waiting for master to send event | 아이피| 계정명         |        3306 |            60 | mysql-bin.000301 |             1186985 | localhost-relay-bin.000003 |         50150 | mysql-bin.000287      | Yes              | No                |                 |                     |                    |                        |                         |                             |       1062 | Error 'Duplicate entry '153664' for key 'PRIMARY'' on query. Default database: '디비명'. Query: 'insert into zetyx_board_comment_muung (parent,ismember,name,password,memo,reg_date,ip) values ('1','','mylan xan','5ce632b14f030083','  6 <a href=http://msa.umn.edu/conact-us/ target=_blank>http://msa.umn.edu/conact-us/</a> mylan xanax pics or <a href=http://www.mhoxygen.com/index.php?option=com_content&view=category&layout=blog&id=95&Itemid=77 target=_blank>http://www.mhoxygen.com/index.php?option=com_content&view=category&layout=blog&id=95&Itemid=77</a> soma taken with tramdol experiences or <a href=http://coahc.org/thrift-stores/ target=_blank>http://coahc.org/thrift-stores/</a> phentermine 37.5 diet pills or ','1313910238','195.191.54.218')' |            0 |               50005 |       807737301 | None            |                |             0 | No                 |                    |                    |                 |                   |                |                  NULL | No                            |          1045 | error connecting to master '계정@아이피:3306' - retry-time: 60  retries: 86400 |           1062 | Error 'Duplicate entry '153664' for key 'PRIMARY'' on query. Default database: '디비명'. Query: 'insert into zetyx_board_comment_muung (parent,ismember,name,password,memo,reg_date,ip) values ('1','','mylan xan','5ce632b14f030083','  6 <a href=http://msa.umn.edu/conact-us/ target=_blank>http://msa.umn.edu/conact-us/</a> mylan xanax pics or <a href=http://www.mhoxygen.com/index.php?option=com_content&view=category&layout=blog&id=95&Itemid=77 target=_blank>http://www.mhoxygen.com/index.php?option=com_content&view=category&layout=blog&id=95&Itemid=77</a> soma taken with tramdol experiences or <a href=http://coahc.org/thrift-stores/ target=_blank>http://coahc.org/thrift-stores/</a> phentermine 37.5 diet pills or ','1313910238','195.191.54.218')' |

 

와 같이 슬레이브 측에서 확인되네요 ㅜㅜ

 

 

mysql> show master status;
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000301 |  1568908 |              |                  |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

 

마스터쪽은 이렇구요 ㅜㅜ

 

간단한 설정인데 ㅜㅜ 쉽지않으네요 ㅜㅜ

 

고수님들 조언부탁드립니다.