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

phxsql的配置问题 #151

Open
bonnielove opened this issue Jan 18, 2018 · 1 comment
Open

phxsql的配置问题 #151

bonnielove opened this issue Jan 18, 2018 · 1 comment

Comments

@bonnielove
Copy link

我在两台Linux上部署了PhxSQL,配置为4核 16G内存,能够正常使用。
但是在做性能测试的时候发现比单独一台mysql5.7的慢一倍,想来是没配置好。
在修改phxsql配置的时候有点无从下手,有好几个参数都没有说明具体是做什么用的。

MasterForkProcCnt = 5
MasterWorkerThread = 8
MasterIORoutineCnt = 100
SlaveForkProcCnt = 5
SlaveWorkerThread = 8
SlaveIORoutineCnt = 100
MasterEnableReadPort = 1
ProxyProtocol = 2

phxsqlproxy.conf中只有MasterEnableReadPort 参数有说明,其他参数都是什么含义呢?

另外只有两台集群的情况下,master挂了,slave还能转为master正常工作吗?我试了下是不行的,还请大神解答一下。。。

@zhaowengxing
Copy link

我测试过,只有一台机器时是不能正常工作;如果另外一台挂掉的机器重新工作,集群会恢复工作。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants