Skip to content
New issue

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

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

Already on GitHub? # to your account

关于主从数据不一致的问题 #16

Open
arsArtD opened this issue Jul 11, 2018 · 0 comments
Open

关于主从数据不一致的问题 #16

arsArtD opened this issue Jul 11, 2018 · 0 comments

Comments

@arsArtD
Copy link

arsArtD commented Jul 11, 2018

如下配置:

<mycat:schema xmlns:mycat="http://io.mycat/">

    <schema name="vms" checkSQLschema="false" sqlMaxLimit="100" dataNode="vmsNode"></schema>

    <dataNode name="vmsNode" dataHost="dtHost" database="vms" />

    <dataHost name="dtHost" maxCon="1000" minCon="20" balance="1" writeType="1" dbType="mysql" dbDriver="native" switchType="2" slaveThreshold="100">
    <!--心跳检测 -->
    <heartbeat>show slave status</heartbeat>
    <writeHost host="hostM1" url="192.168.3.11:3306" user="root" password="123456"></writeHost>

    <writeHost host="hostM2" url="192.168.3.12:3306" user="root" password="123456"></writeHost>
</dataHost>

</mycat:schema>

当192.168.3.11上的mysql实例sql_thread停掉时,通过mycat读取的数据是有问题的。当mycat的读负载到192.168.3.12是全量的数据,负载到192.168.3.11的时候缺少数据。

192.168.3.11和192.168.3.12做的双向同步。

请问有什么方法可以在某台writeHost sql_thread有问题时,将其踢掉吗?

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

No branches or pull requests

1 participant