各位老师好:
我在github上面看到有人提出 MySQL高可用切换问题,其中有老师的回答是:
All the relationships of data sources and sharding rules are stored in registry center.
You or your program need to update the new master info on the registry center, and it will push this event online.
ShardingSphere can not handle the failover of MySQL, but it can push the info of new masters and slaves to all the proxy or JDBC clients online.
我的问题是:
-
如何 update the new master info on the registry center?
– 直接修改zookeeper的值? 还是在shrding proxy中用 RDL修改 -
每个逻辑库都对应自己的 datasource,有无一个方法只修改一个公共的DataSource的
/governance_ds/metadata/sharding_db/逻辑库1/versions/0/dataSources
/governance_ds/metadata/sharding_db/逻辑库2/versions/0/dataSources
…
/governance_ds/metadata/sharding_db/逻辑库n/versions/0/dataSources -
当MySQL发生高可用切换,修改zookeeper或者使用RDL修改,sharding-proxy需要多久时间才能生效?是否有间隔等