MySQL高可用工具—Orchestrator初识

亦凉 2023-09-28 21:37 20阅读 0赞

Orchestrator是一款开源的MySQL复制拓扑管理工具，采用go语言编写，支持MySQL主从复制拓扑关系的调整、支持MySQL主库故障自动切换、手动主从切换等功能。

Orchestrator后台依赖于MySQL或者SQLite存储元数据，能够提供Web界面展示MySQL集群的拓扑关系及实例状态，通过Web界面可更改MySQL实例的部分配置信息，同时也提供命令行和api接口，以便更加灵活的自动化[运维][Link 1]管理。

相比于MHA，Orchestrator更加偏重于复制拓扑关系的管理，能够实现MySQL任一复制拓扑关系的调整，并在此基础上，实现MySQL高可用，另外Orchestrator自身可以部署多个节点，通过raft分布式一致性协议，保证自身的高可用。

**环境说明**

<table> 
 <thead> 
  <tr> 
   <th> <p></p> </th> 
   <th> <p>后台管理节点</p> </th> 
   <th> <p>被监测MYSQL集群</p> </th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td> <p>IP</p> </td> 
   <td> <p>11.11.10.10</p> </td> 
   <td> <p>11.21.193.85:335811.42.212.23:335811.42.210.106:3358</p> </td> 
  </tr> 
  <tr> 
   <td> <p>操作系统</p> </td> 
   <td> <p>CentOS 7.2</p> </td> 
   <td> <p>CentOS 7.2</p> </td> 
  </tr> 
  <tr> 
   <td> <p>Orchestrator</p> </td> 
   <td> <p>orchestrator-3.1.2-1.x86_64.rpmorchestrator-cli-3.1.2-1.x86_64.rpmorchestrator-client-3.1.2-1.x86_64.rpm</p> </td> 
   <td> <p></p> </td> 
  </tr> 
  <tr> 
   <td> <p>MYSQL‍</p> </td> 
   <td> <p>mysql5.7</p> </td> 
   <td> <p>mysql5.6以上，开启GTID复制</p> </td> 
  </tr> 
 </tbody> 
</table>

**后台管理节点** CentOS Linux release 7.2以上，不然可能会出现缺少依赖包。

安装[MySQL数据库][MySQL]，在启动Orchestrator程序的时候，会自动在[数据库][Link 2]里创建orchestrator数据库，保存orchestrator的一些数据信息。

**下载安装包**

https://github.com/github/orchestrator/releaseswget https://github.com/github/orchestrator/releases/download/v3.1.2/orchestrator-3.1.2-1.x86_64.rpm         -服务包wget https://github.com/github/orchestrator/releases/download/v3.1.2/orchestrator-cli-3.1.2-1.x86_64.rpm     -二进制命令wget https://github.com/github/orchestrator/releases/download/v3.1.2/orchestrator-client-3.1.2-1.x86_64.rpm  -命令行工具

复制

**安装**

[root@localhost ~]# rpm -ivh orchestrator-*Preparing...                          ################################# [100%]Updating / installing...   1:orchestrator-cli-1:3.1.2-1       ################################# [100%]Preparing...                          ################################# [100%]Updating / installing...   1:orchestrator-1:3.1.2-1           ################################# [100%]

复制

安装后会在/usr/local下生成orchestrator目录，包含以下文件和目录：

<table> 
 <thead> 
  <tr> 
   <th> <p>orchestrator-sample-sqlite.conf.json</p> </th> 
   <th> <p>采用SQLite库模板</p> </th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td> <p>orchestrator-sample.conf.json</p> </td> 
   <td> <p>默认的配置模板</p> </td> 
  </tr> 
  <tr> 
   <td> <p>orchestrator</p> </td> 
   <td> <p>应用程序</p> </td> 
  </tr> 
  <tr> 
   <td> <p>resources</p> </td> 
   <td> <p>orchestrator相关的文件：client、web、伪GTID等相关文件</p> </td> 
  </tr> 
 </tbody> 
</table>

**创建后台管理节点的库和用户**

CREATE DATABASE IF NOT EXISTS orchestrator;GRANT ALL PRIVILEGES ON `orchestrator`.* TO 'orc_server_user'@'%' IDENTIFIED BY 'server_passwd';

复制

**被监测的MYSQL授权**

GRANT SUPER, PROCESS, REPLICATION SLAVE, RELOAD ON *.* TO 'orc_client_user'@'%' IDENTIFIED BY 'client_passwd';

复制

**修改配置文件**

cp orchestrator-sample.conf.json orchestrator.conf.json

"Debug": false,                               #设置Debug方式  "EnableSyslog": false,                        #是否把日志输出到系统日志里  "ListenAddress": ":3000",                     #web端口  "MySQLTopologyUser": "orc_client_user",       #被监测的MYSQL实例用户  "MySQLTopologyPassword": "client_passwd",     #被监测的MYSQL实例密码  "MySQLOrchestratorHost": "11.11.10.10",       #后台管理主机  "MySQLOrchestratorPort": 3306,                #后台管理库端口  "MySQLOrchestratorDatabase": "orchestrator",  #后台管理库名  "MySQLOrchestratorUser": "orc_server_user",   #后台管理库用户  "MySQLOrchestratorPassword": "server_passwd", #后台管理库密码  "MySQLHostnameResolveMethod": "@@report_host",#解析主机名方式  "DetectClusterAliasQuery": "SELECT concat(@@report_host,':',@@port)", #集群别名

复制

官方参考配置：https://github.com/github/orchestrator/blob/master/docs/configuration-sample.md

配置参数解释：[MySQL高可用工具—Orchestrator配置说明][MySQL_Orchestrator]

**启动**

/usr/local/orchestrator/orchestrator -config=/usr/local/orchestrator/orchestrator.conf.json http &

复制

**查看端口**

[root@localhost orchestrator]# netstat  -nltp|grep 3000tcp6       0      0 :::3000                 :::*                    LISTEN      574969/orchestrator

复制

**命令行注册集群**

orchestrator -config=/usr/local/orchestrator/orchestrator.conf.json -c discover -i 192.168.1.2:3306

复制

**命令行查看集群**

orchestrator -c clusters

复制

**通过web访问**

http://11.11.10.10:3000

![c3717fca355f619bf5658ff6c8b93ea2.png][]

**页面中discover**

![cff054881ea1f6eb44be1f89fc5e0ece.png][]

![ae2ed7f370204342a1d6aa8253398dee.png][]

查看集群架构

![24fc21b730d0f7ec7e653843c60d7d5a.jpeg][]

**拖动更改架构**

![fbf692372d74f4f3d070bd2065ce98a6.png][]

![1e9ac6557667ae896032f60bba1f4419.gif][]

![e7fc9535cef2be28b25e012371a4a660.png][]

![1e9ac6557667ae896032f60bba1f4419.gif][]

![c5a5c35d62016d92a56be1f8c18e859c.png][]

来源：[MySQL高可用工具—Orchestrator初识 - 腾讯云开发者社区-腾讯云][MySQL_Orchestrator_ - _-]

[Link 1]: https://cloud.tencent.com/solution/operation?from=10680
[MySQL]: https://cloud.tencent.com/product/cdb?from=10680
[Link 2]: https://cloud.tencent.com/solution/database?from=10680
[MySQL_Orchestrator]: http://mp.weixin.qq.com/s?__biz=MzA3NTMyNTI0NA==&mid=2648441427&idx=1&sn=4164b2f2d577e5fab66b94d7cbc15f48&chksm=875ae800b02d61165d44f5690fb28c72c7ad72276e895131e819d203564b9c636e01aa2cdf4d&scene=21#wechat_redirect
[c3717fca355f619bf5658ff6c8b93ea2.png]: https://img-blog.csdnimg.cn/img_convert/c3717fca355f619bf5658ff6c8b93ea2.png
[cff054881ea1f6eb44be1f89fc5e0ece.png]: https://img-blog.csdnimg.cn/img_convert/cff054881ea1f6eb44be1f89fc5e0ece.png
[ae2ed7f370204342a1d6aa8253398dee.png]: https://img-blog.csdnimg.cn/img_convert/ae2ed7f370204342a1d6aa8253398dee.png
[24fc21b730d0f7ec7e653843c60d7d5a.jpeg]: https://img-blog.csdnimg.cn/img_convert/24fc21b730d0f7ec7e653843c60d7d5a.jpeg
[fbf692372d74f4f3d070bd2065ce98a6.png]: https://img-blog.csdnimg.cn/img_convert/fbf692372d74f4f3d070bd2065ce98a6.png
[1e9ac6557667ae896032f60bba1f4419.gif]: https://img-blog.csdnimg.cn/img_convert/1e9ac6557667ae896032f60bba1f4419.gif
[e7fc9535cef2be28b25e012371a4a660.png]: https://img-blog.csdnimg.cn/img_convert/e7fc9535cef2be28b25e012371a4a660.png
[c5a5c35d62016d92a56be1f8c18e859c.png]: https://img-blog.csdnimg.cn/img_convert/c5a5c35d62016d92a56be1f8c18e859c.png
[MySQL_Orchestrator_ - _-]: https://cloud.tencent.com/developer/article/1523543?from=15425