Guest User

Untitled

a guest
Sep 15th, 2018
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.90 KB | None | 0 0
  1. Mysql Replication Data not updated but log updated
  2. /etc/my.cnf
  3. **#mysql Server setup**
  4. server-id=1
  5. bind-address = 192.168.1.41
  6. innodb_flush_log_at_trx_commit=1
  7. sync_binlog=1
  8. log-bin = /var/log/mysql/mysql-bin.log
  9. binlog-do-db=my_db
  10.  
  11. /etc/my.cnf
  12. **#mysql replication client setup**
  13. server-id=5
  14. master-host=192.168.1.41
  15. master-user=web_master
  16. master-password=webmaster
  17. master-connect-retry=60
  18. replicate-do-db=dev_my_db
  19. log-slave-updates
  20.  
  21. GRANT SUPER,REPLICATION CLIENT,REPLICATION SLAVE,RELOAD ON *.* TO 'web_master'@'192.168.1.41' identified by 'webmaster';
  22.  
  23. CHANGE MASTER TO MASTER_HOST='192.168.1.41', MASTER_USER='web_master', MASTER_PASSWORD='webmaster', MASTER_LOG_FILE='mysql-bin.00002', MASTER_LOG_POS=107;
  24.  
  25. mysql> SHOW master STATUSG
  26.  
  27. File: mysql-bin.000004
  28. Position: 13790
  29. Binlog_Do_DB: my_db
  30. Binlog_Ignore_DB:
  31. 1 row in set (0.00 sec)
  32.  
  33. mysql> SHOW SLAVE STATUS G;
  34. *************************** 1. row ***************************
  35. Slave_IO_State: Waiting for master to send event
  36. Master_Host: 192.168.1.41
  37. Master_User: web_master
  38. Master_Port: 3306
  39. Connect_Retry: 60
  40. Master_Log_File: mysql-bin.000004
  41. Read_Master_Log_Pos: 13790
  42. Relay_Log_File: mysqld-relay-bin.000007
  43. Relay_Log_Pos: 244
  44. Relay_Master_Log_File: mysql-bin.000004
  45. Slave_IO_Running: Yes
  46. Slave_SQL_Running: Yes
  47. Replicate_Do_DB: dev_CHGV2_dbo
  48. Replicate_Ignore_DB:
  49. Replicate_Do_Table:
  50. Replicate_Ignore_Table:
  51. Replicate_Wild_Do_Table:
  52. Replicate_Wild_Ignore_Table:
  53. Last_Errno: 0
  54. Last_Error:
  55. Skip_Counter: 0
  56. Exec_Master_Log_Pos: 13790
  57. Relay_Log_Space: 401
  58. Until_Condition: None
  59. Until_Log_File:
  60. Until_Log_Pos: 0
  61. Master_SSL_Allowed: No
  62. Master_SSL_CA_File:
  63. Master_SSL_CA_Path:
  64. Master_SSL_Cert:
  65. Master_SSL_Cipher:
  66. Master_SSL_Key:
  67. Seconds_Behind_Master: 0
  68. Master_SSL_Verify_Server_Cert: No
  69. Last_IO_Errno: 0
  70. Last_IO_Error:
  71. Last_SQL_Errno: 0
  72. Last_SQL_Error:
  73. Replicate_Ignore_Server_Ids:
  74. Master_Server_Id: 4
  75. 1 row in set (0.00 sec)
  76. ERROR:
  77. No query specified
Add Comment
Please, Sign In to add comment