HA

    Namespace: http://shardingsphere.apache.org/schema/shardingsphere/database-discovery/database-discovery-5.1.1.xsd

    <database-discovery:data-source-rule />

    <database-discovery:discovery-type />

    2.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    3.        xmlns:cluster="http://shardingsphere.apache.org/schema/shardingsphere/mode-repository/cluster"
    4.        xmlns:shardingsphere="http://shardingsphere.apache.org/schema/shardingsphere/datasource"
    5.        xmlns:database-discovery="http://shardingsphere.apache.org/schema/shardingsphere/database-discovery"
    6.        xmlns:readwrite-splitting="http://shardingsphere.apache.org/schema/shardingsphere/readwrite-splitting"
    7.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    8.                            http://www.springframework.org/schema/beans/spring-beans.xsd
    9.                            http://shardingsphere.apache.org/schema/shardingsphere/database-discovery
    10.                            http://shardingsphere.apache.org/schema/shardingsphere/database-discovery/database-discovery.xsd
    11.                            http://shardingsphere.apache.org/schema/shardingsphere/readwrite-splitting
    12.                            http://shardingsphere.apache.org/schema/shardingsphere/readwrite-splitting/readwrite-splitting.xsd
    13.                            http://shardingsphere.apache.org/schema/shardingsphere/mode-repository/cluster
    14.                            http://shardingsphere.apache.org/schema/shardingsphere/mode-repository/cluster/repository.xsd
    15.                            http://shardingsphere.apache.org/schema/shardingsphere/datasource
    16.                            http://shardingsphere.apache.org/schema/shardingsphere/datasource/datasource.xsd
    17.                            ">
    18.         <property name="driverClassName" value="com.mysql.jdbc.Driver" />
    19.         <property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:33306/primary_demo_ds?serverTimezone=UTC&amp;useSSL=false&amp;useUnicode=true&amp;characterEncoding=UTF-8" />
    20.         <property name="username" value="root" />
    22.     </bean>
    23.     <bean id="ds_1" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
    24.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    25.         <property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:33307/primary_demo_ds?serverTimezone=UTC&amp;useSSL=false&amp;useUnicode=true&amp;characterEncoding=UTF-8" />
    26.         <property name="username" value="root" />
    27.         <property name="password" value="" />
    28.     </bean>
    29.     <bean id="ds_2" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
    30.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    31.         <property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:33308/primary_demo_ds?useSSL=false"/>
    32.         <property name="username" value="root"/>
    33.         <property name="password" value=""/>
    34.     </bean>
    35.     <cluster:repository id="clusterRepository" type="ZooKeeper" namespace="governance" server-lists="localhost:2181">
    36.         <props>
    37.             <prop key="max-retries">3</prop>
    38.             <prop key="operation-timeout-milliseconds">3000</prop>
    39.         </props>
    40.     </cluster:repository>
    42.             <readwrite-splitting:dynamic-strategy id="dynamicStrategy" auto-aware-data-source-name="readwrite_ds" />
    43.         </readwrite-splitting:data-source-rule>
    44.     </readwrite-splitting:rule>
    45.     <database-discovery:rule id="mgrDatabaseDiscoveryRule">
    46.         <database-discovery:data-source-rule id="readwrite_ds" data-source-names="ds_0,ds_1,ds_2" discovery-heartbeat-name="mgr-heartbeat" discovery-type-name="mgr" />
    47.         <database-discovery:discovery-heartbeat id="mgr-heartbeat">
    48.             <props>
    49.                 <prop key="keep-alive-cron" >0/5 * * * * ?</prop>
    50.             </props>
    51.         </database-discovery:discovery-heartbeat>
    52.     </database-discovery:rule>
    53.     <database-discovery:discovery-type id="mgr" type="MySQL.MGR">
    54.         <props>
    55.             <prop key="group-name">558edd3c-02ec-11ea-9bb3-080027e39bd2</prop>
    56.         </props>
    57.     </database-discovery:discovery-type>
    58.     <shardingsphere:data-source id="databaseDiscoveryDataSource" schema-name="database-discovery-db" data-source-names="ds_0, ds_1, ds_2" rule-refs="readWriteSplittingRule, mgrDatabaseDiscoveryRule">
    59.     <shardingsphere:mode repository-ref="clusterRepository" type="Cluster" />
    60.     </shardingsphere:data-source>
    61. </beans>