backup 的启动 .............................................................................. 16 4 Heartbeat 高可用 Mysql 主主同步方案 .............................................................................. ........................ 17 4.5.5 Heartbeat 的配置 .......................................................................................... 18 4.5.6 Heartbeat 的启动 ................................ ...................................................................................... 19 5 Heartbeat+DRBD+mysql 高可用方案 ..............................................................................

discoveryHeartbeatName: # Detect heartbeat name discoveryTypeName: # Database discovery type name # Heartbeat Configuration discoveryHeartbeats: heartbeat-name> (+): # heartbeat name props: keep-alive-cron: dataSourceNames: - ds_0 - ds_1 - ds_2 discoveryHeartbeatName: mgr-heartbeat discoveryTypeName: mgr discoveryHeartbeats: mgr-heartbeat: props: keep-alive-cron: '0/5 * * * * ?' discoveryTypes: mgr: dataSourceNames: # Data source name list - ds_0 - ds_1 - ds_2 discoveryHeartbeatName: # Detect heartbeat name discoveryTypeName: # Database discovery type name : dataSourceNames: #

discoveryHeartbeatName: # Detect heartbeat name 4.1. ShardingSphere-JDBC 66 Apache ShardingSphere document, v5.2.0 discoveryTypeName: # Database discovery type name # Heartbeat Configuration discoveryHeartbeats: discoveryHeartbeats: heartbeat-name> (+): # heartbeat name props: keep-alive-cron: # This is cron expression, such as：'0/5 * * * * ?' # Database Discovery Configuration discoveryTypes: dataSourceNames: - ds_0 - ds_1 - ds_2 discoveryHeartbeatName: mgr-heartbeat discoveryTypeName: mgr discoveryHeartbeats: mgr-heartbeat: props: keep-alive-cron: '0/5 * * * * ?' discoveryTypes: mgr:

discoveryHeartbeatName: # 检测心跳名称 discoveryTypeName: # 数据库发现类型名称 # 心跳检测配置 discoveryHeartbeats: heartbeat-name> (+): # 心跳名称 props: keep-alive-cron: # cron 表达式，如：'0/5 * * * * ?' # 数据库发现类型配置 discoveryTypes: dataSourceNames: - ds_0 - ds_1 - ds_2 discoveryHeartbeatName: mgr-heartbeat discoveryTypeName: mgr discoveryHeartbeats: mgr-heartbeat: props: keep-alive-cron: '0/5 * * * * ?' discoveryTypes: mgr: discoveryHeartbeatName: # 检测心跳名称 discoveryTypeName: # 数据库发现类型名称 discoveryHeartbeats: heartbeat-name>: # 心跳名称 props: keep-alive-cron: # cron 表达式，如：'0/5 * * * * ?' discoveryTypes: :

discover yHeart‐ beats (+) Map Detect heartbeat configura‐ tion dis coveryTypes (+) Map Database • disc overyHear tbeat‐ Name (+) String Detect heartbeat name • discover yTypeName (+) String Database discovery type name • Detect Heartbeat Configuration Class name：org.apache.shardingsphere tion Attributes： Name Dat aType Description D ef au lt Va lu e props (+) Prop erties Detect heartbeat attribute configura‐ tion, keep‐alive‐cron configuration, cron expression. Such as: ‘0/5 *

discover yHeart‐ beats (+) Map Detect heartbeat configura‐ tion dis coveryTypes (+) Map Database • disc overyHear tbeat‐ Name (+) String Detect heartbeat name • discover yTypeName (+) String Database discovery type name • Detect Heartbeat Configuration Class name：org.apache.shardingsphere ration Attributes： Name Data Type Description D efa ult Val ue props (+) Prope rties Detect heartbeat attribute configura‐ tion, keep‐alive‐cron configuration, cron expression. Such as: ‘0/5 *

Secondary heartbeat Secondary Secondary 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 高可用 Secondary Secondary heartbeat Secondary Secondary Primary Client Client heartbeat heartbeat Client Secondary Secondary heartbeat Arbiter vote only Arbiter 节点只参与 投票，不存储数据 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 选举优先级 Primary Secondary Secondary heartbeat Secondary priority Primary Secondary Secondary heartbeat Hidden Hidden mongodump 对客户端不可见 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 延迟节点 Primary Secondary Secondary heartbeat Delayed Delayed mongodump

discoveryHeartbeatName: # 检测心跳名称 discoveryTypeName: # 数据库发现类型名称 # 心跳检测配置 discoveryHeartbeats: heartbeat-name> (+): # 心跳名称 props: keep-alive-cron: # cron 表达式，如：'0/5 * * * * ?' # 数据库发现类型配置 discoveryTypes: shardingsphere.rules.database-discovery.data-sources..discovery-heartbeat-name= # 检测心跳名称 spring.shardingsphere.rules.database-discovery.data-sources.heartbeat-name>.props.keep-alive-cron= # cron 表达式，如：'0/5 * * * * ?' spring.shardingsphere.rules.database-discovery

discoveryHeartbeatName: # 检测心跳名称 discoveryTypeName: # 数据库发现类型名称 # 心跳检测配置 discoveryHeartbeats: heartbeat-name> (+): # 心跳名称 props: keep-alive-cron: # cron 表达式，如：'0/5 * * * * ?' # 数据库发现类型配置 discoveryTypes: shardingsphere.rules.database-discovery.data-sources..discovery-heartbeat-name= # 检测心跳名称 spring.shardingsphere.rules.database-discovery.data-sources.heartbeat-name>.props.keep-alive-cron= # cron 表达式，如：'0/5 * * * * ?' spring.shardingsphere.rules.database-discovery

discoveryHeartbeatName: # 检测心跳名称 discoveryTypeName: # 数据库发现类型名称 # 心跳检测配置 discoveryHeartbeats: heartbeat-name> (+): # 心跳名称 props: keep-alive-cron: # cron 表达式，如：'0/5 * * * * ?' # 数据库发现类型配置 discoveryTypes: 1. ShardingSphere-JDBC 97 Apache ShardingSphere document, v5.1.2 data-source-name>.discovery-heartbeat-name= # 检测心跳名称 spring.shardingsphere.rules.database-discovery.data-sources.heartbeat-name>.props.keep-alive-cron= # cron 表达式，如：'0/5 * * * * ?' spring.shardingsphere.rules.database-discovery