Created
August 28, 2019 23:12
-
-
Save dontstopbelieveing/a20118ace7ba669acb5738312fb5a840 to your computer and use it in GitHub Desktop.
Orchestrator configuration file
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"Debug": false, | |
"EnableSyslog": false, | |
"ListenAddress": ":3000", | |
"MySQLTopologyUser": "orc_client_user", | |
"MySQLTopologyPassword": "orc_client_password", | |
"MySQLTopologyCredentialsConfigFile": "/etc/orchestrator-topology.cnf", | |
"MySQLTopologySSLPrivateKeyFile": "", | |
"MySQLTopologySSLCertFile": "", | |
"MySQLTopologySSLCAFile": "", | |
"MySQLTopologySSLSkipVerify": true, | |
"MySQLTopologyUseMutualTLS": false, | |
"MySQLOrchestratorHost": "10.176.12.138", | |
"MySQLOrchestratorPort": 3115, | |
"MySQLOrchestratorDatabase": "orchestrator", | |
"MySQLOrchestratorUser": "orc_server_user", | |
"MySQLOrchestratorPassword": "orc_server_password", | |
"MySQLOrchestratorCredentialsConfigFile": "/etc/orchestrator-backend.cnf", | |
"MySQLOrchestratorSSLPrivateKeyFile": "", | |
"MySQLOrchestratorSSLCertFile": "", | |
"MySQLOrchestratorSSLCAFile": "", | |
"MySQLOrchestratorSSLSkipVerify": true, | |
"MySQLOrchestratorUseMutualTLS": false, | |
"MySQLConnectTimeoutSeconds": 1, | |
"DefaultInstancePort": 3115, | |
"DiscoverByShowSlaveHosts": true, | |
"InstancePollSeconds": 5, | |
"UnseenInstanceForgetHours": 240, | |
"SnapshotTopologiesIntervalHours": 0, | |
"InstanceBulkOperationsWaitTimeoutSeconds": 10, | |
"HostnameResolveMethod": "default", | |
"MySQLHostnameResolveMethod": "", | |
"SkipBinlogServerUnresolveCheck": true, | |
"ExpiryHostnameResolvesMinutes": 60, | |
"RejectHostnameResolvePattern": "", | |
"ReasonableReplicationLagSeconds": 10, | |
"ProblemIgnoreHostnameFilters": [], | |
"VerifyReplicationFilters": false, | |
"ReasonableMaintenanceReplicationLagSeconds": 20, | |
"CandidateInstanceExpireMinutes": 60, | |
"AuditLogFile": "/var/log/orchestrator-audit.log", | |
"AuditToSyslog": false, | |
"RemoveTextFromHostnameDisplay": ".mydomain.com:3306", | |
"ReadOnly": false, | |
"AuthenticationMethod": "multi", | |
"HTTPAuthUser": "readonly", | |
"HTTPAuthPassword": "", | |
"AuthUserHeader": "", | |
"PowerAuthUsers": [ | |
"*" | |
], | |
"ClusterNameToAlias": { | |
"127.0.0.1": "test suite" | |
}, | |
"SlaveLagQuery": "", | |
"DetectClusterAliasQuery": "SELECT IFNULL(MAX(cluster_name), '') AS cluster_alias FROM meta.cluster WHERE anchor = 1", | |
"DetectClusterDomainQuery": "SELECT IFNULL(MAX(cluster_domain), '') AS cluster_domain FROM meta.cluster WHERE anchor = 1", | |
"DetectInstanceAliasQuery": "", | |
"DetectPromotionRuleQuery": "SELECT value AS promotion_rule FROM meta.variables WHERE name='promotion_rule'", | |
"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": 60, | |
"RecoveryPeriodBlockSeconds": 3600, | |
"RecoveryIgnoreHostnameFilters": [], | |
"RecoverMasterClusterFilters": [ | |
"_master_pattern_" | |
], | |
"RecoverIntermediateMasterClusterFilters": [ | |
"_intermediate_master_pattern_" | |
], | |
"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": [ | |
"/home/mysql/scripts/postfailover_ack.sh", | |
"echo '(for all types) Recovered from {failureType} on {failureCluster}. Failed: {failedHost}:{failedPort}; Successor: {successorHost}:{successorPort}' >> /tmp/recovery.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": [ | |
"/home/mysql/scripts/postgracefulfailover.sh", | |
"/home/mysql/scripts/postgracefulfailover_kill.sh", | |
"echo 'Planned takeover complete' >> /tmp/recovery.log" | |
], | |
"CoMasterRecoveryMustPromoteOtherCoMaster": true, | |
"DetachLostSlavesAfterMasterFailover": true, | |
"ApplyMySQLPromotionAfterMasterFailover": true, | |
"PreventCrossDataCenterMasterFailover": false, | |
"MasterFailoverDetachSlaveMasterHost": false, | |
"MasterFailoverLostInstancesDowntimeMinutes": 0, | |
"PostponeSlaveRecoveryOnLagMinutes": 0, | |
"OSCIgnoreHostnameFilters": [], | |
"GraphiteAddr": "", | |
"GraphitePath": "", | |
"GraphiteConvertHostnameDotsToUnderscores": true, | |
"ConsulAddress": "", | |
"ConsulAclToken": "", | |
"DetectDataCenterQuery": "SELECT value AS dc FROM meta.variables WHERE name = 'data_center'" | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment