réplication mysql master/slave ne fonctionne pas

réplication mysql master/slave ne fonctionne pas - SQL/NoSQL - Programmation

Marsh Posté le 18-08-2014 à 21:19:34    

Bonjour à tous j'ai configuré la replication sql entre deux hosts et cela ne fonctionne pas comme il faut
 

Code :
  1. show Master status
  2. [File]: mysql-bin.000033
  3. [Position]: 681177
  4. [Binlog_Do_DB]: ciel
  6. show slave status
  7. [Slave_IO_State]: Waiting for master to send event
  8. [Master_Host]: 4xxxxx
  9. [Master_User]: bmx
  10. [Master_Port]: 3306
  11. [Connect_Retry]: 60
  12. [Master_Log_File]: mysql-bin.000033
  13. [Read_Master_Log_Pos]: 681177
  14. [Relay_Log_File]: mysqld-relay-bin.000002
  15. [Relay_Log_Pos]: 535334
  16. [Relay_Master_Log_File]: mysql-bin.000033
  17. [Slave_IO_Running]: Yes
  18. [Slave_SQL_Running]: Yes
  19. [Replicate_Do_DB]: ciel
  20. [Exec_Master_Log_Pos]: 681177
  21. [Relay_Log_Space]: 535490
  22. [Until_Condition]: None
  23. [Master_SSL_Allowed]: No
  24. [Master_SSL_Verify_Server_Cert]: No


 

Code :
  1. #master my.cnf
  2. server-id=1
  4. #slave my.cnf
  5. server-id=2
  6. master-host = 4xxx
  7. master-user = zd
  8. master-password = dzzd
  9. master-port = 3306
  10. log-slave-updates = 1
  11. binlog-do-db=ciel
  12. master-connect-retry=60
  13. replicate-do-db=ciel


 
Les résultats de la même requête sql

Code :
  1. master:
  2. [data]: 275,32,294,278,279,5,1,101,155,232,7,289,261,137,290,282,68,133,104,69,6,4,156,15,76,443
  3. [lastmod]: 2014-08-18 21:10:02
  5. slave:
  6. [data]: 5,278,294,279,1,275,32,101,155,232,7,289,261,137,290,282,68,133,104,69,6,4,156,15,76,443
  7. [lastmod]: 2014-08-17 22:35:06


 
Merci pour vos lumières  :jap:


Message édité par grosbin le 18-08-2014 à 21:22:25

---------------
Photos Panoramiques Montagnes Haute Savoie
Reply

Marsh Posté le 18-08-2014 à 21:19:34   

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed