Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- | Connecting to master | 10.10.10.11 | replication | 3306 |
- 60 | mysql-bin.000028 | 235 | hostname-relay-bin.000001 |
- 4 | mysql-bin.000028 | Connecting | Yes |
- | | | |
- | | 0 | | 0 |
- 235 | 155 | None | | 0 |
- No | | |
- | | | NULL | No
- | 2061 | error connecting to master 'replication@10.10.10.11:3306'
- - retry-time: 60 retries: 5 | 0 | |
- | 0 | 3f5f6303-e43a-11e8-8b15-1264508be584 |
- mysql.slave_master_info | 0 | NULL | Slave has read
- all relay log; waiting for more updates | 86400 | |
- 181112 19:27:03 | | |
- | | 3f5f6303-e43a-11e8-8b15-1264508be584:1-997353:997359-
- 997399,
- b5b70b2f-e55b-11e8-b5a6-1285d1fcc636:1-10 | 0 |
- | | | |
- 0 |
- "error connecting to master 'replication@10.10.10.11:3306'"
- mysql -h 10.10.10.11 -u replication -p
- [client]
- port = 3306
- socket = /tmp/mysql.sock
- [mysql]
- prompt = u@h [d]>_
- no_auto_rehash
- [mysqld]
- user = mysql
- port = 3306
- socket = /tmp/mysql.sock
- #bind-address = 127.0.0.1
- basedir = /usr/local
- datadir = /var/db/mysql
- tmpdir = /var/db/mysql_tmpdir
- slave-load-tmpdir = /var/db/mysql_tmpdir
- secure-file-priv = /var/db/mysql_secure
- log-bin = mysql-bin
- log-output = TABLE
- master-info-repository = TABLE
- relay-log-info-repository = TABLE
- relay-log-recovery = 1
- slow-query-log = 1
- server-id = 2
- sync_binlog = 1
- sync_relay_log = 1
- binlog_cache_size = 16M
- expire_logs_days = 30
- default_password_lifetime = 0
- enforce-gtid-consistency = 1
- gtid-mode = ON
- safe-user-create = 1
- lower_case_table_names = 1
- explicit-defaults-for-timestamp = 1
- myisam-recover-options = BACKUP,FORCE
- open_files_limit = 32768
- table_open_cache = 16384
- table_definition_cache = 8192
- net_retry_count = 16384
- key_buffer_size = 256M
- max_allowed_packet = 64M
- long_query_time = 0.5
- innodb_buffer_pool_size = 1G
- innodb_data_home_dir = /var/db/mysql
- innodb_log_group_home_dir = /var/db/mysql
- innodb_data_file_path = ibdata1:128M:autoextend
- innodb_temp_data_file_path = ibtmp1:128M:autoextend
- innodb_flush_method = O_DIRECT
- innodb_log_file_size = 256M
- innodb_log_buffer_size = 16M
- innodb_write_io_threads = 8
- innodb_read_io_threads = 8
- innodb_autoinc_lock_mode = 2
- skip-symbolic-links
- [mysqldump]
- max_allowed_packet = 256M
- quote_names
- quick
Add Comment
Please, Sign In to add comment