場景：
用于管理MySQL高可用

1. 下載jq包
   每臺orchestrator集群機器上都進行下載。

# wget http://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
# rpm -ivh epel-release-latest-7.noarch.rpm
# yum repolist ###檢查是否已經添加到源列表
# yum install -y jq

2. 添加域名解析
   若Orchestrator啟用域名作為管理，編輯/etc/hosts（不采用該方式）
   
   注：若直接用ip管理，不啟用域名管理集群，則不需要配置。需要在orchestrator配置文件里設定以下兩個參數為：
   

3. 后端數據庫設置
   Create database orchestrator;
   CREATE USER ‘orchestrator’@‘%’ IDENTIFIED BY ‘orchestrator’;
   GRANT ALL ON orchestrator.* TO ‘orchestrator’@‘%’;

4. 被管理的mysql集群設置

1. 用戶授權
   CREATE USER ‘orchestrator’@‘%’ IDENTIFIED BY ‘orchestrator’;
   GRANT SUPER, PROCESS, REPLICATION SLAVE, RELOAD ON . TO ‘orchestrator’@‘%’;
   GRANT SELECT ON mysql.slave_master_info TO ‘orchestrator’@‘%’;

GRANT SELECT ON performance_schema.replication_group_members TO ‘orchestrator’@‘%’;
2) 設置report_host參數
orchestrator使用ip進行管理，MySQL配置文件需要加report_host參數。

如若出現給定主庫，發現不了從庫，給被管理的mysql服務配置文件添加“report_host=ip”的參數，然后重啟mysql服務生效。
由主庫發現從庫，由參數DiscoverByShowSlaveHosts控制。如果為true，則會嘗試先通過show slave hosts命令去發現從庫。
從庫設置了正確的report_host，show slave hosts中的host字段顯示正確的IP，則直接通過show slave hosts發現從庫。
從庫沒有設置report_host，show slave hosts中的host字段顯示為空，則通過processlist發現從庫。
5. 配置文件說明
安裝包有提供模板
/usr/local/orchestrator/ orchestrator-sample.conf.json ,在模板上根據具體情況進行參數填寫，然后重命名orchestrator.conf.json，放到/etc目錄下，
需要設置的基本參數及說明如下：

ListenAddress web界面的http端口
MySQLTopologyUser 被管理的MySQL的用戶（明文）
MySQLTopologyPassword 被管理的MySQL的密碼（密文）
MySQLOrchestratorHost orch后端數據庫地址
MySQLOrchestratorPort orch后端數據庫端口
MySQLOrchestratorDatabase orch后端數據庫名
MySQLOrchestratorUser orch后端數據庫用戶名（明文）
MySQLOrchestratorPassword orch后端數據庫密碼（明文）
DefaultInstancePort 被管理MySQL的默認端口
RaftEnabled 是否開啟Raft，保證orch的高可用。
RaftDataDir Raft的數據目錄
BackendDB 后端數據庫類型。
RaftBind Raft 的 bind地址，每臺機器填自己的ip
DefaultRaftPort DefaultRaftPort
RaftNodes Raft的節點。

示例：

{"Debug": true,"EnableSyslog": false,"ListenAddress": ":3000","MySQLTopologyUser": "orchestrator","MySQLTopologyPassword": "orch`123qwer","MySQLTopologyCredentialsConfigFile": "","MySQLTopologySSLPrivateKeyFile": "","MySQLTopologySSLCertFile": "","MySQLTopologySSLCAFile": "","MySQLTopologySSLSkipVerify": true,"MySQLTopologyUseMutualTLS": false,"MySQLOrchestratorHost": "127.0.0.1","MySQLOrchestratorPort": 3305,"MySQLOrchestratorDatabase": "orchestrator","MySQLOrchestratorUser": "orchestrator","MySQLOrchestratorPassword": "orchestrator","MySQLOrchestratorCredentialsConfigFile": "","MySQLOrchestratorSSLPrivateKeyFile": "","MySQLOrchestratorSSLCertFile": "","MySQLOrchestratorSSLCAFile": "","MySQLOrchestratorSSLSkipVerify": true,"MySQLOrchestratorUseMutualTLS": false,"MySQLConnectTimeoutSeconds": 1,"DefaultInstancePort": 3305,"DiscoverByShowSlaveHosts": true,"InstancePollSeconds": 5,"DiscoveryIgnoreReplicaHostnameFilters": ["a_host_i_want_to_ignore[.]example[.]com",".*[.]ignore_all_hosts_from_this_domain[.]example[.]com","a_host_with_extra_port_i_want_to_ignore[.]example[.]com:3307"],"UnseenInstanceForgetHours": 240,"SnapshotTopologiesIntervalHours": 0,"InstanceBulkOperationsWaitTimeoutSeconds": 10,"HostnameResolveMethod": "none","MySQLHostnameResolveMethod": "","SkipBinlogServerUnresolveCheck": true,"ExpiryHostnameResolvesMinutes": 60,"RejectHostnameResolvePattern": "","ReasonableReplicationLagSeconds": 10,"ProblemIgnoreHostnameFilters": [],"VerifyReplicationFilters": false,"ReasonableMaintenanceReplicationLagSeconds": 20,"CandidateInstanceExpireMinutes": 60,"AuditLogFile": "","AuditToSyslog": false,"RemoveTextFromHostnameDisplay": ".mydomain.com:3306","ReadOnly": false,"AuthenticationMethod": "basic","HTTPAuthUser": "orchestrator","HTTPAuthPassword": "orchestrator","AuthUserHeader": "","PowerAuthUsers": ["*"],"ClusterNameToAlias": {"127.0.0.1": "test suite"},"ReplicationLagQuery": "","DetectClusterAliasQuery": "SELECT SUBSTRING_INDEX(@@hostname, '.', 1)","DetectClusterDomainQuery": "","DetectInstanceAliasQuery": "","DetectPromotionRuleQuery": "","DataCenterPattern": "[.]([^.]+)[.][^.]+[.]mydomain[.]com","PhysicalEnvironmentPattern": "[.]([^.]+[.][^.]+)[.]mydomain[.]com","PromotionIgnoreHostnameFilters": [],"DetectSemiSyncEnforcedQuery": "","ServeAgentsHttp": false,"AgentsServerPort": ":3001","AgentsUseSSL": false,"AgentsUseMutualTLS": false,"AgentSSLSkipVerify": false,"AgentSSLPrivateKeyFile": "","AgentSSLCertFile": "","AgentSSLCAFile": "","AgentSSLValidOUs": [],"UseSSL": false,"UseMutualTLS": false,"SSLSkipVerify": false,"SSLPrivateKeyFile": "","SSLCertFile": "","SSLCAFile": "","SSLValidOUs": [],"URLPrefix": "","StatusEndpoint": "/api/status","StatusSimpleHealth": true,"StatusOUVerify": false,"AgentPollMinutes": 60,"UnseenAgentForgetHours": 6,"StaleSeedFailMinutes": 60,"SeedAcceptableBytesDiff": 8192,"PseudoGTIDPattern": "","PseudoGTIDPatternIsFixedSubstring": false,"PseudoGTIDMonotonicHint": "asc:","DetectPseudoGTIDQuery": "","BinlogEventsChunkSize": 10000,"SkipBinlogEventsContaining": [],"ReduceReplicationAnalysisCount": true,"FailureDetectionPeriodBlockMinutes": 1,"FailMasterPromotionOnLagMinutes": 0,"RecoveryPeriodBlockSeconds": 60,"RecoveryIgnoreHostnameFilters": [],"RecoverMasterClusterFilters": ["*"],"RecoverIntermediateMasterClusterFilters": ["*"],"OnFailureDetectionProcesses": ["echo 'Detected {failureType} on {failureCluster}. Affected replicas: {countSlaves}' >> /tmp/recovery.log"],"PreGracefulTakeoverProcesses": ["echo 'Planned takeover about to take place on {failureCluster}. Master will switch to read_only' >> /tmp/recovery.log"],"PreFailoverProcesses": ["echo 'Will recover from {failureType} on {failureCluster}' >> /tmp/recovery.log"],"PostFailoverProcesses": ["echo '(for all types) Recovered from {failureType} on {failureCluster}. Failed: {failedHost}:{failedPort}; Successor: {successorHost}:{successorPort}' >> /tmp/recovery.log","source /usr/local/orchestrator/script/orch_hook.sh {failureType} {failureClusterAlias} {failedHost} {successorHost} >> /tmp/orch_vip.log","source /usr/local/orchestrator/script/dble.sh {failureType} {failureClusterAlias} {failedHost} {successorHost} >> /tmp/orch_dble.log"],"PostUnsuccessfulFailoverProcesses": [],"PostMasterFailoverProcesses": ["echo 'Recovered from {failureType} on {failureCluster}. Failed: {failedHost}:{failedPort}; Promoted: {successorHost}:{successorPort}' >> /tmp/recovery.log"],"PostIntermediateMasterFailoverProcesses": ["echo 'Recovered from {failureType} on {failureCluster}. Failed: {failedHost}:{failedPort}; Successor: {successorHost}:{successorPort}' >> /tmp/recovery.log"],"PostGracefulTakeoverProcesses": ["echo 'Planned takeover complete' >> /tmp/recovery.log"],"CoMasterRecoveryMustPromoteOtherCoMaster": true,"DetachLostSlavesAfterMasterFailover": true,"ApplyMySQLPromotionAfterMasterFailover": true,"PreventCrossDataCenterMasterFailover": false,"PreventCrossRegionMasterFailover": false,"MasterFailoverDetachReplicaMasterHost": false,"MasterFailoverLostInstancesDowntimeMinutes": 0,"PostponeReplicaRecoveryOnLagMinutes": 0,"OSCIgnoreHostnameFilters": [],"GraphiteAddr": "","GraphitePath": "","GraphiteConvertHostnameDotsToUnderscores": true,"RaftEnabled": true,"BackendDB": "mysql","RaftBind": "1xx.1x.x.146","RaftDataDir": "/home/data/orchestrator","DefaultRaftPort": 10008,"RaftNodes": ["1xx.1x.x.146","1xx.1x.x.147","1xx.1x.x.148"],"ConsulAddress": "","ConsulAclToken": "","ConsulKVStoreProvider": "consul"
}

6. 啟動服務
   在每臺orchestrator集群機器的orchestrator安裝目錄下，運行：
   ./orchestrator --debug --config=/etc/orchestrator.conf.json http

7. systemctl托管服務
   解壓orchestrator壓縮包時，在
   /usr/local/etc/systemd/system目錄下會有托管文件：orchestrator.service。 將其移動到/usr/lib/systemd/system/orchestrator.service。內容如下：
   
   啟動：systemctl start orchestrator

8. 登錄web界面
   登錄URL：1xx.1x.3.146:3000 或1xx.1x.3.147:3000 或 1xx.1x.3.148:3000