Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[question] 主库从库端口号不是默认端口3306,xenon 启动报错的问题 #6

Closed
zeusYi opened this issue May 11, 2018 · 2 comments
Assignees

Comments

@zeusYi
Copy link

zeusYi commented May 11, 2018

拓扑描述:

10.103.70.122 db01(hostname) ---- (主库)
10.103.70.123 db02 (hostname)---- (从库1)
10.103.70.124 db03(hostname) ----(从库2)

下面是3节点的配置文件:
xenon.json(db01).txt
xenon.json(db02).txt
xenon.json(db03).txt

下面是报错日志:

xenon-db01.log.txt
xenon-db02.log.txt
xenon-db03.log.txt

从报错信息:

CANDIDATE[ID:10.103.70.124:8801, V:223, E:2].send.requestvote.to.peer[db02:3306].new.client.error[dial tcp 10.103.70.123:3306: getsockopt: connection refused

可以看出是实例端口问题,xenon找的3306端口,但是实际上我的环境mysql 实例都不是3306,因此报错。

请xenon研发同学帮忙解决!!!

@TCeason
Copy link
Contributor

TCeason commented May 12, 2018

问题出在添加节点步骤。
个人建议:

1. 请在非root用户下进行对Xenon的操作
2. 启动Xenon之后,在进行peer添加的时候,需要保证数据库正常启动,且库之间没有主从关系。
   因为选主操作是依赖raft机制进行投票选取的,不需要自行搭建change master to,很可能会导致其他数据库问题

@weishaolun
Copy link
Contributor

你的peers.json文件怎么配置的,还有你添加节点的指令能说下吗?

@BohuTANG BohuTANG changed the title 主库从库端口号不是默认端口3306,xenon 启动报错的问题 [question] 主库从库端口号不是默认端口3306,xenon 启动报错的问题 Dec 28, 2018
@BohuTANG BohuTANG self-assigned this Dec 28, 2018
TCeason pushed a commit to TCeason/xenon that referenced this issue Apr 19, 2019
Usage:
  xenoncli mysql apply host gtid [flags]

this command try to fix the issue of local gtid is bigger than leader.
TCeason pushed a commit to TCeason/xenon that referenced this issue Apr 19, 2019
feature: add cli for apply binlog to leader from follower radondb#6

Usage:
  xenoncli mysql apply host gtid [flags]

this command try to fix the issue of local gtid is bigger than leader.

See merge request !9
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants