Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to install the orchestrator Metabase MySQL

2025-01-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to install the orchestrator metabase MySQL", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to install the orchestrator metabase MySQL" this article.

Install the orchestrator Metabase MySQL the steps to install MySQL are omitted, just like the regular installation of MySQL. The libraries and users needed to create orchestrator after the installation is complete. CREATE DATABASE IF NOT EXISTS orchestrator;CREATE USER 'orchestrator'@'127.0.0.1' IDENTIFIED BY' orchestrator';GRANT ALL PRIVILEGES ON `orchestrator`. * TO 'orchestrator'@'127.0.0.1'; where the meta-database MySQL and orchestrator are on the same machine, so' 127.0.0.1'is used when creating an account. If it is not on the same machine, replace IP with the machine ip where orchestrator resides.

The password is changed as needed. Install orchestrator to download the orchestrator installation package, which is orchestrator-3.1.0-linux-amd64.tar.gz. Https://github.com/github/orchestrator/releases unzips the orchestrator installation package. Tar-xvzf orchestrator-3.1.0-linux-amd64.tar.gz-C /

Move / usr/local/orchestrator/orchestrator-sample.conf.json under / etc and name it orchestrator.conf.json.

[root@10-10-30-146orchestrator] # lsorchestrator orchestrator-sample-sqlite.conf.json orchestrator-sample.conf.json resources [root@10-10-30146 orchestrator] # cp orchestrator-sample.conf.json / etc/orchestrator.conf.json Target Monitoring Database Authorization is authorized on the target database that needs to be monitored. The target database here is: 10.10.30.129:3306CREATE USER 'orchestrator'@'orch_host' IDENTIFIED BY' orch_topology_password';GRANT SUPER, PROCESS, REPLICATION SLAVE, RELOAD ON *. * TO 'orchestrator'@'orch_host';GRANT SELECT ON mysql.slave_master_info TO' orchestrator'@'orch_host';GRANT SELECT ON ndbinfo.processes TO 'orchestrator'@'orch_host' -- Only for NDB Cluster, change the 'orch_host' to the ip,'orch_topology_password' of the server where the orch resides and change the appropriate password. Here orch_host is 10.10.30.146, change the password to orchestrator. Modify orchestrator configuration file modify / etc/orchestrator.conf.json as follows: / / configure orchestrator backend Metabase information. "MySQLOrchestratorHost": "127.0.0.1", "MySQLOrchestratorPort": 3306, "MySQLOrchestratorDatabase": "orchestrator", "MySQLOrchestratorUser": "orchestrator", "MySQLOrchestratorPassword": "orchestrator",. / / configure orchestrator monitoring target database information "MySQLTopologyUser": "orchestrator", "MySQLTopologyPassword": "orchestrator" Start orchestratorcd / usr/local/orchestrator & &. / orchestrator-- config=/etc/orchestrator.conf.json http &

The access address on the web side is 10.10.30.146Grou3000. The effect of the page is as follows:

The above is all the contents of the article "how to install the orchestrator Metabase MySQL". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report