Guest User

Untitled

a guest
Nov 12th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.41 KB | None | 0 0
  1. | Connecting to master | 10.10.10.11 | replication | 3306 |
  2. 60 | mysql-bin.000028 | 235 | hostname-relay-bin.000001 |
  3. 4 | mysql-bin.000028 | Connecting | Yes |
  4. | | | |
  5. | | 0 | | 0 |
  6. 235 | 155 | None | | 0 |
  7. No | | |
  8. | | | NULL | No
  9. | 2061 | error connecting to master 'replication@10.10.10.11:3306'
  10. - retry-time: 60 retries: 5 | 0 | |
  11. | 0 | 3f5f6303-e43a-11e8-8b15-1264508be584 |
  12. mysql.slave_master_info | 0 | NULL | Slave has read
  13. all relay log; waiting for more updates | 86400 | |
  14. 181112 19:27:03 | | |
  15. | | 3f5f6303-e43a-11e8-8b15-1264508be584:1-997353:997359-
  16. 997399,
  17. b5b70b2f-e55b-11e8-b5a6-1285d1fcc636:1-10 | 0 |
  18. | | | |
  19. 0 |
  20.  
  21. "error connecting to master 'replication@10.10.10.11:3306'"
  22.  
  23. mysql -h 10.10.10.11 -u replication -p
  24.  
  25. [client]
  26. port = 3306
  27. socket = /tmp/mysql.sock
  28.  
  29. [mysql]
  30. prompt = u@h [d]>_
  31. no_auto_rehash
  32.  
  33. [mysqld]
  34. user = mysql
  35. port = 3306
  36. socket = /tmp/mysql.sock
  37. #bind-address = 127.0.0.1
  38. basedir = /usr/local
  39. datadir = /var/db/mysql
  40. tmpdir = /var/db/mysql_tmpdir
  41. slave-load-tmpdir = /var/db/mysql_tmpdir
  42. secure-file-priv = /var/db/mysql_secure
  43. log-bin = mysql-bin
  44. log-output = TABLE
  45. master-info-repository = TABLE
  46. relay-log-info-repository = TABLE
  47. relay-log-recovery = 1
  48. slow-query-log = 1
  49. server-id = 2
  50. sync_binlog = 1
  51. sync_relay_log = 1
  52. binlog_cache_size = 16M
  53. expire_logs_days = 30
  54. default_password_lifetime = 0
  55. enforce-gtid-consistency = 1
  56. gtid-mode = ON
  57. safe-user-create = 1
  58. lower_case_table_names = 1
  59. explicit-defaults-for-timestamp = 1
  60. myisam-recover-options = BACKUP,FORCE
  61. open_files_limit = 32768
  62. table_open_cache = 16384
  63. table_definition_cache = 8192
  64. net_retry_count = 16384
  65. key_buffer_size = 256M
  66. max_allowed_packet = 64M
  67. long_query_time = 0.5
  68. innodb_buffer_pool_size = 1G
  69. innodb_data_home_dir = /var/db/mysql
  70. innodb_log_group_home_dir = /var/db/mysql
  71. innodb_data_file_path = ibdata1:128M:autoextend
  72. innodb_temp_data_file_path = ibtmp1:128M:autoextend
  73. innodb_flush_method = O_DIRECT
  74. innodb_log_file_size = 256M
  75. innodb_log_buffer_size = 16M
  76. innodb_write_io_threads = 8
  77. innodb_read_io_threads = 8
  78. innodb_autoinc_lock_mode = 2
  79. skip-symbolic-links
  80.  
  81. [mysqldump]
  82. max_allowed_packet = 256M
  83. quote_names
  84. quick
Add Comment
Please, Sign In to add comment