mysql下载是port报错_mysql group replication添加复制节点报错

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

恳求各位大神给把把脉，到底问题处在那个环节

环境： 三台物理机 192.168.1.3 192.168.1.4 192.168.1.5

配置文件：

[mysqld]

basedir=/usr/local/mysql

datadir=/var/lib/mysqlserver_id=1

port=3306

socket=/var/run/mysqld/mysql.sock

character-set-server=utf8mb4

collation-server=utf8mb4_general_ci

default-storage-engine=INNODBskip-name-resolve#Optimize

max_connections = 500

innodb_flush_log_at_trx_commit = 1

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO

explicit_defaults_for_timestamp=truelog-bin=binlog

log_bin_trust_function_creators=1

binlog_format=ROW

expire_logs_days=99

relay-log=s3-relay-binsync_binlog=0

slow-query-log=1

slow-query-log-file=/var/log/mysql/slow-queries.log

long_query_time=0.5

#log-queries-not-using-indexes

log-error=/var/log/mysql/mysql.err

gtid_mode=ON

enforce_gtid_consistency=ON

master_info_repository=TABLE

relay_log_info_repository=TABLE

relay_log_recovery = ON

binlog_checksum=NONE

log_slave_updates=ONplugin-load=group_replication.so

transaction_write_set_extraction = XXHASH64

loose-group_replication_group_name = 33847171-5f22-11e7-b03b-080027d9d784loose-group_replication_start_on_boot = off

loose-group_replication_local_address = 192.168.1.3:13306

loose-group_replication_group_seeds = 192.168.1.3:13306,192.168.1.4:13306,192.168.1.5:13306

loose-group_replication_bootstrap_group= off

loose-group_replication_single_primary_mode=TRUE

loose-group_replication_enforce_update_everywhere_checks=FALSEgroup_replication_allow_local_disjoint_gtids_join=ON

group-replication-auto-increment-increment=3

[client]

default-character-set=utf8mb4

port=3306

socket = /var/run/mysqld/mysql.sock

报错信息

2018-04-06T17:56:58.309067Z 2501 [Note] Plugin group_replication reported: '[GCS] SSL was not enabled'

2018-04-06T17:56:58.309094Z 2501 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: "33847171-5f22-11e7-b03b-080027d9d784"; group_replication_local_address: "192.168.1.5:13306"; group_replication_group_seeds: "192.168.1.3:13306,192.168.1.4:13306,192.168.1.5:13306"; group_replication_bootstrap_group: false; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1000000; group_replication_ip_whitelist: "127.0.0.1/32,10.0.0.0/8,172.16.0.0/12,192.168.0.0/16,192.168.1.0/24"'

2018-04-06T17:56:58.309146Z 2501 [Note] Plugin group_replication reported: 'Member configuration: member_id: 3; member_uuid: "22b95cdd-5f38-11e7-b20c-1866da8c2fcd"; single-primary mode: "true"; group_replication_auto_increment_increment: 3; '

2018-04-06T17:56:58.309619Z 3029 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.

2018-04-06T17:56:58.517855Z 3032 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './s5-relay-bin-group_replication_applier.000001' position: 4

2018-04-06T17:56:58.517855Z 2501 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'

2018-04-06T17:56:58.517901Z 2501 [Note] Plugin group_replication reported: 'auto_increment_increment is set to 3'

2018-04-06T17:56:58.517907Z 2501 [Note] Plugin group_replication reported: 'auto_increment_offset is set to 3'

2018-04-06T17:56:58.518002Z 0 [Note] Plugin group_replication reported: 'state 4338 action xa_init'

2018-04-06T17:56:58.518035Z 0 [Note] Plugin group_replication reported: 'Successfully bound to 0.0.0.0:13306 (socket=99).'

2018-04-06T17:56:58.518056Z 0 [Note] Plugin group_replication reported: 'Successfully set listen backlog to 32 (socket=99)!'

2018-04-06T17:56:58.518062Z 0 [Note] Plugin group_replication reported: 'Successfully unblocked socket (socket=99)!'

2018-04-06T17:56:58.518091Z 0 [Note] Plugin group_replication reported: 'Ready to accept incoming connections on 0.0.0.0:13306 (socket=99)!'

2018-04-06T17:56:58.518094Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.5 13306'

2018-04-06T17:56:58.518213Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.1.5 13306 fd 1234'

2018-04-06T17:56:58.518356Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.5 13306'

2018-04-06T17:56:58.518425Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.1.5 13306 fd 1236'

2018-04-06T17:56:58.518519Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.5 13306'

2018-04-06T17:56:58.518589Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.1.5 13306 fd 1238'

2018-04-06T17:56:58.518785Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.5 13306'

2018-04-06T17:56:58.518841Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.1.5 13306 fd 1240'

2018-04-06T17:56:58.518961Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.5 13306'

2018-04-06T17:56:58.519015Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.1.5 13306 fd 1241'

2018-04-06T17:56:58.519129Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.5 13306'

2018-04-06T17:56:58.519207Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.1.5 13306 fd 1246'

2018-04-06T17:56:58.519332Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.3 13306'

2018-04-06T17:56:58.519385Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.3 with error 111 -Connection refused.'

2018-04-06T17:56:58.519404Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.3:13306 on local port: 13306.'

2018-04-06T17:56:58.519412Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.4 13306'

2018-04-06T17:56:58.519456Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.4 with error 111 -Connection refused.'

2018-04-06T17:56:58.519468Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.4:13306 on local port: 13306.'

2018-04-06T17:56:58.519476Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.3 13306'

2018-04-06T17:56:58.519508Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.3 with error 111 -Connection refused.'

2018-04-06T17:56:58.519518Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.3:13306 on local port: 13306.'

2018-04-06T17:56:58.519524Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.4 13306'

2018-04-06T17:56:58.519557Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.4 with error 111 -Connection refused.'

2018-04-06T17:56:58.519568Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.4:13306 on local port: 13306.'

2018-04-06T17:56:58.519574Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.3 13306'

2018-04-06T17:56:58.519604Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.3 with error 111 -Connection refused.'

2018-04-06T17:56:58.519613Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.3:13306 on local port: 13306.'

2018-04-06T17:56:58.519631Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.4 13306'

2018-04-06T17:56:58.519670Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.4 with error 111 -Connection refused.'

2018-04-06T17:56:58.519680Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.4:13306 on local port: 13306.'

2018-04-06T17:56:58.519688Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.3 13306'

2018-04-06T17:56:58.519746Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.3 with error 111 -Connection refused.'

2018-04-06T17:56:58.519757Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.3:13306 on local port: 13306.'

2018-04-06T17:56:58.519764Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.4 13306'

2018-04-06T17:56:58.519795Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.4 with error 111 -Connection refused.'

2018-04-06T17:56:58.519805Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.4:13306 on local port: 13306.'

2018-04-06T17:56:58.519812Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.3 13306'

2018-04-06T17:56:58.519848Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.3 with error 111 -Connection refused.'

2018-04-06T17:56:58.519858Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.3:13306 on local port: 13306.'

2018-04-06T17:56:58.519872Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.4 13306'

2018-04-06T17:56:58.519905Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.4 with error 111 -Connection refused.'

2018-04-06T17:56:58.519915Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.4:13306 on local port: 13306.'

2018-04-06T17:56:58.519923Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.3 13306'

2018-04-06T17:56:58.519954Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.3 with error 111 -Connection refused.'

2018-04-06T17:56:58.519964Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.3:13306 on local port: 13306.'

2018-04-06T17:56:58.519972Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.4 13306'

2018-04-06T17:56:58.520011Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.4 with error 111 -Connection refused.'

2018-04-06T17:56:58.520022Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.4:13306 on local port: 13306.'

2018-04-06T17:56:58.520030Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.3 13306'

2018-04-06T17:56:58.520060Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.3 with error 111 -Connection refused.'

2018-04-06T17:56:58.520070Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.3:13306 on local port: 13306.'

2018-04-06T17:56:58.520078Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.4 13306'

2018-04-06T17:56:58.520108Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.4 with error 111 -Connection refused.'

2018-04-06T17:56:58.520129Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.4:13306 on local port: 13306.'

2018-04-06T17:56:58.520140Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.3 13306'

2018-04-06T17:56:58.520173Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.3 with error 111 -Connection refused.'

2018-04-06T17:56:58.520184Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.3:13306 on local port: 13306.'

2018-04-06T17:56:58.520190Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.4 13306'

2018-04-06T17:56:58.520221Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.4 with error 111 -Connection refused.'

2018-04-06T17:56:58.520231Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.4:13306 on local port: 13306.'

2018-04-06T17:56:58.520240Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.3 13306'

2018-04-06T17:56:58.520274Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.3 with error 111 -Connection refused.'

2018-04-06T17:56:58.520284Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.3:13306 on local port: 13306.'

2018-04-06T17:56:58.520292Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.4 13306'

2018-04-06T17:56:58.520323Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.4 with error 111 -Connection refused.'

2018-04-06T17:56:58.520333Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.4:13306 on local port: 13306.'

2018-04-06T17:56:58.520341Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.3 13306'

2018-04-06T17:56:58.520370Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.3 with error 111 -Connection refused.'

2018-04-06T17:56:58.520386Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.3:13306 on local port: 13306.'

2018-04-06T17:56:58.520392Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.1.4 13306'

2018-04-06T17:56:58.520427Z 0 [Note] Plugin group_replication reported: 'Getting the peer name failed while connecting to server 192.168.1.4 with error 111 -Connection refused.'

2018-04-06T17:56:58.520437Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.1.4:13306 on local port: 13306.'

2018-04-06T17:56:58.520447Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 13306'

2018-04-06T17:56:58.520502Z 0 [Note] Plugin group_replication reported: 'state 4338 action xa_terminate'

2018-04-06T17:56:58.520525Z 0 [Note] Plugin group_replication reported: 'new state x_start'

2018-04-06T17:56:58.520531Z 0 [Note] Plugin group_replication reported: 'state 4338 action xa_exit'

2018-04-06T17:56:58.520610Z 0 [Note] Plugin group_replication reported: 'Exiting xcom thread'

2018-04-06T17:56:58.520618Z 0 [Note] Plugin group_replication reported: 'new state x_start'

2018-04-06T17:56:58.520662Z 0 [Warning] Plugin group_replication reported: 'read failed'

2018-04-06T17:56:58.543318Z 0 [ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 13306'

2018-04-06T17:57:58.517998Z 2501 [ERROR] Plugin group_replication reported: 'Timeout on wait for view after joining group'

2018-04-06T17:57:58.518039Z 2501 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'

2018-04-06T17:57:58.518059Z 2501 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'

2018-04-06T17:57:58.518179Z 2501 [Note] Plugin group_replication reported: 'auto_increment_increment is reset to 1'

2018-04-06T17:57:58.518200Z 2501 [Note] Plugin group_replication reported: 'auto_increment_offset is reset to 1'

2018-04-06T17:57:58.518309Z 3032 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed

2018-04-06T17:57:58.617325Z 3029 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'

2018-04-06T17:57:59.628840Z 3044 [Note] Aborted connection 3044 to db: 'unconnected' user: 'proxysql' host: '192.168.1.4' (Got an error writing communication packets)